Skip to Content.
Sympa Menu

grouper-users - [grouper-users] CHANGE_LOG_changeLogTempToChangeLog error: Duplicate entry for key grouper_change_log_entry.PRIMARY

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] CHANGE_LOG_changeLogTempToChangeLog error: Duplicate entry for key grouper_change_log_entry.PRIMARY


Chronological Thread 
  • From: Baron Fujimoto <>
  • To: Grouper Users <>
  • Subject: [grouper-users] CHANGE_LOG_changeLogTempToChangeLog error: Duplicate entry for key grouper_change_log_entry.PRIMARY
  • Date: Fri, 15 Jul 2022 09:51:33 -1000

We've recently begun encountering errors while trying to run CHANGE_LOG_changeLogTempToChangeLog from gsh (grouper v2.2.2):

It throws the following exception:

ERROR GrouperLoaderJob.runJob(433) -  - Error on job: CHANGE_LOG_changeLogTempToChangeLog
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (715a70e9): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (24043ec5),
Exception in save: edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, 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@3e33b52e,
Problem in HibernateSession: HibernateSession (16a5c7e4): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (24043ec5),
Exception in saveOrUpdate: edu.internet2.middleware.grouper.pit.PITMembership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: null,
Problem in HibernateSession: HibernateSession (634ff56): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (24043ec5)
[...]
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update,
Exception in save: edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.hibernate.ByObject@61ff6a49
[...]
Caused by: java.sql.BatchUpdateException: Duplicate entry '154643517' for key 'grouper_change_log_entry.PRIMARY'
[...]
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '154643517' for key 'grouper_change_log_entry.PRIMARY'

I notice that if I re-run the job, we get a different entry value each time. E.g.:

ERROR JDBCExceptionReporter.logExceptions(234) -  - Duplicate entry '154643295' for key 'grouper_change_log_entry.PRIMARY'
Caused by: java.sql.BatchUpdateException: Duplicate entry '154643295' for key 'grouper_change_log_entry.PRIMARY'
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '154643295' for key 'grouper_change_log_entry.PRIMARY'
ERROR JDBCExceptionReporter.logExceptions(234) -  - Duplicate entry '154643304' for key 'grouper_change_log_entry.PRIMARY'
Caused by: java.sql.BatchUpdateException: Duplicate entry '154643304' for key 'grouper_change_log_entry.PRIMARY'
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '154643304' for key 'grouper_change_log_entry.PRIMARY'
ERROR JDBCExceptionReporter.logExceptions(234) -  - Duplicate entry '154643517' for key 'grouper_change_log_entry.PRIMARY'
Caused by: java.sql.BatchUpdateException: Duplicate entry '154643517' for key 'grouper_change_log_entry.PRIMARY'
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '154643517' for key 'grouper_change_log_entry.PRIMARY'

Any suggestions on how to troubleshoot and resolve this?
--
Baron Fujimoto <> ::: UH Information Technology Services
minutas cantorum, minutas balorum, minutas carboratum descendus pantorum



Archive powered by MHonArc 2.6.24.

Top of Page