Details
-
Bug
-
Resolution: Done
-
Major
-
7.10.0.GA
-
None
-
False
-
False
-
ER1
-
?
-
Undefined
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
- clones
-
JBPM-9811 Oracle - Long running query at kie-server startup
- Resolved
- is related to
-
RHPAM-3909 [ONE-OFF] (7.10.1) Long running query at kie-server startup
- Closed