10 Replies Latest reply on Aug 2, 2012 1:05 AM by jshepher

    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

        • 1. Re: Deadlock occurs when 10 instance is created at the same time?
          jeff.yuchang

          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

            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

              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.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.

                 

                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.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

                  • 6. Re: Deadlock occurs when 10 instance is created at the same time?
                    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

                    • 7. Re: Deadlock occurs when 10 instance is created at the same time?
                      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

                      • 8. Re: Deadlock occurs when 10 instance is created at the same time?
                        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/%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.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/%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?
                            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