Bug 1008333 - Impact of Indices applied on JBPM tables
Summary: Impact of Indices applied on JBPM tables
Keywords:
Status: CLOSED UPSTREAM
Alias: None
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: JBPM - within SOA
Version: unspecified
Hardware: All
OS: Linux
unspecified
high
Target Milestone: ---
: ---
Assignee: Nobody
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-09-16 07:55 UTC by jadhavpprasad
Modified: 2025-02-10 03:28 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2025-02-10 03:28:31 UTC
Type: Task
Embargoed:

Attachments (Terms of Use)

Description jadhavpprasad 2013-09-16 07:55:42 UTC 
I found deadlock issue while deleting process instance in multi-user environment.
As suggested one of the forum of RED-HAT i have created indices. here is URL of forum
https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_SOA_Platform/4.2/html/4.2.CP04_Release_Notes/sect-manually_create_jBPM_indexes_when_upgrading.html

After applying these indices deadlock issue resolved for me.

My questions are:
1. How much database size will increase after applying these indices?
2. What will be impact on insertion operations such as Create Process Instance and Execute Transitions operations?
Comment 2 Red Hat Bugzilla 2025-02-10 03:28:31 UTC 
This product has been discontinued or is no longer tracked in Red Hat Bugzilla.
Note You need to log in before you can comment on or make changes to this bug.