Grouper Users - Open Discussion List

["Michael R. Gettes" <>]

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_hibernateSessionCatch(HibernateSession.java:588)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:710)
        at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveBatch(ByObjectStatic.java:535)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3ChangeLogEntryDAO.saveBatch(Hib3ChangeLogEntryDAO.java:61)
        at 
edu.internet2.middleware.grouper.pit.PITMembership.onPreUpdate(PITMembership.java:665)
        at 
edu.internet2.middleware.grouper.hibernate.ByObject.saveOrUpdate(ByObject.java:377)
        at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic$5.callback(ByObjectStatic.java:376)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)
        at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveOrUpdate(ByObjectStatic.java:363)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMembershipDAO.saveOrUpdate(Hib3PITMembershipDAO.java:41)
        at 
edu.internet2.middleware.grouper.pit.PITMembership.update(PITMembership.java:298)
        at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processMembershipDelete(ChangeLogTempToEntity.java:892)
        at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$1800(ChangeLogTempToEntity.java:63)
        at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callback(ChangeLogTempToEntity.java:144)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:700)
        at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRecords(ChangeLogTempToEntity.java:98)
        at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(GrouperLoaderType.java:590)
        at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:416)
        at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:318)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at 
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
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(SQLStateConversionDelegate.java:112)
        at 
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
        at 
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
        at 
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119)
        at 
org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97)
        at 
org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)
        at org.hibernate.engine.jd