grouper loader duplicate stem

__GROUPER_LOG_PREFIX__;grouper_error.log;;;2021-03-30 08:36:27,428: [pool-1-thread-430] ERROR GrouperLoaderType.syncOneGroupMembership(3241) -  - Problem with group: arizona.edu:course:2211:1:TAR:494:015:65286:instructoredu.internet2.middleware.grouper.exception.StemAddException: cannot create child stem: Problem in HibernateSession: HibernateSession (297a3be6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Exception in save: edu.internet2.middleware.grouper.Stem, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: null,Problem creating child stem: Stem[displayName=University of Arizona:Course:2211:1:TAR,name=arizona.edu:course:2211:1:TAR,uuid=71e5f38949bc458a99000225a2218569,creator=8142256ec0b54cfa97833be719e3a6a0], extn: 494, dExtn: 494, uuid: null, Problem in HibernateSession: HibernateSession (297a3be6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Exception in save: edu.internet2.middleware.grouper.Stem, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: null,Problem in HibernateSession: HibernateSession (1d5d6553): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Problem in HibernateSession: HibernateSession (7f3cdd0f): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (3bbfde3a),Problem saving group: arizona.edu:course:2211:1:TAR:494:015:65286:instructor, thread: 7d148207at edu.internet2.middleware.grouper.Stem$9.callback(Stem.java:2913)at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)at edu.internet2.middleware.grouper.Stem.internal_addChildStem(Stem.java:2835)at edu.internet2.middleware.grouper.Stem.addChildStem(Stem.java:619)at edu.internet2.middleware.grouper.Stem._createStemAndParentStemsIfNotExist(Stem.java:3928)at edu.internet2.middleware.grouper.GroupSave$1$1.callback(GroupSave.java:680)at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:976)at edu.internet2.middleware.grouper.GroupSave$1.callback(GroupSave.java:921)at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)at edu.internet2.middleware.grouper.GroupSave.save(GroupSave.java:589)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneGroupMembership(GrouperLoaderType.java:2770)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncGroupLogicForOneGroup(GrouperLoaderType.java:1994)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.access$200(GrouperLoaderType.java:119)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$13.callLogic(GrouperLoaderType.java:1873)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$13.callLogic(GrouperLoaderType.java:1863)at edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCallable.java:203)at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:976)at edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessionIfExists(GrouperCallable.java:200)at edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable.java:166)at java.util.concurrent.FutureTask.run(FutureTask.java:266)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)at java.lang.Thread.run(Thread.java:748)Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (297a3be6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Exception in save: edu.internet2.middleware.grouper.Stem, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: null,Problem creating child stem: Stem[displayName=University of Arizona:Course:2211:1:TAR,name=arizona.edu:course:2211:1:TAR,uuid=71e5f38949bc458a99000225a2218569,creator=8142256ec0b54cfa97833be719e3a6a0], extn: 494, dExtn: 494, uuid: null, Problem in HibernateSession: HibernateSession (297a3be6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Exception in save: edu.internet2.middleware.grouper.Stem, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: nullat edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.java:481)at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.createChildStem(Hib3StemDAO.java:233)at edu.internet2.middleware.grouper.Stem$9.callback(Stem.java:2878)... 26 moreCaused by: org.hibernate.exception.ConstraintViolationException: could not execute batch,Exception in save: edu.internet2.middleware.grouper.Stem, edu.internet2.middleware.grouper.hibernate.ByObject@56d72edcat org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119)at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97)at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214)at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:611)at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)at edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:222)at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectStatic.java:494)at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)... 29 moreCaused by: java.sql.BatchUpdateException: Batch entry 0 insert into grouper_stems (hibernate_version_number, parent_stem, name, display_name, creator_id, create_time, modifier_id, modify_time, display_extension, extension, description, last_membership_change, alternate_name, context_id, id_index, id) values (0, '71e5f38949bc458a99000225a2218569', 'arizona.edu:course:2211:1:TAR:494', 'University of Arizona:Course:2211:1:TAR:494', '8142256ec0b54cfa97833be719e3a6a0', 1617093387373, NULL, 0, '494', '494', NULL, NULL, NULL, '0bb99fe2a6314939a8b4eb288a4e83aa', 286737, '07e3df1152054dbb916b04be4435c53c') was aborted: ERROR: duplicate key value violates unique constraint "stem_name_idx"  Detail: Key (name)=(arizona.edu:course:2211:1:TAR:494) already exists.  Call getNextException to see other errors in the batch.at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:169)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2286)at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:521)at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:878)at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:901)at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1644)at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)... 40 moreCaused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "stem_name_idx"  Detail: Key (name)=(arizona.edu:course:2211:1:TAR:494) already exists.at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)... 46 more__GROUPER_LOG_PREFIX__;grouper_error.log;;;2021-03-30 08:36:27,434: [pool-1-thread-430] ERROR GrouperLoaderType.syncGroupLogicForOneGroup(2004) -  - Error in job for group: arizona.edu:course:2211:1:TAR:494:015:65286:instructorjava.lang.RuntimeException: Problem with group: arizona.edu:course:2211:1:TAR:494:015:65286:instructorat edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneGroupMembership(GrouperLoaderType.java:3242)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncGroupLogicForOneGroup(GrouperLoaderType.java:1994)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.access$200(GrouperLoaderType.java:119)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$13.callLogic(GrouperLoaderType.java:1873)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$13.callLogic(GrouperLoaderType.java:1863)at edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCallable.java:203)at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:976)at edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessionIfExists(GrouperCallable.java:200)at edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable.java:166)at java.util.concurrent.FutureTask.run(FutureTask.java:266)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)at java.lang.Thread.run(Thread.java:748)Caused by: edu.internet2.middleware.grouper.exception.StemAddException: cannot create child stem: Problem in HibernateSession: HibernateSession (297a3be6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Exception in save: edu.internet2.middleware.grouper.Stem, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: null,Problem creating child stem: Stem[displayName=University of Arizona:Course:2211:1:TAR,name=arizona.edu:course:2211:1:TAR,uuid=71e5f38949bc458a99000225a2218569,creator=8142256ec0b54cfa97833be719e3a6a0], extn: 494, dExtn: 494, uuid: null, Problem in HibernateSession: HibernateSession (297a3be6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Exception in save: edu.internet2.middleware.grouper.Stem, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: null,Problem in HibernateSession: HibernateSession (1d5d6553): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Problem in HibernateSession: HibernateSession (7f3cdd0f): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (3bbfde3a),Problem saving group: arizona.edu:course:2211:1:TAR:494:015:65286:instructor, thread: 7d148207at edu.internet2.middleware.grouper.Stem$9.callback(Stem.java:2913)at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)at edu.internet2.middleware.grouper.Stem.internal_addChildStem(Stem.java:2835)at edu.internet2.middleware.grouper.Stem.addChildStem(Stem.java:619)at edu.internet2.middleware.grouper.Stem._createStemAndParentStemsIfNotExist(Stem.java:3928)at edu.internet2.middleware.grouper.GroupSave$1$1.callback(GroupSave.java:680)at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:976)at edu.internet2.middleware.grouper.GroupSave$1.callback(GroupSave.java:921)at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO$1.callback(Hib3TransactionDAO.java:66)at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3TransactionDAO.transactionCallback(Hib3TransactionDAO.java:56)at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:87)at edu.internet2.middleware.grouper.hibernate.GrouperTransaction.callbackGrouperTransaction(GrouperTransaction.java:106)at edu.internet2.middleware.grouper.GroupSave.save(GroupSave.java:589)at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneGroupMembership(GrouperLoaderType.java:2770)... 12 moreCaused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (297a3be6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Exception in save: edu.internet2.middleware.grouper.Stem, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: null,Problem creating child stem: Stem[displayName=University of Arizona:Course:2211:1:TAR,name=arizona.edu:course:2211:1:TAR,uuid=71e5f38949bc458a99000225a2218569,creator=8142256ec0b54cfa97833be719e3a6a0], extn: 494, dExtn: 494, uuid: null, Problem in HibernateSession: HibernateSession (297a3be6): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (3bbfde3a),Exception in save: edu.internet2.middleware.grouper.Stem, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: null, tx type: nullat edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)at edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.java:481)at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.createChildStem(Hib3StemDAO.java:233)at edu.internet2.middleware.grouper.Stem$9.callback(Stem.java:2878)... 26 moreCaused by: org.hibernate.exception.ConstraintViolationException: could not execute batch,Exception in save: edu.internet2.middleware.grouper.Stem, edu.internet2.middleware.grouper.hibernate.ByObject@56d72edcat org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119)at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97)at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:214)at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:611)at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)at edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:222)at edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectStatic.java:494)at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)... 29 moreCaused by: java.sql.BatchUpdateException: Batch entry 0 insert into grouper_stems (hibernate_version_number, parent_stem, name, display_name, creator_id, create_time, modifier_id, modify_time, display_extension, extension, description, last_membership_change, alternate_name, context_id, id_index, id) values (0, '71e5f38949bc458a99000225a2218569', 'arizona.edu:course:2211:1:TAR:494', 'University of Arizona:Course:2211:1:TAR:494', '8142256ec0b54cfa97833be719e3a6a0', 1617093387373, NULL, 0, '494', '494', NULL, NULL, NULL, '0bb99fe2a6314939a8b4eb288a4e83aa', 286737, '07e3df1152054dbb916b04be4435c53c') was aborted: ERROR: duplicate key value violates unique constraint "stem_name_idx"  Detail: Key (name)=(arizona.edu:course:2211:1:TAR:494) already exists.  Call getNextException to see other errors in the batch.at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:169)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2286)at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:521)at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:878)at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:901)at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1644)at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)... 40 moreCaused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "stem_name_idx"  Detail: Key (name)=(arizona.edu:course:2211:1:TAR:494) already exists.at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)... 46 more