]
Jonathan Fisher commented on DROOLS-4919:
-----------------------------------------
Still hoping for an answer on this. We have to stagger our kie-server startups because a
huge amount of data is being read off that table.
Thank you,
-Jonathan
Long running query at kie-server startup
----------------------------------------
Key: DROOLS-4919
URL:
https://issues.redhat.com/browse/DROOLS-4919
Project: Drools
Issue Type: Bug
Components: kie server
Affects Versions: 7.28.0.Final
Reporter: Danny Rucker
Assignee: Maciej Swiderski
Priority: Major
The following query is executed at start up of kie-server
```
select vil.processInstanceId, vil.processId, vil.id, vil.variableId, vil.value from
VariableInstanceLog vil where vil.id in (select MAX(v.id) from VariableInstanceLog v group
by v.variableId, v.processInstanceId)
```
This is causing some issues with getting kie-server to start up.