grouper-users - Re: [grouper-users] Grouper Error after MySQL charset/collation change
Subject: Grouper Users - Open Discussion List
List archive
- From: "Waldbieser, Carl" <>
- To: Gouper Users List <>
- Subject: Re: [grouper-users] Grouper Error after MySQL charset/collation change
- Date: Mon, 7 Dec 2015 16:28:21 -0500 (EST)
I tracked this down a bit further.
The Grouper logs had the following clue:
Caused by: java.sql.SQLException: Incorrect key file for table
'/tmp/#sql_b8e_0.MYI'; try to repair it
I monitored the /tmp volume on the database server when I tried to view the
group (which has ~ 28,800 members). The free space dropped dramatically when
I tried to view the group members.
I am not sure if there is something I can do to optimize the tables, or if I
just need to add more space to /tmp.
Thanks,
Carl
----- Original Message -----
From: "waldbiec"
<>
To: "Gouper Users List"
<>
Sent: Monday, December 7, 2015 12:01:16 PM
Subject: [grouper-users] Grouper Error after MySQL charset/collation change
In a testing instance of Grouper v2.2.2, we tried updating the database
collation to utf8_bin.
I have an outline of the steps our DBA used, if that is relevant.
When the database was restored and I re-enabled the test instance, most
things worked fine, but one group issued a Java stack trace when I tried to
view it:
Error: Problem in HibernateSession: HibernateSession (3d92ab11): new,
readonly, READONLY_NEW, notActiveTransaction, session (17c96394), Exception
in list: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query:
'select distinct m from Member m, MembershipEntry ms, Group g, Field f where
ms.ownerGroupId = g.uuid and ms.memberUuid = m.uuid and ms.enabledDb = 'T'
and ms.fieldId = f.uuid and f.typeString = 'list' and ms.ownerGroupId in
(:SR6GXF6M0) ', cacheable: false, cacheRegion:
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx
type: null, options: QueryOptions: queryPaging: pageSize: 50,
pageNumberOnIndexed: 1, querySort: m.sortString0 asc, , tx type: nullBind
var[0]: 'Param (class java.lang.String):
'SR6GXF6M0'->'5461be27a8d844239ebd59990a360d31', , Problem calling method
updateLoaderGroup on
edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2Group
Any idea what that might mean? The group is configured as a Grouper Loader
group.
Thanks,
Carl Waldbieser
ITS Systems Programmer
Lafayette College
- [grouper-users] Grouper Error after MySQL charset/collation change, Waldbieser, Carl, 12/07/2015
- Re: [grouper-users] Grouper Error after MySQL charset/collation change, Waldbieser, Carl, 12/07/2015
- [grouper-users] RE: Grouper Error after MySQL charset/collation change, Chris Hyzer, 12/08/2015
- [grouper-users] Re: Grouper Error after MySQL charset/collation change, Waldbieser, Carl, 12/08/2015
- [grouper-users] RE: Grouper Error after MySQL charset/collation change, Chris Hyzer, 12/08/2015
- [grouper-users] Re: Grouper Error after MySQL charset/collation change, Waldbieser, Carl, 12/08/2015
- [grouper-users] RE: Grouper Error after MySQL charset/collation change, Chris Hyzer, 12/08/2015
- Re: [grouper-users] Grouper Error after MySQL charset/collation change, Waldbieser, Carl, 12/07/2015
Archive powered by MHonArc 2.6.16.