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

[Cristiano Nicolai (Jira)]

    [ https://issues.redhat.com/browse/DROOLS-4919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13956477#comment-13956477 ] 

Cristiano Nicolai commented on DROOLS-4919:
-------------------------------------------

[~swiderski.maciej] correct, that was done as part of JBPM-8559.

> 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)