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

Oracle - Long running query at kie-server startup

    XMLWordPrintable

Details

    Description

      Slow server startup due to query registration at Oracle 19c.
       
      When we have 900000 or more records in VariableInstanceLog, the following RHPAM SQL query takes long time to respond and times out even after 15 minutes in the DEV environment
      ~~~~~~
      SELECT * FROM (SELECT VIL.PROCESSINSTANCEID, VIL.PROCESSID, VIL.ID, VIL.VARIABLEID, VIL.VALUE FROM VARIABLEINSTANCELOG VIL LEFT JOIN VARIABLEINSTANCELOG VIL2 ON VIL.PROCESSINSTANCEID = VIL2.PROCESSINSTANCEID AND VIL.VARIABLEID = VIL2.VARIABLEID AND VIL.ID < VIL2.ID WHERE VIL2.ID IS NULL) "dbSQL" FETCH FIRST 0 ROWS ONLY

      Attachments

        Issue Links

          Activity

            People

              gmunozfe@redhat.com Gonzalo Muñoz Fernández
              rhn-support-mputz Martin Weiler
              Antonio Fernandez Alhambra Antonio Fernandez Alhambra
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: