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

[Danny Rucker (Jira)]

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

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)