After talking with mweiler about this, we decided that we'd do 2 things: 1. provide a technical solution 2. Document the solution (for cases in which the technical solution doesn't work). This bug is for 2, the documentation. When I've written the documentation, I'll mention the commit and change the status to modified. +++ This bug was initially created as a clone of Bug #854612 +++ Description of problem: Platform issue for JBPM-3589: In the EVENTTABLES table, the INSTANCEID column isn't indexed. As the column is a foreign key to the ProcessInstanceInfo table, and as unindexed foreign key columns are a common cause of deadlock issues in Oracle, an index should be added: CREATE INDEX IDX_EVENTTYPES ON EVENTTYPES (INSTANCEID);
Just realized that changing the status isn't appropriate -- I'll add a link to the git diff when I've written the documentation.
Marco Rietveld <marco.rietveld> updated the status of jira JBPM-3589 to Resolved
Marco Rietveld <marco.rietveld> made a comment on jira JBPM-3589 This has been fixed in the latest version of 5.2.x.
Marco Rietveld <marco.rietveld> made a comment on jira JBPM-3589 This has been fixed in the latest version of 5.2.x (which has not been released yet, I believe).
Marked as a duplicate, though the solution was eventually changed so the info in this bug is no longer required. *** This bug has been marked as a duplicate of bug 883412 ***