Grouper Users - Open Discussion List

[Shilen Patel <>]

I think this happens because Grouper will cache the next sequence number
to use for the change log and if the job switches servers, then the next
sequence number cached would have probably already been used by the other
server (thus the constraint violation).  I'll open a jira.

Thanks!

- Shilen

On 10/16/16, 4:15 PM, "Michael R. Gettes" 
<>
 wrote:

>Recently, we turned on running the loader on 2 hosts instead of just one.
> Prior to running multiple loaders we did NOT see this problem.
>This detail may have nothing to do with anything - just an observation.
>
>About 200 times per day we are now seeing the following error - any
>advice is appreciated.
>The errors are on the CHANGE_LOG_changeLogTempToChangeLog job.
>
>edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
>Problem in HibernateSession: HibernateSession (5dcad092): notNew,
>notReadonly, READ_WRITE_NEW, activeTransaction, session (26148b8e),
>Exception in save:
>edu.internet2.middleware.grouper.changeLog.ChangeLogEntry,
>ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName:
>ChangeLogEntryEntity, tx type: null,
>Exception in save: edu.internet2.middleware.grouper.pit.PITMembership,
>edu.internet2.middleware.grouper.hibernate.ByObject@ed62b2a,
>Problem in HibernateSession: HibernateSession (7929e2c0): notNew,
>notReadonly, READ_WRITE_NEW, activeTransaction, session (26148b8e),
>Exception in saveOrUpdate:
>edu.internet2.middleware.grouper.pit.PITMembership, ByObjectStatic,
>query: ', cacheable: null, cacheRegion: null, entityName: null, tx type:
>null,
>Problem in HibernateSession: HibernateSession (9846e71): new,
>notReadonly, READ_WRITE_NEW, notActiveTransaction, session (26148b8e)
>       at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibe
>rnateSessionCatch(HibernateSession.java:588)
>       at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:710)
>       at 
>edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveBatch(ByObje
>ctStatic.java:535)
>       at 
>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3ChangeLogEntryDAO.s
>aveBatch(Hib3ChangeLogEntryDAO.java:61)
>       at 
>edu.internet2.middleware.grouper.pit.PITMembership.onPreUpdate(PITMembersh
>ip.java:665)
>       at 
>edu.internet2.middleware.grouper.hibernate.ByObject.saveOrUpdate(ByObject.
>java:377)
>       at 
>edu.internet2.middleware.grouper.hibernate.ByObjectStatic$5.callback(ByObj
>ectStatic.java:376)
>       at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:700)
>       at 
>edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveOrUpdate(ByO
>bjectStatic.java:363)
>       at 
>edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.sa
>veOrUpdate(Hib3PITMembershipDAO.java:41)
>       at 
>edu.internet2.middleware.grouper.pit.PITMembership.update(PITMembership.ja
>va:298)
>       at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processMe
>mbershipDelete(ChangeLogTempToEntity.java:892)
>       at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$18
>00(ChangeLogTempToEntity.java:63)
>       at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callbac
>k(ChangeLogTempToEntity.java:144)
>       at 
>edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibern
>ateSession(HibernateSession.java:700)
>       at 
>edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRe
>cords(ChangeLogTempToEntity.java:98)
>       at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(Gro
>uperLoaderType.java:590)
>       at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(Groupe
>rLoaderJob.java:416)
>       at 
>edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(Group
>erLoaderJob.java:318)
>       at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
>       at 
>org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:5
>73)
>Caused by: org.hibernate.exception.ConstraintViolationException: could
>not execute batch,
>Exception in save:
>edu.internet2.middleware.grouper.changeLog.ChangeLogEntry,
>edu.internet2.middleware.grouper.hibernate.ByObject@200750d
>       at 
>org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLSta
>teConversionDelegate.java:112)
>       at 
>org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(Sta
>ndardSQLExceptionConverter.java:42)
>       at 
>org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelpe
>r.java:109)
>       at 
>org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(Ba
>tchingBatch.java:119)
>       at 
>org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(Batc
>hingBatch.java:97)
>       at 
>org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(Abstrac
>tBatchImpl.java:147)
>       at org.hibernate.engine.jd
>
>