Hi, I have a problem with deadlocks. Can somebody tell me what additional indexes I need to create? The link below doesn't work.
Thanks, Rafal Rafal Rusin wrote: > > Possibly you need to create some additional indexes. > For oracle + hibernate, you can check out those: > http://top.touk.pl/git?p=ode/odeo/.git;a=blob;f=touk/oracle/ode_indexes.sql;h=de532c17c654e6acb7ad405fa259b27a583f5d2f;hb=HEAD > > I believe it will be easy to convert them to MSSQL. > There are also some indexes available in archives, so you can try to > search for it. > > 2009/12/12 Pratik Bhatt <[email protected]>: >> 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 >> > > > Regards, > -- > Rafał Rusin > http://rrusin.blogspot.com > http://www.touk.pl > http://top.touk.pl > > -- View this message in context: http://old.nabble.com/Large-amount-of-deadlocks-occuring-when-running-more-then-2-processes--simultanously-tp26763513p31290289.html Sent from the Apache Ode User mailing list archive at Nabble.com.
