Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-4759

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
              Gonzalo Muñoz Fernández Gonzalo Muñoz Fernández
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: