Grouper Users - Open Discussion List

[Baron Fujimoto <>]

FWIW, the next time I ran this, I didn't encounter the error, so perhaps each run corrected one until they were all fixed, or something happened in the intervening period that cleaned things up. *shrug*

On Fri, Jul 15, 2022 at 9:51 AM Baron Fujimoto <> wrote:

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

--

Baron Fujimoto <> ::: UH Information Technology Services
minutas cantorum, minutas balorum, minutas carboratum descendus pantorum