Joel Rettinger
|
1 hour ago
|
When running one of the post-install tasks for 2.6.17 in a gsh shell, as described on https://spaces.at.internet2.edu/display/Grouper/v2.6+Upgrade+Instructions+from+v2.6 , the first statement runs for several minutes:
|
new SyncPITTables().processMissingInactivePITGroupSets();
|
--
|
Searching for point in time group sets that should be inactive
|
Found 83 active point in time group sets that should be inactive
|
then throws this error:
|
ERROR javax.persistence.PersistenceException:
|
org.hibernate.exception.ConstraintViolationException: could not execute batch,
|
Exception in save: edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.ch
|
angeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.group
|
er.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.middle
|
ware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.m
|
iddleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.intern
|
et2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, , edu
|
.internet2.middleware.grouper.hibernate.ByObject@2a34280e,
|
Problem in HibernateSession: HibernateSession (265d4bb0): notNew, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (3964723d),
|
Exception in save: edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.ch
|
angeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.group
|
er.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.middle
|
ware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.m
|
iddleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.intern
|
et2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, edu.internet2.middleware.grouper.changeLog.ChangeLogEntry, , ByO
|
bjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ChangeLogEntryEntity, tx type: null,
|
Exception in save: edu.internet2.middleware.grouper.pit.PITGroupSet, edu.internet2.middleware.grouper.hibernate.ByObject@4b4827f4,
|
Problem in HibernateSession: HibernateSession (2f6f175): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (3964723d),
|
Exception in saveOrUpdate: edu.internet2.middleware.grouper.pit.PITGroupSet, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: null
|
at org.hibernate.internal.ExceptionConverterImpl.convert (ExceptionConverterImpl.java:154)
|
at org.hibernate.internal.ExceptionConverterImpl.convert (ExceptionConverterImpl.java:181)
|
at org.hibernate.internal.ExceptionConverterImpl.convert (ExceptionConverterImpl.java:188)
|
at org.hibernate.internal.SessionImpl.doFlush (SessionImpl.java:1411)
|
at org.hibernate.internal.SessionImpl.flush (SessionImpl.java:1394)
|
at edu.internet2.middleware.grouper.hibernate.ByObject.saveBatch (ByObject.java:363)
|
at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$8.callback (ByObjectStatic.java:548)
|
at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession (HibernateSession.java:722)
|
at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveBatch (ByObjectStatic.java:535)
|
at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3ChangeLogEntryDAO.saveBatch (Hib3ChangeLogEntryDAO.java:62)
|
at edu.internet2.middleware.grouper.pit.PITGroupSet.onPreUpdate (PITGroupSet.java:767)
|
at edu.internet2.middleware.grouper.hibernate.ByObject.saveOrUpdate (ByObject.java:466)
|
at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$5.callback (ByObjectStatic.java:376)
|
at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession (HibernateSession.java:722)
|
at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.saveOrUpdate (ByObjectStatic.java:363)
|
at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITGroupSetDAO.saveOrUpdate (Hib3PITGroupSetDAO.java:50)
|
at edu.internet2.middleware.grouper.pit.PITGroupSet.saveOrUpdate (PITGroupSet.java:348)
|
at edu.internet2.middleware.grouper.misc.SyncPITTables.processMissingInactivePITGroupSets (SyncPITTables.java:1439)
|
at edu.internet2.middleware.grouper.misc.SyncPITTables$processMissingInactivePITGroupSets.call (Unknown Source)
|
|
|
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198)
|
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633)
|
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
|
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
|
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
|
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344)
|
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
|
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)
|
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
|
... 25 more
|
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into grouper_change_log_entry (change_log_type_id, context_id, created_on, string01, string02, string03, string04, string05, string06, string07, string08, string09, string10, string11, string12, sequence_number) values ('8f33a688384449dda983a6f005bed0aa', NULL, 1667426779125000, 'c87ccfbc8105450e8d915e4ba4ba37ec', 'members', 'bartc', 'ldap', 'flattened', '9f9a85feb18648bca8399e10a1e6de40', 'iu:roles:ref:cg:staff', 'bf3e6eb030cc476197049f98198747b4', '99b89be4f94e4130bb92b6a1f6464e45', NULL, '0000968656', NULL, 77095178) was aborted: ERROR: duplicate key value violates unique constraint "sys_c005274"
|
Detail: Key (sequence_number)=(77095178) already exists. Call getNextException to see other errors in the batch.
|
at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:165)
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2367)
|
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:560)
|
at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:887)
|
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:910)
|
at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1663)
|
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)
|
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:125)
|
... 36 more
|
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sys_c005274"
|
Detail: Key (sequence_number)=(77095178) already exists.
|
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
|
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
|
... 42 more
|
|
|
Improvement
Minor