Deadlock occurs when 10 instance is created at the same time?

[catzsy]

Hi Everyone,

I have 3 processes deployed in my JBossAS5 now, and I'm using Riftsaw 2.3.0, running on sqlserver 2008. A deadlock seems to happen whenever 10 or more process instance is created at the same time and running. Here's the error log that I'm getting:

any help is appreciated thanks!

16:51:47,849 WARN  [JDBCExceptionReporter] SQL Error: 1205, SQLState: 40001

16:51:47,849 ERROR [JDBCExceptionReporter] Transaction (Process ID 65) was deadl

ocked on lock resources with another process and has been chosen as the deadlock

victim. Rerun the transaction.

16:51:47,852 ERROR [AbstractFlushingEventListener] Could not synchronize databas

e state with session

org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch u

pdate

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j

ava:105)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:66)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:

275)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio

ns(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus

hEventListener.java:50)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

        at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(Abstra

ctEntityManagerImpl.java:504)

        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple

.beforeCompletion(SynchronizationImple.java:101)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletio

n(TwoPhaseCoordinator.java:269)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoo

rdinator.java:89)

        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.c

ommitAndDisassociate(TransactionImple.java:1423)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.co

mmit(BaseTransaction.java:137)

        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTra

nsactionManagerDelegate.java:75)

        at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngin

eImpl.java:143)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:114)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:42)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(A

bstractInvocationHandlerJSE.java:129)

        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpoin

tInvoker.java:222)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHan

dlerImpl.java:502)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHand

lerImpl.java:299)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl

.java:206)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(Request

HandlerImpl.java:131)

        at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(Abstract

EndpointServlet.java:87)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi

lter.java:96)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:235)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:191)

        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit

yAssociationValve.java:190)

        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv

e.java:92)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce

ss(SecurityContextEstablishmentValve.java:126)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok

e(SecurityContextEstablishmentValve.java:70)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:102)

        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC

onnectionValve.java:158)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

a:330)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

:829)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

ss(Http11Protocol.java:598)

        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44

7)

        at java.lang.Thread.run(Thread.java:662)

Caused by: java.sql.BatchUpdateException: Transaction (Process ID 65) was deadlo

cked on lock resources with another process and has been chosen as the deadlock

victim. Rerun the transaction.

        at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja

va:944)

        at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(Wrapped

Statement.java:774)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav

a:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:

268)

        ... 49 more

16:51:47,878 WARN  [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.TwoPhaseCo

ordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.in

ternal.jta.resources.arjunacore.SynchronizationImple@39e30c

javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionE

xception: Could not execute JDBC batch update

        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException

(AbstractEntityManagerImpl.java:614)

        at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(Abstra

ctEntityManagerImpl.java:513)

        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple

.beforeCompletion(SynchronizationImple.java:101)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletio

n(TwoPhaseCoordinator.java:269)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoo

rdinator.java:89)

        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.c

ommitAndDisassociate(TransactionImple.java:1423)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.co

mmit(BaseTransaction.java:137)

        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTra

nsactionManagerDelegate.java:75)

        at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngin

eImpl.java:143)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:114)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:42)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(A

bstractInvocationHandlerJSE.java:129)

        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpoin

tInvoker.java:222)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHan

dlerImpl.java:502)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHand

lerImpl.java:299)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl

.java:206)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(Request

HandlerImpl.java:131)

        at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(Abstract

EndpointServlet.java:87)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi

lter.java:96)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:235)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:191)

        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit

yAssociationValve.java:190)

        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv

e.java:92)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce

ss(SecurityContextEstablishmentValve.java:126)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok

e(SecurityContextEstablishmentValve.java:70)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:102)

        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC

onnectionValve.java:158)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

a:330)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

:829)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

ss(Http11Protocol.java:598)

        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44

7)

        at java.lang.Thread.run(Thread.java:662)

Caused by: org.hibernate.exception.LockAcquisitionException: Could not execute J

DBC batch update

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j

ava:105)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:66)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:

275)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio

ns(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus

hEventListener.java:50)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

        at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(Abstra

ctEntityManagerImpl.java:504)

        ... 42 more

Caused by: java.sql.BatchUpdateException: Transaction (Process ID 65) was deadlo

cked on lock resources with another process and has been chosen as the deadlock

victim. Rerun the transaction.

        at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja

va:944)

        at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(Wrapped

Statement.java:774)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav

a:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:

268)

        ... 49 more

16:51:47,891 ERROR [BPELEngineImpl] Commit failed

javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.ar

junacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.

commitwhenaborted] Could not commit transaction.

        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.c

