Run process JTA transaction unexpectedly rolled back
Confluence User - 08 May, 2019
Hello team. I need an urgent collaboration on your part. Our application server was working well, however, at a certain moment, we were not sure why, all the run process tasks stopped working. In all cases the system shows us the message on the screen:
JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is bitronix.tm.internal.BitronixRollbackException: transaction was marked as rollback only and has been rolled back
Looking more closely at the LOG, it presents the following messages:
ERROR 08 May 2019 00:51:40 Persistence - Persisting of ProcessVariable failed ERROR 08 May 2019 00:51:40 org.joget.workflow.model.service.WorkflowManagerImpl - org.enhydra.shark.api.internal.instancepersistence.PersistenceException: Persisting of ProcessVariable failed com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "shkprocessdata_pkey" Detail: Key (oid)=(2434638) already exists. org.enhydra.shark.api.internal.instancepersistence.PersistenceException: Couldn't write transaction: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "shkprocessdata_pkey" Detail: Key (oid)=(2434638) already exists. Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "shkprocessdata_pkey" Detail: Key (oid)=(2434638) already exists. Caused by: org.enhydra.shark.api.internal.instancepersistence.PersistenceException: Couldn't write transaction: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "shkprocessdata_pkey" Detail: Key (oid)=(2434638) already exists. at org.enhydra.shark.instancepersistence.DODSPersistentManager.getPersistedProcessObject(DODSPersistentManager.java:3698) at org.enhydra.shark.instancepersistence.DODSPersistentManager.persistVariablesBLOB(DODSPersistentManager.java:639) ... 153 more Caused by: com.lutris.dods.builder.generator.query.DataObjectException: Couldn't write transaction: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "shkprocessdata_pkey" Detail: Key (oid)=(2434638) already exists.
Any ideas?
runprocess;roll;back