数据同步报错,怎么回事

com.fr.third.org.hibernate.exception.ConstraintViolationException: could not execute batch

at com.fr.third.org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)

at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)

at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119)

at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97)

at com.fr.third.org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)

at com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:236)

at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:617)

at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:462)

at com.fr.third.org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:335)

at com.fr.third.org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

at com.fr.third.org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1294)

at com.fr.stable.db.session.SessionManager$DBSessionImpl.flush(SessionManager.java)

at com.fr.cbb.platform.scaffold.hibernate.api.PSDAOSessionStore$1.remove(PSDAOSessionStore.java:46)

at com.fr.stable.db.dao.BaseDAO.remove(BaseDAO.java:73)

at com.fr.decision.authority.controller.personnel.PersonnelControllerImpl.removeUserRoleMiddle(PersonnelControllerImpl.java:353)

at com.fr.decision.authority.controller.personnel.PersonnelControllerImpl.clearUserRoleMiddle(PersonnelControllerImpl.java:342)

at com.fr.decision.sync.work.impl.UserRoleMiddleSyncWork.clearUserRoleConnectionInfo(UserRoleMiddleSyncWork.java:301)

at com.fr.decision.sync.work.impl.UserRoleMiddleSyncWork.delete(UserRoleMiddleSyncWork.java:199)

at com.fr.decision.sync.TableDataSyncAction.delete(TableDataSyncAction.java:140)

at com.fr.decision.sync.TableDataSyncAction.execute(TableDataSyncAction.java:66)

at com.fr.decision.authority.controller.personnel.PersonnelActionManager.execute(PersonnelActionManager.java:75)

at com.fr.decision.authority.controller.personnel.PersonnelActionManager.doWork(PersonnelActionManager.java:50)

at com.fr.decision.authority.PSAuthorityContext.doPersonnelWork(PSAuthorityContext.java:420)

at com.fr.decision.service.authority.impl.DefaultDecisionSyncUserServiceProvider.synchronize(DefaultDecisionSyncUserServiceProvider.java:193)

at com.fr.decision.service.authority.impl.DefaultDecisionSyncUserServiceProvider.lambda$setSyncConfig$0(DefaultDecisionSyncUserServiceProvider.java:127)

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: java.sql.BatchUpdateException: integrity constraint violation: unique constraint or index violation; UKKARMVAV9QPL2GNGEBFNCPES8F table: FINE_SOFT_DATA

at com.fr.third.org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(JDBCPreparedStatement.java:1964)

at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:565)

at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)

... 25 more

FineReport yzm596798 发布于 2025-10-11 08:40
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
用户k6280494Lv6专家互助
发布于2025-10-11 08:43
最佳回答
0
全栈数据Lv6初级互助
发布于2025-10-11 08:48(编辑于 2025-10-11 08:49)

FINE_SOFT_DATA这张表的主键出现重复了。这张表主要是同步用户软删除数据集表。你需要检查是不是用户主键有重复的情况。

Caused by: java.sql.BatchUpdateException: integrity constraint violation: unique constraint or index violation; UKKARMVAV9QPL2GNGEBFNCPES8F table: FINE_SOFT_DATA

image.png

  • 3关注人数
  • 12浏览人数
  • 最后回答于:2025-10-11 08:49
    请选择关闭问题的原因
    确定 取消
    返回顶部