ommitAndDisassociate(TransactionImple.java:1435)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.co

mmit(BaseTransaction.java:137)

        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTra

nsactionManagerDelegate.java:75)

        at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngin

eImpl.java:143)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:114)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:42)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(A

bstractInvocationHandlerJSE.java:129)

        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpoin

tInvoker.java:222)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHan

dlerImpl.java:502)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHand

lerImpl.java:299)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl

.java:206)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(Request

HandlerImpl.java:131)

        at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(Abstract

EndpointServlet.java:87)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi

lter.java:96)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:235)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:191)

        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit

yAssociationValve.java:190)

        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv

e.java:92)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce

ss(SecurityContextEstablishmentValve.java:126)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok

e(SecurityContextEstablishmentValve.java:70)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:102)

        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC

onnectionValve.java:158)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

a:330)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

:829)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

ss(Http11Protocol.java:598)

        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44

7)

        at java.lang.Thread.run(Thread.java:662)

Caused by: java.lang.Throwable: setRollbackOnly called from:

        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.s

etRollbackOnly(TransactionImple.java:392)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.se

tRollbackOnly(BaseTransaction.java:195)

        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.setRollbackOnl

y(BaseTransactionManagerDelegate.java:123)

        at org.hibernate.ejb.AbstractEntityManagerImpl.markAsRollback(AbstractEn

tityManagerImpl.java:421)

        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException

(AbstractEntityManagerImpl.java:576)

        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException

(AbstractEntityManagerImpl.java:614)

        at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(Abstra

ctEntityManagerImpl.java:513)

        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple

.beforeCompletion(SynchronizationImple.java:101)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletio

n(TwoPhaseCoordinator.java:269)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoo

rdinator.java:89)

        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.c

ommitAndDisassociate(TransactionImple.java:1423)

        ... 37 more

16:51:47,901 ERROR [InvocationHandlerJAXWS] Method invocation failed with except

ion: null

java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(A

bstractInvocationHandlerJSE.java:129)

        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpoin

tInvoker.java:222)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHan

dlerImpl.java:502)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHand

lerImpl.java:299)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl

.java:206)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(Request

HandlerImpl.java:131)

        at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(Abstract

EndpointServlet.java:87)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi

lter.java:96)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:235)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:191)

        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit

yAssociationValve.java:190)

        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv

e.java:92)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce

ss(SecurityContextEstablishmentValve.java:126)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok

e(SecurityContextEstablishmentValve.java:70)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:102)

        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC

onnectionValve.java:158)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

a:330)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

:829)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

ss(Http11Protocol.java:598)

        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44

7)

        at java.lang.Thread.run(Thread.java:662)

Caused by: java.lang.RuntimeException: Failed to invoke BPEL process: Rollback f

ailed

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:141)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:42)

        ... 32 more

Caused by: java.lang.Exception: Rollback failed

        at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngin

eImpl.java:165)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:114)

        ... 33 more

Caused by: java.lang.IllegalStateException: BaseTransaction.rollback - [com.arju

na.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.tr

ansaction.arjunacore.notx] no transaction!

        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.ro

llback(BaseTransaction.java:160)

        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.rollback(BaseT

ransactionManagerDelegate.java:114)

        at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngin

eImpl.java:163)

        ... 34 more

16:51:47,948 ERROR [SOAPFaultHelperJAXWS] SOAP request exception

java.lang.RuntimeException: Failed to invoke BPEL process: Rollback failed

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:141)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:42)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(A

bstractInvocationHandlerJSE.java:129)

        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpoin

tInvoker.java:222)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHan

dlerImpl.java:502)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHand

lerImpl.java:299)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl

.java:206)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(Request

HandlerImpl.java:131)

        at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(Abstract

EndpointServlet.java:87)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi

lter.java:96)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:235)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:191)

        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit

yAssociationValve.java:190)

        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv

e.java:92)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce

ss(SecurityContextEstablishmentValve.java:126)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok

e(SecurityContextEstablishmentValve.java:70)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

[jeff.yuchang]

Any possible that you can attach the examples that we can try out?

[catzsy]

Hi Jeff 

Thanks for the quick response Unfortuantely, due to the non-disclosure that I signed with my company, I can't give you the exact codes of my bpel.. what i can do though, is to create a sample bpel and how i am accessing it. in the meantime, attached here is screenshot of the deadlock graph from sql server profiler... I'll post the bpel, c# codes as soon as i can.
Thanks!

[catzsy]

Sorry for the late post

