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. _______________________________________________ rules-users mailing list rules-users@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users