duplicated key in act_ru_variable_pkey

[aachkar]

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

[ronald_van_kuij]

Activiti 1.9 is not supported anymore…

[aachkar]

We are using Activiti 5.3

[ronald_van_kuij]

can you try with 5.7?

[aachkar]

I'll try it and let you know.

Thanks

[aachkar]

Same problem with 5.7, any ideas?

[ronald_van_kuij]

did you also use a new config? afaik, 5.7. can use a new way of generating id's but not sure how/when it is used

[aachkar]

What do you mean with a new config?

If you mean to the activiti.cfg.xml, the answer is no, I've used the same config.

[ronald_van_kuij]

Yep, that is what I meant.

http://jira.codehaus.org/browse/ACT-789