[jboss-jira] [JBoss JIRA] (DROOLS-4919) Long running query at kie-server startup

[Danny Rucker (Jira)]

Danny Rucker created DROOLS-4919:
------------------------------------

             Summary: 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


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.  



--
This message was sent by Atlassian Jira
(v7.13.8#713008)