Loading...

XML

Word

Printable

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 7.10.0.GA
Affects Version/s: 7.9.0.GA
Component/s: Business Central, Kie-Server
Labels:
None

CDW devel_ack:
CDW docs_ack:
CDW pm_ack:
CDW qa_ack:
CDW release:
Fix Build:
CR1
QE Test Coverage:
+
Target Release:

7.10.0.GA
Git Pull Request:
https://github.com/kiegroup/jbpm-wb/pull/1473, https://github.com/kiegroup/kie-soup/pull/168
Steps to Reproduce:

Hide

Have several million rows in the VariableInstanceLog and start multipe instances of kie-server.

Show
Have several million rows in the VariableInstanceLog and start multipe instances of kie-server.

Sprint:
2020 Week 49-51 (from Nov 30)

SFDC Cases Counter:
SFDC Cases Open:
SFDC Cases Links:

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.

causes

RHPAM-3353 JBPM-9099 has introduced a bug when dealing with SQLServer

Closed

clones

JBPM-9099 Long running query at kie-server startup

Resolved

relates to

JBPM-9626 Create test case for Long running queries at Kie server startup

Resolved

Assignee:: Francisco Javier Tirado Sarti

Reporter:: Martin Weiler (Inactive)

Tester:: Antonio Fernandez Alhambra (Inactive)

QA Contact:: Antonio Fernandez Alhambra (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 8 Start watching this issue

Created:: 2020/12/07 4:54 PM

Updated:: 2024/03/25 7:00 PM

Resolved:: 2020/12/11 2:37 AM

Details

Description

Attachments

Issue Links

Activity

People

Dates