AnsweredAssumed Answered

duplicated key in act_ru_variable_pkey

Question asked by aachkar on Aug 16, 2011
Latest reply on Aug 30, 2011 by ronald.van.kuijk
We are using activiti engine in a singleton Ejb, running in Glassfish3 against PostgreSQL. Sometimes we get an error when completing a task.

### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «act_ru_variable_pkey»
### The error may involve org.activiti.persistence.insertVariableInstance-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «act_ru_variable_pkey»

This error appears in differents tables every time and seems to be a problem with the field next.dbid in act_ge_property.

We solve this by restarting the server. This time we had to increment next.dbid manually besides restarting the server, to keep working,.

We'd like to know if there is a permanent solution to this problem.

Thanks

Outcomes