Grouper Users - Open Discussion List

[Colin Hudler <>]

I get this error each time the CHANGE_LOG_changeLogTempToChangeLog job 
runs.  It worked fine until today.  I am not sure of the cause or the 
fix, for that matter.  This job is enabled because we intend to use the 
changelog notifications feature at some point; I am not really clear on 
the role this job plays in that.  Any help diagnosing the problem is 
appreciated.

2010-04-28 11:40:51,531: [DefaultQuartzScheduler_Worker-4] ERROR 
GrouperLoaderJob.runJob(296) - Error on job: 
CHANGE_LOG_changeLogTempToChangeLog
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: 
Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW,
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:358)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:444)
        at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.java:435)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3ChangeLogEntryDAO.save(Hib3ChangeLogEntryDAO.java:31)
        at 
edu.internet2.middleware.grouper.changeLog.ChangeLogEntry.save(ChangeLogEntry.java:290)
        at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callback(ChangeLogTempToEntity.java:55)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:434)
        at 
edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRecords(ChangeLogTempToEntity.java:48)
        at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.syncGroupMembership(GrouperLoaderType.java:737)
        at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:288)
        at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:192)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at 
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.hibernate.exception.ConstraintViolationException: Could 
not execute JDBC batch update
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
        at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
        at 
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
        at 
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at 
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at 
edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:189)
        at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectStatic.java:448)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:434)
        ... 11 more
Caused by: java.sql.BatchUpdateException: Duplicate entry '4022628' for 
key 1
        at 
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
        at 
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
        at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
        at 
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
        at 
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
        ... 19 more