Grouper Users - Open Discussion List

[Shilen Patel <>]

Hi Peter,

It sounds like you were processing a lot of membership deletes.  Or at
least, it was a membership delete that caused the problem.  Can you see
from the logs which membership it was working on before the exception?
And then see if there¹s anything noteworthy about that membership.  For
example, was the member a group and if so, did that group have a lot of
members that were also groups?  Or was the owner group a member of a lot
of groups?

Thanks!

- Shilen

On 8/12/15, 10:39 PM, "Peter DiCamillo" 
<>
 wrote:

>I'm having a problem with Grouper getting the error " ORA-01555:
>snapshot too old: rollback segment number 7 with name
>"_SYSSMU7_992134567$" too small". I first saw this in the Grouper Loader
>log after making a very large number of group changes. The Grouper
>Loader got "stuck" processing a change that generated that error, never
>processing any subsequent changes. This was with our dev Grouper, so I
>tried to fix it by truncating the change log temp table. That did get
>the Grouper Loader back to normal. However, when I subsequently ran
>syncAllPITTables, the error showed up again, and prevents getting all
>the tables synced. I've included the error text below.
>
>When I researched this I found web pages such as this one:
>http://www.dba-oracle.com/t_ora_01555_snapshot_old.htm As best I can
>tell, the fix for this may be to change settings in the database or
>increase the size of the rollback segment. However, there also could be
>problems with how commits and fetches are done. This is with Oracle 11g,
>and there was no other Grouper activity when I ran syncAllPITTables. I
>also ran syncAllPITTables multiple times and got the same error.
>
>Any idea whether this should be fixed in Grouper or in the database? The
>group changes I made in dev I will also be making in production, so I
>need to understand what the issue is here.
>
>Peter
>
>Error from syncAllPITTables:
>
>Searching for point in time memberships that should be inactive
>Found 5472 active point in time memberships that should be inactive
>// Error: unable to evaluate command: Sourced file: inline evaluation
>of: ``new 
>edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables();'
>' 
>: Method Invocation syncAllPITTables
>// See error log for full stacktrace
>// caused by: 
>edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
>// Problem in HibernateSession: HibernateSession (21875b11): notNew,
>notReadonly, READ_WRITE_NEW, activeTransaction, session (67c1e630),
>Exception in list: (class [Ljava.lang.Object;), ByHqlStatic, query:
>'select distinct ms, m from PITMembership as ms, PITMember as m where
>ms.ownerId = :msOwnerId and ms.fieldId = :msFieldId and ms.activeDb =
>'T' and not exists (select 1 from PITMembershipView ms2 where
>ms2.ownerId = :ms2OwnerId and ms2.memberId = ms.memberId and ms2.fieldId
>= :ms2FieldId and ms2.groupSetActiveDb = 'T' and ms2.membershipActiveDb
>= 'T' and ms2.groupSetId <> :ms2GroupSetId)and ms.memberId = m.id',
>cacheable: false, cacheRegion:
>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipViewDA
>O.FindPITMembershipsJoinedWithOldPITGroupSet,
>tx type: null, tx type: nullBind var[0]: 'Param (class
>java.lang.String): 'msOwnerId'->'c9deb6fda6ec48fca014479386b1eb62', Bind
>var[1]: 'Param (class java.lang.String):
>'msFieldId'->'f4fff7bdf18c46b7bdb147e1bfc1c9e0', Bind var[2]: 'Param
>(class java.lang.String):
>'ms2OwnerId'->'6e5cf2961a7047ee97223b5423a3227d', Bind var[3]: 'Param
>(class java.lang.String):
>'ms2FieldId'->'f4fff7bdf18c46b7bdb147e1bfc1c9e0'Bind var[4]: 'Param
>(class java.lang.String):
>'ms2GroupSetId'->'c347dbe38eb94936af69dac5c43c59a4', ,
>Exception in save: edu.internet2.middleware.grouper.pit.PITGroupSet,
>edu.internet2.middleware.grouper.hibernate.ByObject@14baaea8,
>Problem in HibernateSession: HibernateSession (79f0940a): notNew,
>notReadonly, READ_WRITE_NEW, activeTransaction, session (67c1e630),
>Exception in saveOrUpdate:
>edu.internet2.middleware.grouper.pit.PITGroupSet, ByObjectStatic, query:
>', cacheable: null, cacheRegion: null, entityName: null, tx type: null,
>Exception in save: edu.internet2.middleware.grouper.pit.PITMembership,
>edu.internet2.middleware.grouper.hibernate.ByObject@6c20a239,
>Problem in HibernateSession: HibernateSession (435e7f1a): new,
>notReadonly, READ_WRITE_NEW, notActiveTransaction, session (67c1e630),
>Exception in saveOrUpdate:
>edu.internet2.middleware.grouper.pit.PITMembership, ByObjectStatic,
>query: ', cacheable: null, cacheRegion: null, entityName: null, tx type:
>null
>// caused by: org.hibernate.QueryTimeoutException:
>// could not execute query
>// caused by: java.sql.SQLException:
>// ORA-01555: snapshot too old: rollback segment number 7 with name
>"_SYSSMU7_992134567$" too small
>