Error on unique last modifier index on midpoint provisioner

2024-05-29T02:12:12,636: [main] ERROR GrouperProvisionerTargetDaoAdapter.logError(288) - [] - Provisioner 'midPointProvTest' (v61prm9k) Error deleting groups, e.g. Group(matchingAttrs: ArrayList(1): [0]: [id_index, val: 1000029, compareVal: 1000029, currentValue: true], attr[deleted]: "F", attr[description]: <null>, attr[displayName]: <null>, attr[display_name]: "test:testGroup", attr[group_name]: "test:testGroup", attr[id]: <null>, attr[idIndex]: <null>, attr[id_index]: 1000029, attr[last_modified]: 1716963120874, attr[name]: <null>, attr[target]: TreeSet(2): [0]: a, [1]: b, del group_name "test:testGroup", del id_index 1000029, del display_name "test:testGroup", del description <null>, del target "a", del target "b", del id <null>, del displayName <null>, del name <null>, del idIndex <null>, del last_modified 1716963120874, del deleted "F")

(v61prm9k): java.lang.RuntimeException: sql: update gr_mp_group_attributes set deleted = ? , last_modified = ?  where group_id_index = ? , 

(v61prm9k): 	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2403)

(v61prm9k): 	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.executeBatchSql(GcDbAccess.java:2449)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.sqlProvisioning.SqlProvisionerCommands.updateObjectsOldValueNotNull(SqlProvisionerCommands.java:590)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.sqlProvisioning.SqlProvisionerCommands.updateObjects(SqlProvisionerCommands.java:475)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.sqlProvisioning.SqlProvisioningDao.deleteGroups(SqlProvisioningDao.java:846)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.deleteGroupsHelper(GrouperProvisionerTargetDaoAdapter.java:3944)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter$29.callLogic(GrouperProvisionerTargetDaoAdapter.java:3889)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter$29.callLogic(GrouperProvisionerTargetDaoAdapter.java:1)

(v61prm9k): 	at edu.internet2.middleware.grouper.util.GrouperUtil.executorServiceSubmit(GrouperUtil.java:14500)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.deleteGroups(GrouperProvisionerTargetDaoAdapter.java:3916)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.sendGroupChangesToTarget(GrouperProvisionerTargetDaoAdapter.java:467)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.targetDao.GrouperProvisionerTargetDaoAdapter.sendChangesToTarget(GrouperProvisionerTargetDaoAdapter.java:384)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningLogic.provisionIncremental(GrouperProvisioningLogic.java:1230)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningType$3.provision(GrouperProvisioningType.java:100)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningLogic.provision(GrouperProvisioningLogic.java:77)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioner.provision(GrouperProvisioner.java:855)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.ProvisioningConsumer.dispatchEventList(ProvisioningConsumer.java:91)

(v61prm9k): 	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:511)

(v61prm9k): 	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:406)

(v61prm9k): 	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:249)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$6.runJob(GrouperLoaderType.java:644)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:554)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.loader.GrouperLoader.runOnceByJobName(GrouperLoader.java:1813)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.loader.GrouperLoader.runOnceByJobName(GrouperLoader.java:1759)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningBaseTest.incrementalProvision(GrouperProvisioningBaseTest.java:118)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.provisioning.GrouperProvisioningBaseTest.incrementalProvision(GrouperProvisioningBaseTest.java:83)

(v61prm9k): 	at edu.internet2.middleware.grouper.app.midPointProvisioning.MidPointProvisionerTest.testFullIncrementalMidPointProvisioner(MidPointProvisionerTest.java:491)

(v61prm9k): 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

(v61prm9k): 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

(v61prm9k): 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

(v61prm9k): 	at java.base/java.lang.reflect.Method.invoke(Method.java:568)

(v61prm9k): 	at junit.framework.TestCase.runTest(TestCase.java:177)

(v61prm9k): 	at junit.framework.TestCase.runBare(TestCase.java:142)

(v61prm9k): 	at junit.framework.TestResult$1.protect(TestResult.java:122)

(v61prm9k): 	at junit.framework.TestResult.runProtected(TestResult.java:142)

(v61prm9k): 	at junit.framework.TestResult.run(TestResult.java:125)

(v61prm9k): 	at junit.framework.TestCase.run(TestCase.java:130)

(v61prm9k): 	at junit.framework.TestSuite.runTest(TestSuite.java:241)

(v61prm9k): 	at junit.framework.TestSuite.run(TestSuite.java:236)

(v61prm9k): 	at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)

(v61prm9k): 	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:93)

(v61prm9k): 	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:40)

(v61prm9k): 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:529)

(v61prm9k): 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:756)

(v61prm9k): 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:452)

(v61prm9k): 	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:210)

(v61prm9k): Caused by: java.sql.BatchUpdateException: Batch entry 0 update gr_mp_group_attributes set deleted = ('T') , last_modified = ('1716963132626'::int8)  where group_id_index = ('1000029'::int8)  was aborted: ERROR: duplicate key value violates unique constraint "gr_mp_group_attributes_ldx"

(v61prm9k):   Detail: Key (last_modified)=(1716963132626) already exists.  Call getNextException to see other errors in the batch.

(v61prm9k): 	at org.postgresql.jdbc.BatchResultHandler.handleCompletion(BatchResultHandler.java:186)

(v61prm9k): 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:590)

(v61prm9k): 	at org.postgresql.jdbc.PgStatement.internalExecuteBatch(PgStatement.java:912)

(v61prm9k): 	at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:936)

(v61prm9k): 	at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1733)

(v61prm9k): 	at com.p6spy.engine.logging.P6LogPreparedStatement.executeBatch(P6LogPreparedStatement.java:332)

(v61prm9k): 	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)

(v61prm9k): 	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2386)

(v61prm9k): 	... 45 more

(v61prm9k): Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "gr_mp_group_attributes_ldx"

(v61prm9k):   Detail: Key (last_modified)=(1716963132626) already exists.

(v61prm9k): 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)

(v61prm9k): 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)

(v61prm9k): 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:579)

(v61prm9k): 	... 51 more

(v61prm9k):