Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '6689' for key 'PRIMARY'

cancel
Showing results for 
Search instead for 
Did you mean: 
krishnait19
Member II

Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '6689' for key 'PRIMARY'

Hi Team,

We are using activiti as an rest service with docker, while updating the task through activiti rest API we are getting below issue.

### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '6689' for key 'PRIMARY'
### The error may involve org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.insertHistoricTaskInstance-Inline
### The error occurred while setting parameters
### SQL: insert into ACT_HI_TASKINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_, CATEGORY_, TENANT_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '6689' for key 'PRIMARY'

When we gone through the Activiti user guide, we need to update the UUID generator enable High Concurrency [https://www.activiti.org/userguide/#advanced.uuid.generator] , but we are working with activiti-rest.war as rest service to resolve this issue where we need to update this configuration please help us on this

Environment:

-----------------

TOMCAT_VERSION 8.0.38

ACTIVITI_VERSION 6.0.0

MYSQL_CONNECTOR_JAVA_VERSION 5.1.40

Regards

Krishna