-
Type:
Bug Report
-
Resolution: Fixed
-
Priority:
L3 - Default
-
Affects Version/s: None
-
Component/s: None
-
None
Problem:
On AWS, we see following query a number of times which takes a long time to complete:
17-May-2017 13:04:40.261 WARNING [http-nio-127.0.0.1-8080-exec-9] org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport.reportFailedQuery Failed Query Report SQL=select RES.*
from ACT_HI_VARINST RES
order by RES.ID_ asc
LIMIT ? OFFSET ?; time=60091 ms;
They do not have any parameters, which results in querying the whole thing instead of process instance specific entities.