Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-10187

Deadlock is happening on SessionInfo and ProcessInstanceInfo tables

XMLWordPrintable

      1 KieServer pod has 3 replicas. After running the testing process, the logs show the following deadlock error:

      ~~~
      ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-10) ORA-00060: deadlock detected while waiting for resource
      ~~~

      When the deadlock happens the process rollbacks and is no longer accessible from their side (the HT disappears from the tasklist as if it's correctly closed but the subprocess status is still on the HT).

      It is working correctly on 7.3.1 and 7.13.2 is getting the exception.

      After an analysis, it seems that the deadlock is happening on SessionInfo and ProcessInstanceInfo tables.

      How to avoid specifics deadlocks on SessionInfo and ProcessInstanceInfo tables?

              ftirados Francisco Javier Tirado Sarti
              rhn-support-omolinab Oscar Molina
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: