10 Replies Latest reply: Aug 2, 2012 1:05 AM by Jason Shepherd RSS

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

catzsy Newbie

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

  • 1. Re: Deadlock occurs when 10 instance is created at the same time?
    Jeff Yu Master

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

  • 2. Re: Deadlock occurs when 10 instance is created at the same time?
    catzsy Newbie

    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!

    http://i55.tinypic.com/9awm6a.pnghttp://i56.tinypic.com/9hmhsl.pnghttp://i52.tinypic.com/b9an1y.png

  • 3. Re: Deadlock occurs when 10 instance is created at the same time?
    catzsy Newbie

    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

  • 4. Re: Deadlock occurs when 10 instance is created at the same time?
    Jeff Yu Master

    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.

     

    soapui.jpg

     

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

     

    loadui.jpg

     

    loadui-running.jpg

  • 5. Re: Deadlock occurs when 10 instance is created at the same time?
    Jeff Yu Master

    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

  • 6. Re: Deadlock occurs when 10 instance is created at the same time?
    catzsy Newbie

    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

  • 7. Re: Deadlock occurs when 10 instance is created at the same time?
    Jeff Yu Master

    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

  • 8. Re: Deadlock occurs when 10 instance is created at the same time?
    catzsy Newbie

    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/%3C4DDE9142.9060909@gmail.com%3Eives.apache.org/mod_mbox/ode-user/201105.mbox/%3C4DDE9142.9060909@gmail.com%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

  • 9. Re: Deadlock occurs when 10 instance is created at the same time?
    Jeff Yu Master

    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/%3C4DDE9142.9060909@gmail.com%3Eives.apache.org/mod_mbox/ode-user/201105.mbox/%3C4DDE9142.9060909@gmail.com%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

  • 10. Re: Deadlock occurs when 10 instance is created at the same time?
    Jason Shepherd Newbie

    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