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

Details

    Description

      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?

      Attachments

        Issue Links

          is cloned by

          Bug - A problem that impairs or prevents the functions of the product. JBPM-10187 Deadlock is happening on SessionInfo and ProcessInstanceInfo tables

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved
          is related to

          Bug - A problem that impairs or prevents the functions of the product. RHPAM-4845 Timer scheduler should use CMT to keep same transaction

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Release Pending

          Activity

            People

              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

              Dates

                Created:
                Updated:
                Resolved: