Grouper Users - Open Discussion List

[Chris Hyzer <>]

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