cancel
Showing results for 
Search instead for 
Did you mean: 

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

krishnait19
Champ in-the-making
Champ in-the-making

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

0 REPLIES 0