I have design the common BPM application which is used by different
applications.It leads to so many process definition & process instances.
Due to mission of indexes, i am facing the deadlock issue on DB.
I created the few indexes on DB, but still the problem is still there.
Please provide some m
Hi Dan,
Following are the indexes we ceated to avoid deadlocks.
create index JBPM_LOG_ust_n7 on JBPM_LOG(PARENT_) tablespace bce_index ;
create index JBPM_TASKINSTANCE_ust_n4 on JBPM_TASKINSTANCE(TOKEN_) tablespace
bce_index ;
create index JBPM_TOKEN_ust_n3 on JBPM_TOKEN(PROCESSINSTANCE_) table
I did that & created the required indexes.But this is the problem with JBPM DB
on heavy traffic of user.JBPM should provide the script to create required
indexex to avoid this problem as a pracuationary measures.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p
required indexes missing in JBPM DB script.
Due to this deadlock occurs in JBPM DB.
Following is the Oracle DB log:
Changing data in table JBPM_TOKEN will lock table JBPM_PROCESSINSTANCE
Create an index on table JBPM_PROCESSINSTANCE with the following columns to
remove lock problem
Column = ROOT
DEADLOCK DETECTED
Current SQL statement for this session:
update JBPM_TOKEN set NAME_=:1, START_=:2, END_=:3, NODEENTER_=:4,
NEXTLOGINDEX_=:5, ISABLETOREACTIVATEPARENT_=:6, ISTERMINATIONIMPLICIT_=:7,
NODE_=:8, PROCESSINSTANCE_=:9, PARENT_=:10 where ID_=:11
The following deadlock is not an ORAC
