Hi,
wir verwenden Camunda 7.2.0 Final auf JBoss 7.2 mit Oracle 10g.
Weiter nutzen wir das Cockpit und die Rest-API in der JBoss-Variante, direkt aus dem Camunda-Nexus.
Die JDBC-Connection ist als XA-Datasource konfiguriert:
<xa-datasource jndi-name="java:/datasources/CamundaDS" pool-name="CamundaDS" enabled="true">
<xa-datasource-property name="URL">jdbc:oracle:thin:@</xa-datasource-property>
<driver>OracleJDBCDriver</driver>
<security>
<user-name>user</user-name>
<password>pass</password>
</security>
<recovery no-recovery="true"/>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
<stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
</xa-datasource>
Nach einem Transaction-Timeout ist die komplette Engine (Cockpit,
Job-Executor, Cockpit) nicht mehr nutzbar. Fehlt hier evlt. noch
JTA-Config im Camunda-Subsystem?
Die Config des Camunda-Subsystems sieht so aus:
<subsystem xmlns="urn:org.camunda.bpm.jboss:1.1">
<process-engines>
<process-engine name="default" default="false">
<datasource>
java:/datasources/CamundaDS
</datasource>
<history-level>
audit
</history-level>
<configuration>
org.camunda.bpm.container.impl.jboss.config.ManagedJtaProcessEngineConfiguration
</configuration>
<properties>
<property name="jobExecutorAcquisitionName">
default
</property>
<property name="isAutoSchemaUpdate">
true
</property>
<property name="authorizationEnabled">
true
</property>
<property name="mailServerHost">
our-mail-server
</property>
<property name="mailServerPort">
25
</property>
<property name="mailServerDefaultFrom">
hidden
</property>
</properties>
</process-engine>
<job-executor>
<thread-pool-name>
job-executor-tp
</thread-pool-name>
<job-acquisitions>
<job-acquisition name="default">
<acquisition-strategy>
SEQUENTIAL
</acquisition-strategy>
<properties>
<property name="lockTimeInMillis">
300000
</property>
<property name="waitTimeInMillis">
5000
</property>
<property name="maxJobsPerAcquisition">
3
</property>
</properties>
</job-acquisition>
</job-acquisitions>
</job-executor>
</subsystem>
2015-03-03 00:02:56,074 WARN [com.arjuna.ats.jta] (job-executor-tp-threads - 1) ARJUNA016061: TransactionImple.enlistResource - XAResource.start returned: XAException.XAER_PROTO for < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffff0afd873f:-340777ab:54f075a5:51046, node_name=1, branch_uid=0:ffff0afd873f:-340777ab:54f075a5:51048, subordinatenodename=null, eis_name=java:/datasources/CamundaDS >: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)
at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.start(XAResourceWrapperImpl.java:191)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:636)
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:397)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.enlist(TxConnectionListener.java:587)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:264)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:599)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
at org.apache.ibatis.transaction.managed.ManagedTransaction.openConnection(ManagedTransaction.java:84)
at org.apache.ibatis.transaction.managed.ManagedTransaction.getConnection(ManagedTransaction.java:58)
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:317) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:308) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:303) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:290) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:117) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:50) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:90) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:65) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55]
at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
2015-03-03 00:02:56,078 ERROR [stderr] (job-executor-tp-threads - 1) oracle.jdbc.xa.OracleXAException
2015-03-03 00:02:56,078 ERROR [stderr] (job-executor-tp-threads - 1) at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.start(XAResourceWrapperImpl.java:191)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:636)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:397)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.enlist(TxConnectionListener.java:587)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:264)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:599)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.transaction.managed.ManagedTransaction.openConnection(ManagedTransaction.java:84)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.transaction.managed.ManagedTransaction.getConnection(ManagedTransaction.java:58)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
2015-03-03 00:02:56,079 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:317)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:308)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:303)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:290)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:117)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:50)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:90)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59)
2015-03-03 00:02:56,080 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)
2015-03-03 00:02:56,081 ERROR [stderr] (job-executor-tp-threads - 1) at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:65)
2015-03-03 00:02:56,081 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
2015-03-03 00:02:56,081 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806)
2015-03-03 00:02:56,081 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
2015-03-03 00:02:56,081 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826)
2015-03-03 00:02:56,081 ERROR [stderr] (job-executor-tp-threads - 1) at java.lang.Thread.run(Thread.java:745)
2015-03-03 00:02:56,081 ERROR [stderr] (job-executor-tp-threads - 1) at org.jboss.threads.JBossThread.run(JBossThread.java:122)
2015-03-03 00:02:56,081 SEVERE [org.camunda.bpm.engine.impl.interceptor.CommandContext] (job-executor-tp-threads - 1) Error while closing command context: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1d0e88b5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa connection handles=0 lastUse=1425337376081 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@772e4cb5 pool internal context=SemaphoreArrayListManagedConnectionPool@37bbca4a[pool=CamundaDS] xaResource=XAResourceWrapperImpl@75ab854e[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/datasources/CamundaDS] txSync=null]
### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Job.xml
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute
### The error occurred while executing a query
### Cause: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1d0e88b5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa connection handles=0 lastUse=1425337376081 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@772e4cb5 pool internal context=SemaphoreArrayListManagedConnectionPool@37bbca4a[pool=CamundaDS] xaResource=XAResourceWrapperImpl@75ab854e[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/datasources/CamundaDS] txSync=null]
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:317) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:308) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:303) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:290) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:117) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:50) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:90) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:65) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55]
at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1d0e88b5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa connection handles=0 lastUse=1425337376081 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@772e4cb5 pool internal context=SemaphoreArrayListManagedConnectionPool@37bbca4a[pool=CamundaDS] xaResource=XAResourceWrapperImpl@75ab854e[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/datasources/CamundaDS] txSync=null]
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
at org.apache.ibatis.transaction.managed.ManagedTransaction.openConnection(ManagedTransaction.java:84)
at org.apache.ibatis.transaction.managed.ManagedTransaction.getConnection(ManagedTransaction.java:58)
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
... 19 more
Caused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1d0e88b5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa connection handles=0 lastUse=1425337376081 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@772e4cb5 pool internal context=SemaphoreArrayListManagedConnectionPool@37bbca4a[pool=CamundaDS] xaResource=XAResourceWrapperImpl@75ab854e[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/datasources/CamundaDS] txSync=null]
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:604)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
... 29 more
Caused by: javax.resource.ResourceException: IJ000461: Could not enlist in transaction on entering meta-aware object
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:474)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:599)
... 31 more
Caused by: javax.transaction.SystemException: IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 0:ffff0afd873f:-340777ab:54f075a5:51046 status: ActionStatus.ABORT_ONLY >
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:552)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:282)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
... 32 more
2015-03-03 00:02:56,084 SEVERE [org.camunda.bpm.engine.impl.jobexecutor.AcquireJobsRunnable] (job-executor-tp-threads - 1) exception during job acquisition: Process engine persistence exception: org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception
at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:170) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:99) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:65) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55]
at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1d0e88b5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa connection handles=0 lastUse=1425337376081 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@772e4cb5 pool internal context=SemaphoreArrayListManagedConnectionPool@37bbca4a[pool=CamundaDS] xaResource=XAResourceWrapperImpl@75ab854e[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/datasources/CamundaDS] txSync=null]
### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Job.xml
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute
### The error occurred while executing a query
### Cause: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1d0e88b5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa connection handles=0 lastUse=1425337376081 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@772e4cb5 pool internal context=SemaphoreArrayListManagedConnectionPool@37bbca4a[pool=CamundaDS] xaResource=XAResourceWrapperImpl@75ab854e[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/datasources/CamundaDS] txSync=null]
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:317) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:308) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:303) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:290) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:117) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:50) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:90) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
... 9 more
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1d0e88b5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa connection handles=0 lastUse=1425337376081 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@772e4cb5 pool internal context=SemaphoreArrayListManagedConnectionPool@37bbca4a[pool=CamundaDS] xaResource=XAResourceWrapperImpl@75ab854e[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/datasources/CamundaDS] txSync=null]
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
at org.apache.ibatis.transaction.managed.ManagedTransaction.openConnection(ManagedTransaction.java:84)
at org.apache.ibatis.transaction.managed.ManagedTransaction.getConnection(ManagedTransaction.java:58)
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
... 19 more
Caused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@1d0e88b5[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa connection handles=0 lastUse=1425337376081 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@772e4cb5 pool internal context=SemaphoreArrayListManagedConnectionPool@37bbca4a[pool=CamundaDS] xaResource=XAResourceWrapperImpl@75ab854e[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@253131fa pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options jndiName=java:/datasources/CamundaDS] txSync=null]
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:604)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
... 29 more
Caused by: javax.resource.ResourceException: IJ000461: Could not enlist in transaction on entering meta-aware object
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:474)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:599)
... 31 more
Caused by: javax.transaction.SystemException: IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 0:ffff0afd873f:-340777ab:54f075a5:51046 status: ActionStatus.ABORT_ONLY >
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:552)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:282)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
... 32 more