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

[vdhinesh]

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

http://drools.46999.n3.nabble.com/file/n3136706/ruleflow.bmp 

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)...... 

--
View this message in context: http://drools.46999.n3.nabble.com/Drools-Ruleflow-deadlock-issue-thread-tp3136706p3136706.html
Sent from the Drools: User forum mailing list archive at Nabble.com.