[rules-users] Drools Ruleflow deadlock issue[thread]

[dhinesh kumar]

Hi

 I am getting the below error while creating the ksession.startProcess() instance in multithread.
 i.e. two thread calling the ksession.startprocess() with the ruleflow as



 based on initial testing i identified due to delete or update sql operation the below is appearing. Please let me know how to solve this issue

 ERROR LOG:
 Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?
 Hibernate: delete from ProcessInstanceInfo where InstanceId=? and OPTLOCK=?
 2011/07/04 11:20:06.475{UTC} [JDBCExceptionReporter : JDBCExceptionReporter.java: logExceptions: 100] [RMI TCP Connection(6)-10.50.53.32]: WARN: : SQL Error: 60, SQLState: 61000
 2011/07/04 11:20:06.475{UTC} [JDBCExceptionReporter : JDBCExceptionReporter.java: logExceptions: 101] [RMI TCP Connection(6)-10.50.53.32]: ERROR: : ORA-00060: deadlock detected while waiting for resource
 2011/07/04 11:20:06.475{UTC} [AbstractFlushingEventListener : AbstractFlushingEventListener.java: performExecutions: 324] [RMI TCP Connection(6)-10.50.53.32]: ERROR: : Could not synchronize database state with session
 org.hibernate.exception.LockAcquisitionException: could not delete: [org.drools.persistence.processinstance.ProcessInstanceInfo#8130]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:112)...... 

Regards
 Dhinesh Kumar V
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20110704/ccf75f3f/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 40878 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/rules-users/attachments/20110704/ccf75f3f/attachment.png