I tried to deploy the hello_world example in the quickstart folder and created a test case suite using SoapUI and loadtest the test case suite using LoadU and encountered the same deadlock problem. settings for the LoadUI is 10 concurrent request 0 time interval..

Thanks

[jeff.yuchang]

Thanks for your feedback. 

According to your description, I've tried the LoadUI (1.5.0), SoapUI (3.6.1) with RiftSaw 2.3.0.Final (on Mysql database), it is running fine, I am not sure if I am configuring something different from you, or I am missing something here.

Here is the soapUI's test suite.

Below is the configuration for loadUI and one is the LoadUI in running. (I've configured fix rate 60/sec, was it too few?)

[jeff.yuchang]

well, I've just used the same loadUI settings against sqlserver database, and yeah, I've seen the same deadlock error, like following.. I'am going to investigate further, however, if you've got a chance, could you please try to use the sqlserver's jdbc, instead of jtds one?

-----

16:06:57,247 WARN  [JDBCExceptionReporter] SQL Error: 1205, SQLState: 40001

16:06:57,247 ERROR [JDBCExceptionReporter] Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

16:06:57,248 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session

org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update

          at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)

          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

          at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)

          at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

          at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)

          at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

          at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

          at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)

          at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

          at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

          at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

          at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

          at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

          at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

          at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngineImpl.java:143)

          at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:114)

          at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndpoint.java:42)

          at sun.reflect.GeneratedMethodAccessor284.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          at java.lang.reflect.Method.invoke(Method.java:597)

          at org.jboss.wsf.container.jboss50.invocation.InvocationHandlerJSE.invoke(InvocationHandlerJSE.java:108)

          at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:222)

          at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:474)

          at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:295)

          at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:205)

          at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:131)

          at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(AbstractEndpointServlet.java:85)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

          at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

          at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

          at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

          at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

          at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

          at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

          at java.lang.Thread.run(Thread.java:680)

Caused by: java.sql.BatchUpdateException: Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

          at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:944)

          at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)

          at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

          at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

          ... 48 more

[catzsy]

Hi Jeff,

tried it using sqljdbc4.jar... I'm seem to be encountering the same deadlock problem(see below).

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process

ID 56) was deadlocked on lock resources with another process and has been chose

n as the deadlock victim. Rerun the transaction.

        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError

(SQLServerException.java:197)

        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ

erStatement.java:1493)

        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePrep

aredStatementBatch(SQLServerPreparedStatement.java:1277)

        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtBatch

ExecCmd.doExecute(SQLServerPreparedStatement.java:1191)

        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)

        at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe

rverConnection.java:1400)

        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer

verStatement.java:179)

        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS

erverStatement.java:154)

        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(

SQLServerPreparedStatement.java:1155)

        at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(Wrapped

Statement.java:774)

        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav

a:70)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:

268)

        ... 48 more

15:27:12,648 WARN  [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.TwoPhaseCo

ordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.in

ternal.jta.resources.arjunacore.SynchronizationImple@117eb65

javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionE

xception: Could not execute JDBC batch update

        at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException

(AbstractEntityManagerImpl.java:614)

        at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(Abstra

ctEntityManagerImpl.java:513)

        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple

.beforeCompletion(SynchronizationImple.java:101)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletio

n(TwoPhaseCoordinator.java:269)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoo

rdinator.java:89)

        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.c

ommitAndDisassociate(TransactionImple.java:1423)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.co

mmit(BaseTransaction.java:137)

        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTra

nsactionManagerDelegate.java:75)

        at org.jboss.soa.bpel.runtime.engine.ode.BPELEngineImpl.invoke(BPELEngin

eImpl.java:143)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:114)

        at org.jboss.soa.dsp.ws.BaseWebServiceEndpoint.invoke(BaseWebServiceEndp

oint.java:42)

        at sun.reflect.GeneratedMethodAccessor337.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.wsf.common.invocation.AbstractInvocationHandlerJSE.invoke(A

bstractInvocationHandlerJSE.java:129)

        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpoin

tInvoker.java:222)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHan

dlerImpl.java:502)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHand

lerImpl.java:299)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl

.java:206)

        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(Request

HandlerImpl.java:131)

        at org.jboss.wsf.common.servlet.AbstractEndpointServlet.service(Abstract

EndpointServlet.java:87)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi

lter.java:96)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

icationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

alve.java:235)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

alve.java:191)

        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit

yAssociationValve.java:190)

        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv

e.java:92)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.proce

ss(SecurityContextEstablishmentValve.java:126)

        at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invok

e(SecurityContextEstablishmentValve.java:70)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

ava:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

ava:102)

        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedC

onnectionValve.java:158)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

