Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Grouper Error after MySQL charset/collation change

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper Error after MySQL charset/collation change

Chronological Thread 
  • From: Chris Hyzer <>
  • To: "Waldbieser, Carl" <>, Gouper Users List <>
  • Subject: [grouper-users] RE: Grouper Error after MySQL charset/collation change
  • Date: Tue, 8 Dec 2015 15:06:14 +0000
  • Accept-language: en-US

Seems like your database is corrupt...

-----Original Message-----

On Behalf Of Waldbieser, Carl
Sent: Monday, December 07, 2015 4:28 PM
To: Gouper Users List
Subject: Re: [grouper-users] Grouper Error after MySQL charset/collation

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.


----- 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

Any idea what that might mean? The group is configured as a Grouper Loader

Carl Waldbieser
ITS Systems Programmer
Lafayette College

Archive powered by MHonArc 2.6.16.

Top of Page