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 = ROOTTOKEN_ (1). Can somebody provide me sql script with required indexes?Since i don't know the JBPM schema well. This problem occurs due to heavy traffics on DB. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3932279#3932279 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3932279 ------------------------------------------------------- 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
