Grouper Users - Open Discussion List

[Peter DiCamillo <>]

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