Grouper Users - Open Discussion List

[Colin Hudler <>]

SHEESH, I just checked on a hunch and, yes, more than one grouper-daemon 
was started.  This is my mistake!  Let that go into the archives for 
some other poor soul.

On 04/28/2010 11:52 AM, Colin Hudler wrote:
> 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