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_) tablespace
bce_index ;
But still we are facing the deadlock issue.Here is the DB log.
Caused by: java.sql.BatchUpdateException: ORA-00060: deadlock detected while
waiting for resource
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 ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TM-0000258e-00000000 14 22 SX 13 27 SX SSX
TX-0007001a-0000612e 13 27 X 14 22 X
session 22: DID 0001-000E-00001106 session 27: DID 0001-000D-00002EA8
session 27: DID 0001-000D-00002EA8 session 22: DID 0001-000E-00001106
Rows waited on:
Session 27: obj - rowid = 00002596 - AAACWWAAQAAAAAAAAA
(dictionary objn - 9622, file - 16, block - 0, slot - 0)
Session 22: obj - rowid = 0000258E - AAACWOAAQAAAAMGABc
(dictionary objn - 9614, file - 16, block - 774, slot - 92)
Information on the OTHER waiting sessions:
Session 27:
pid=13 serial=55637 audsid=738276 user: 99/COMWFLSVC
O/S info: user: jbsadmin, term: unknown, ospid: , machine: s0161cdc
program: JDBC Thin Client
application name: JDBC Thin Client, hash value=0
Current SQL Statement:
delete from JBPM_PROCESSINSTANCE where ID_=:1
End of information on OTHER waiting sessions.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3934089#3934089
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3934089
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
