Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 857192

Summary: Missing index in EVENTTYPES table
Product: [JBoss] JBoss Enterprise BRMS Platform 5 Reporter: Marco Rietveld <mrietvel>
Component: doc-BRMS_Rule_Flow_Component_GuideAssignee: lcarlon <lcarlon>
Status: CLOSED DUPLICATE QA Contact: Lukáš Petrovický <lpetrovi>
Severity: high Docs Contact:
Priority: high    
Version: BRMS 5.3.0.GACC: atangrin, brms-jira, dhoffman, mrietvel, mweiler, paradhya, smcgowan
Target Milestone: ---Keywords: Documentation
Target Release: future   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 854612 Environment:
Last Closed: 2013-01-21 03:32:13 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 854612, 864558    
Bug Blocks:    

Description Marco Rietveld 2012-09-13 18:45:35 UTC 
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);
Comment 1 Marco Rietveld 2012-09-13 18:52:43 UTC 
Just realized that changing the status isn't appropriate -- I'll add a link to the git diff when I've written the documentation.
Comment 3 JBoss JIRA Server 2012-12-18 22:35:29 UTC 
Marco Rietveld <marco.rietveld> updated the status of jira JBPM-3589 to Resolved
Comment 4 JBoss JIRA Server 2012-12-18 22:35:29 UTC 
Marco Rietveld <marco.rietveld> made a comment on jira JBPM-3589

This has been fixed in the latest version of 5.2.x.
Comment 5 JBoss JIRA Server 2012-12-18 22:36:11 UTC 
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).
Comment 6 lcarlon 2013-01-21 03:32:13 UTC 
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 ***