Hi,
We have deployed Ode v 1.3.3 onto jboss app server 5 with MS SQL Server 2005 as its persistence store using hibernate. We are facing a large amount of deadlocks when we run more then a few processes simultaneously. From the traces on sql server, it looks like the deadlocks are occurring on the table BPEL_PLNK_VAL. From my initial guess, it seems like whenever a process is created/deleted it locks the table and thus causes every other thread which tries to select from that table to deadlock on it. This is killing the throughput of the system. As the scheduler retries every 1 minute, the system can execute atmost one process per minute. So is there any good way of avoiding the deadlocks by using some settings etc. Also please find below the ode-axis2.properties files. ode-axis2.threads.pool.size=100 ode-axis2.db.mode=EXTERNAL ode-axis2.db.ext.dataSource=java:ApacheODEDS ode.persistence=hibernate ode-axis2.tx.factory.class=org.apache.ode.axis2.util.JBossFactory ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl hibernate.dialect=org.hibernate.dialect.SQLServerDialect hibernate.hbm2ddl.auto=update hibernate.show_sql=false hibernate.current_session_context_class=jta hibernate.transaction.manager_lookup_class=org.hibernate.transaction.JBossTransactionManagerLookup ode-axis2.process.dehydration.maximum.age=30000000 ode-axis2.process.dehydration.maximum.count=5000 Thanks in advance for your help. Regards
