Run process JTA transaction unexpectedly rolled back

 
1
0
-1

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?

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi, the error ERROR: duplicate key value violates unique constraint "shkprocessdata_pkey" indicates that there is a conflicting primary key in the shkprocessdata table. Could the data in the tables have been corrupted externally?

      1. Camilo A. García

        Hello, indeed, we found that the information of the counters in the objectid table were smaller than the ones that were trying to write in shkprocessdata. We do not know why they were altered but we were able to continue generating processes. Could it be some error in the deployment of a new version of the application?

      CommentAdd your comment...