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" <>
  • Cc: Gouper Users List <>
  • Subject: [grouper-users] RE: Grouper Error after MySQL charset/collation change
  • Date: Tue, 8 Dec 2015 15:17:23 +0000
  • Accept-language: en-US

That’s a terrible error message... good luck! :)

-----Original Message-----
From: Waldbieser, Carl
[mailto:]

Sent: Tuesday, December 08, 2015 10:15 AM
To: Chris Hyzer
Cc: Gouper Users List
Subject: Re: Grouper Error after MySQL charset/collation change

Chris,

If you scroll down the SO answers a bit, the one that seems to align with my
observations starts:

Your query is generating a result set so large that it needs to build a
temporary table
either to hold some of the results or some intermediate product used in
generating the result.

I am hypothesizing that a combination of large group membership and small
/tmp space are causing the issue. Since the issue didn't crop up before the
charset and collation were changed, I suppose that there may be something in
the MySQL internals that requires more temp space for utf8_bin than for
latin1_swedish_ci.

I've requested more space for the /tmp volume to see if that alleviates the
issue.

Thanks,
Carl

----- Original Message -----
From: "Chris Hyzer"
<>
To: "waldbiec"
<>,
"Gouper Users List"
<>
Sent: Tuesday, December 8, 2015 10:06:14 AM
Subject: RE: Grouper Error after MySQL charset/collation change

Seems like your database is corrupt...

http://stackoverflow.com/questions/2428738/how-do-you-fix-a-mysql-incorrect-key-file-error-when-you-cant-repair-the-tabl



-----Original Message-----
From:


[mailto:]
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
change

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



Archive powered by MHonArc 2.6.16.

Top of Page