Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-4099

Deadlock on EventTypes table with two nodes configured to use same database

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • None
    • 6.3.0.GA
    • jBPM Core
    • RHEL 7
      JVM 1.8 91
      JBoss EAP 6.4.5
      BPM Suite 6.3
      MariaDB

    • Hide

      Configure two nodes to point to the same databsae, run the same process within a few seconds on each node.

      Show
      Configure two nodes to point to the same databsae, run the same process within a few seconds on each node.

      When we start processes on each of our two business-central nodes at close to the same time (within seconds), we get a "KieRemoteRestOperationException: Unable to commit transaction" error on one of the nodes. The other runs normally. The root cause of the exception is...

      Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
              at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:908)
              at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:349)
              at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:364)
              ... 84 more
      

      We're running with singleton strategy. Both nodes are configured to share the same database instance (mariadb). I've confirmed we're using mysql hibernate dialect.

      Is there some other configuration we need? Everything we've seen says the way to cluster is to point both business-central nodes at the same database instance.

      Business Central is creating the tables via hbm2ddl on WAR startup.

      Here's the full stacktrace...

      Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      19:41:58,269 INFO  [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (http-/10.7.17.33:8080-2) HHH000010: On release of batch it still contained JDBC statements
      19:41:58,272 WARN  [com.arjuna.ats.arjuna] (http-/10.7.17.33:8080-2) ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffff0a071121:-3ccc3567:573b732b:3e7, org.drools.persistence.jta.JtaTransactionSynchronizationAdapter@66e1506a >: javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not execute statement
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:999) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.drools.persistence.TriggerUpdateTransactionSynchronization.beforeCompletion(TriggerUpdateTransactionSynchronization.java:76) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jta.JtaTransactionSynchronizationAdapter.beforeCompletion(JtaTransactionSynchronizationAdapter.java:54) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)
      	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:273)
      	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:93)
      	at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1189)
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)
      	at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)
      	at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:173)
      	at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:236) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.SingleSessionCommandService$TransactionInterceptor.execute(SingleSessionCommandService.java:587) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:82) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:377) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.execute(CommandBasedStatefulKnowledgeSession.java:490) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.jbpm.kie.services.impl.ProcessServiceImpl.execute(ProcessServiceImpl.java:488) [jbpm-kie-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.jbpm.services.cdi.impl.ProcessServiceCDIImpl$Proxy$_$$_WeldClientProxy.execute(ProcessServiceCDIImpl$Proxy$_$$_WeldClientProxy.java) [jbpm-services-cdi-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean.doKieSessionOperation(ProcessRequestBean.java:298) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean$Proxy$_$$_WeldClientProxy.doKieSessionOperation(ProcessRequestBean$Proxy$_$$_WeldClientProxy.java) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl.startProcessInstance(RuntimeResourceImpl.java:431) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl.startProcessInstance(RuntimeResourceImpl.java:125) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl$Proxy$_$$_WeldClientProxy.startProcessInstance(RuntimeResourceImpl$Proxy$_$$_WeldClientProxy.java) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_91]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_91]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_91]
      	at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91]
      	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:377) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:200) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec.jar:1.0.2.Final-redhat-2]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.kie.remote.services.rest.jaxb.DynamicJaxbContextFilter.doFilter(DynamicJaxbContextFilter.java:63) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.BasicAuthSecurityFilter.doFilter(BasicAuthSecurityFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.SecureHeadersFilter.doFilter(SecureHeadersFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.SecurityIntegrationFilter.doFilter(SecurityIntegrationFilter.java:45) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:91)
      	at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:72)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:420) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa.jar:7.5.5.Final-redhat-3]
      	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa.jar:7.5.5.Final-redhat-3]
      	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web.jar:7.5.5.Final-redhat-3]
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:400) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
      Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
      	at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:412) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:59) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1474) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:86) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:308) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:996) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	... 70 more
      Caused by: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:378)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:342)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:331)
      	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	... 80 more
      Caused by: java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:127)
      	at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQueryEpilog(MariaDbServerPreparedStatement.java:318)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:374)
      	... 84 more
      Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:908)
      	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:349)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:364)
      	... 84 more
      
      19:41:58,296 WARN  [org.drools.persistence.TransactionSynchronizationRegistryHelper] (http-/10.7.17.33:8080-2) Unable to put resource app-updateable-resource value [] due to No transaction is running
      19:41:58,297 WARN  [org.drools.persistence.jta.JtaTransactionManager] (http-/10.7.17.33:8080-2) Unable to commit transaction: javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction.
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1201)
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)
      	at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)
      	at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:173)
      	at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:236) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.SingleSessionCommandService$TransactionInterceptor.execute(SingleSessionCommandService.java:587) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:82) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:377) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.execute(CommandBasedStatefulKnowledgeSession.java:490) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.jbpm.kie.services.impl.ProcessServiceImpl.execute(ProcessServiceImpl.java:488) [jbpm-kie-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.jbpm.services.cdi.impl.ProcessServiceCDIImpl$Proxy$_$$_WeldClientProxy.execute(ProcessServiceCDIImpl$Proxy$_$$_WeldClientProxy.java) [jbpm-services-cdi-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean.doKieSessionOperation(ProcessRequestBean.java:298) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean$Proxy$_$$_WeldClientProxy.doKieSessionOperation(ProcessRequestBean$Proxy$_$$_WeldClientProxy.java) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl.startProcessInstance(RuntimeResourceImpl.java:431) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl.startProcessInstance(RuntimeResourceImpl.java:125) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl$Proxy$_$$_WeldClientProxy.startProcessInstance(RuntimeResourceImpl$Proxy$_$$_WeldClientProxy.java) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_91]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_91]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_91]
      	at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91]
      	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:377) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:200) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec.jar:1.0.2.Final-redhat-2]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.kie.remote.services.rest.jaxb.DynamicJaxbContextFilter.doFilter(DynamicJaxbContextFilter.java:63) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.BasicAuthSecurityFilter.doFilter(BasicAuthSecurityFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.SecureHeadersFilter.doFilter(SecureHeadersFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.SecurityIntegrationFilter.doFilter(SecurityIntegrationFilter.java:45) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:91)
      	at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:72)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:420) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa.jar:7.5.5.Final-redhat-3]
      	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa.jar:7.5.5.Final-redhat-3]
      	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web.jar:7.5.5.Final-redhat-3]
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:400) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not execute statement
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:999) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.drools.persistence.TriggerUpdateTransactionSynchronization.beforeCompletion(TriggerUpdateTransactionSynchronization.java:76) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jta.JtaTransactionSynchronizationAdapter.beforeCompletion(JtaTransactionSynchronizationAdapter.java:54) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)
      	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:273)
      	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:93)
      	at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1189)
      	... 63 more
      Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
      	at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:412) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:59) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1474) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:86) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:308) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:996) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	... 70 more
      Caused by: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:378)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:342)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:331)
      	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	... 80 more
      Caused by: java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:127)
      	at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQueryEpilog(MariaDbServerPreparedStatement.java:318)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:374)
      	... 84 more
      Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:908)
      	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:349)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:364)
      	... 84 more
      
      19:41:58,308 WARN  [org.drools.persistence.SingleSessionCommandService] (http-/10.7.17.33:8080-2) Could not commit session: java.lang.RuntimeException: Unable to commit transaction
      	at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:239) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.SingleSessionCommandService$TransactionInterceptor.execute(SingleSessionCommandService.java:587) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:82) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:377) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.execute(CommandBasedStatefulKnowledgeSession.java:490) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.jbpm.kie.services.impl.ProcessServiceImpl.execute(ProcessServiceImpl.java:488) [jbpm-kie-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.jbpm.services.cdi.impl.ProcessServiceCDIImpl$Proxy$_$$_WeldClientProxy.execute(ProcessServiceCDIImpl$Proxy$_$$_WeldClientProxy.java) [jbpm-services-cdi-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean.doKieSessionOperation(ProcessRequestBean.java:298) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean$Proxy$_$$_WeldClientProxy.doKieSessionOperation(ProcessRequestBean$Proxy$_$$_WeldClientProxy.java) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl.startProcessInstance(RuntimeResourceImpl.java:431) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl.startProcessInstance(RuntimeResourceImpl.java:125) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl$Proxy$_$$_WeldClientProxy.startProcessInstance(RuntimeResourceImpl$Proxy$_$$_WeldClientProxy.java) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_91]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_91]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_91]
      	at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91]
      	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:377) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:200) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec.jar:1.0.2.Final-redhat-2]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.kie.remote.services.rest.jaxb.DynamicJaxbContextFilter.doFilter(DynamicJaxbContextFilter.java:63) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.BasicAuthSecurityFilter.doFilter(BasicAuthSecurityFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.SecureHeadersFilter.doFilter(SecureHeadersFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.SecurityIntegrationFilter.doFilter(SecurityIntegrationFilter.java:45) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:91)
      	at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:72)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:420) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa.jar:7.5.5.Final-redhat-3]
      	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa.jar:7.5.5.Final-redhat-3]
      	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web.jar:7.5.5.Final-redhat-3]
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:400) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
      Caused by: javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction.
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1201)
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)
      	at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)
      	at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:173)
      	at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:236) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	... 59 more
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not execute statement
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:999) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.drools.persistence.TriggerUpdateTransactionSynchronization.beforeCompletion(TriggerUpdateTransactionSynchronization.java:76) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jta.JtaTransactionSynchronizationAdapter.beforeCompletion(JtaTransactionSynchronizationAdapter.java:54) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)
      	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:273)
      	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:93)
      	at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1189)
      	... 63 more
      Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
      	at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:412) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:59) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1474) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:86) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:308) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:996) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	... 70 more
      Caused by: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:378)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:342)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:331)
      	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	... 80 more
      Caused by: java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:127)
      	at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQueryEpilog(MariaDbServerPreparedStatement.java:318)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:374)
      	... 84 more
      Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:908)
      	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:349)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:364)
      	... 84 more
      
      19:41:58,331 WARN  [org.kie.remote.services.rest.exception.DescriptiveExceptionHandler] (http-/10.7.17.33:8080-2) Exception thrown when processing request [/runtime/com.redhat.it.bpm:rham:0.1/process/rham.onboard/start]; responding with status 500: org.kie.remote.services.rest.exception.KieRemoteRestOperationException: Unable to commit transaction
      	at org.kie.remote.services.rest.exception.KieRemoteRestOperationException.internalServerError(KieRemoteRestOperationException.java:151) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean.doKieSessionOperation(ProcessRequestBean.java:305) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean$Proxy$_$$_WeldClientProxy.doKieSessionOperation(ProcessRequestBean$Proxy$_$$_WeldClientProxy.java) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl.startProcessInstance(RuntimeResourceImpl.java:431) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl.startProcessInstance(RuntimeResourceImpl.java:125) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.rest.RuntimeResourceImpl$Proxy$_$$_WeldClientProxy.startProcessInstance(RuntimeResourceImpl$Proxy$_$$_WeldClientProxy.java) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_91]
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_91]
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_91]
      	at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91]
      	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:377) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:200) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.12.Final.jar:]
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec.jar:1.0.2.Final-redhat-2]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.kie.remote.services.rest.jaxb.DynamicJaxbContextFilter.doFilter(DynamicJaxbContextFilter.java:63) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.BasicAuthSecurityFilter.doFilter(BasicAuthSecurityFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.SecureHeadersFilter.doFilter(SecureHeadersFilter.java:53) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.uberfire.ext.security.server.SecurityIntegrationFilter.doFilter(SecurityIntegrationFilter.java:45) [uberfire-servlet-security-0.7.5.Final-redhat-4.jar:0.7.5.Final-redhat-4]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.event(JBossWebContext.java:91)
      	at org.jboss.modcluster.container.jbossweb.JBossWebContext$RequestListenerValve.invoke(JBossWebContext.java:72)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:420) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa.jar:7.5.5.Final-redhat-3]
      	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa.jar:7.5.5.Final-redhat-3]
      	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web.jar:7.5.5.Final-redhat-3]
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:400) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb.jar:7.5.12.Final-redhat-1]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
      Caused by: java.lang.RuntimeException: Unable to commit transaction
      	at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:239) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.SingleSessionCommandService$TransactionInterceptor.execute(SingleSessionCommandService.java:587) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:82) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:377) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.execute(CommandBasedStatefulKnowledgeSession.java:490) [drools-core-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.jbpm.kie.services.impl.ProcessServiceImpl.execute(ProcessServiceImpl.java:488) [jbpm-kie-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.jbpm.services.cdi.impl.ProcessServiceCDIImpl$Proxy$_$$_WeldClientProxy.execute(ProcessServiceCDIImpl$Proxy$_$$_WeldClientProxy.java) [jbpm-services-cdi-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.kie.remote.services.cdi.ProcessRequestBean.doKieSessionOperation(ProcessRequestBean.java:298) [kie-remote-services-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	... 49 more
      Caused by: javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction.
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1201)
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)
      	at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)
      	at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:173)
      	at org.drools.persistence.jta.JtaTransactionManager.commit(JtaTransactionManager.java:236) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	... 59 more
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not execute statement
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:999) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	at org.drools.persistence.TriggerUpdateTransactionSynchronization.beforeCompletion(TriggerUpdateTransactionSynchronization.java:76) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at org.drools.persistence.jta.JtaTransactionSynchronizationAdapter.beforeCompletion(JtaTransactionSynchronizationAdapter.java:54) [drools-persistence-jpa-6.3.0.Final-redhat-9.jar:6.3.0.Final-redhat-9]
      	at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)
      	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:273)
      	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:93)
      	at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)
      	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1189)
      	... 63 more
      Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
      	at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:412) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:59) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1474) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:86) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:308) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:996) [hibernate-entitymanager.jar:4.2.21.Final-redhat-1]
      	... 70 more
      Caused by: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:378)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:342)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeUpdate(MariaDbServerPreparedStatement.java:331)
      	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) [hibernate-core.jar:4.2.21.Final-redhat-1]
      	... 80 more
      Caused by: java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:127)
      	at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQueryEpilog(MariaDbServerPreparedStatement.java:318)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:374)
      	... 84 more
      Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Deadlock found when trying to get lock; try restarting transaction
      Query is: insert into EventTypes (InstanceId, element) values (?, ?)
      Query is:
      insert into EventTypes (InstanceId, element) values (?, ?)
      	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:908)
      	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:349)
      	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:364)
      	... 84 more
      

        1. transactions.txt
          5 kB
        2. mysql-reproducer.zip
          8 kB
        3. deadlock.txt
          5 kB
        4. bpm_git.tar.gz
          3.45 MB

              swiderski.maciej Maciej Swiderski (Inactive)
              rhn-support-wsiqueir William Siqueira
              Karel Suta Karel Suta
              Karel Suta Karel Suta
              Votes:
              0 Vote for this issue
              Watchers:
              14 Start watching this issue

                Created:
                Updated:
                Resolved: