[jboss-jira] [JBoss JIRA] (DROOLS-4919) Long running query at kie-server startup
[
https://issues.redhat.com/browse/DROOLS-4919?page=com.atlassian.jira.plug...
]
Danny Rucker commented on DROOLS-4919:
--------------------------------------
Hi,
This is an issue that is still affecting us during our deployments. So I wanted to see
what help could I provide on providing a fix for it, but I see you may have already fixed
it. Can help me determine what settings are needed, and where they are so I can set it up
properly?
Thanks,
Danny
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.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)