ve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

a:330)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

:829)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

ss(Http11Protocol.java:598)

        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44

7)

        at java.lang.Thread.run(Thread.java:662)

Caused by: org.hibernate.exception.LockAcquisitionException: Could not execute J

DBC batch update

        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j

ava:105)

        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp

er.java:66)

        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:

275)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio

ns(AbstractFlushingEventListener.java:321)

        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus

hEventListener.java:50)

        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

        at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(Abstra

ctEntityManagerImpl.java:504)

        ... 41 more

[jeff.yuchang]

Hi,

May I know that if you are running the riftsaw against local database? or a remote database? An interesting thing is that I've tested the RiftSaw 2.3.0.Final against local Mysql and Postgresql database, both are running fine at 100/sec rate. However, if I ran the riftsaw against a remote mysql database, it will throw out "org.jboss.util.NestedSQLException: Unable to get managed connection for BPELDB;" exception.

With the remote database, it will take about 1 min to run a simple quick_start in my case. (most likely the network is not good here). I've seen your exception with the remote sqlserver database.

Sorry that I didn't test it with local sqlserver database, as I don't have it.. It would be appreciated that you can test the riftsaw against your local sqlserver database if you were using a remote one.

Thanks

Jeff

[catzsy]

Hi Jeff,

No worries. I'm running both Riftsaw 2.3.0.Final and sqlserver in my local Also tried using mysql database and is working well.

I've been looking into some threads regarding the sqlserver deadlocks though..

here are my findings:

1. From Apache ODE forum - http://mail-archives.apache.org/mod_mbox/ode-user/201105.mbox/[e-mail]%3Eives.apache.org/mod_mbox/ode-user/201105.mbox/[e-mail]%3E

http://ode.apache.org/ode-schema.html

https://issues.apache.org/jira/browse/ODE-632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

suggested to add indexes.. tried this but seem to encounter the same deadlock problem.

2. Haven't seen the riftsaw codes, but i noticed that dependencies includes spring and hibernate --> http://www.coderanch.com/t/415119/ORM/java/Deadlock-problems-Hibernate-Spring-MS

I'm thinking of downloading the riftsaw codes today though

3. sqlserver + hibernate specific problem

https://forum.hibernate.org/viewtopic.php?t=985460

http://blog.sqlauthority.com/2007/05/16/sql-server-fix-error-1205-transaction-process-id-was-deadlocked-on-resources-with-another-process-and-has-been-chosen-as-the-deadlock-victim-rerun-the-transaction/

thanks,

Catz

[jeff.yuchang]

catzsy wrote:

Hi Jeff,

No worries. I'm running both Riftsaw 2.3.0.Final and sqlserver in my local Also tried using mysql database and is working well.

Thats good to hear, it means this issue is sqlserver specific.

catzsy wrote:

1. From Apache ODE forum - http://mail-archives.apache.org/mod_mbox/ode-user/201105.mbox/[e-mail]%3Eives.apache.org/mod_mbox/ode-user/201105.mbox/[e-mail]%3E

http://ode.apache.org/ode-schema.html

https://issues.apache.org/jira/browse/ODE-632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

suggested to add indexes.. tried this but seem to encounter the same deadlock problem.

RiftSaw added the JPA based Hibernate implementation on top of current JPA impl. It doesn't use the native Hibernate one in ODE, so this fix shouldn't be applied in this case.

catzsy wrote:

2. Haven't seen the riftsaw codes, but i noticed that dependencies includes spring and hibernate --> http://www.coderanch.com/t/415119/ORM/java/Deadlock-problems-Hibernate-Spring-MS

I'm thinking of downloading the riftsaw codes today though

Here is the code base: http://anonsvn.jboss.org/repos/riftsaw/tags/RiftSaw-2.3.0.Final/ , http://anonsvn.jboss.org/repos/riftsaw/tags/RiftSaw-ODE-2.3.0.Final/

Regards

Jeff

[jshepher]

A workaround for this issue to set the transaction isolation level to 'snapshot' for each connection.

<datasources>
    <local-tx-datasource>
        <jndi-name>BPELDB</jndi-name>
        ...
        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
        <new-connection-sql>SET TRANSACTION ISOLATION LEVEL SNAPSHOT;</new-connection-sql>
        ...
    </local-tx-datasource>
</datasources>

You will have to allow 'snapshot' isolation with this command:

ALTER DATABASE BPELDB SET ALLOW_SNAPSHOT_ISOLATION ON;

We are addressing this in the Riftsaw 2.3.6 branch.

https://bugzilla.redhat.com/show_bug.cgi?id=815379