EAP6.1 fails with database transaction or row lock exceptions after bundle deployment is attempted

Latest response

Getting bellow WARNING & ERROR when we hit the application page after deployments on JBoss EAP 6.1.0.GA (AS 7.2.0.Final-redhat-8)

01:21:55,524 WARN [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (http-/144.230.25.156:8280-1 requestURI=/myapp/shop/phone_wall.jsp jsessionid=Uv2Z6OXb-cCJ-WJ0qzOaL71L.hjs-development1-shop_app remoteAddr=163.122.13.97 userid=st6203590000) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@24c9faa3[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@5d307ccb connection handles=0 lastUse=1423466514461 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@72a996da pool internal context=SemaphoreArrayListManagedConnectionPool@5e31066f[pool=APPCOREDS] xaResource=XAResourceWrapperImpl@5beefd05[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@5d307ccb pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options jndiName=java:/APPCOREDS] txSync=null]: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110) [ojdbc6.jar:11.2.0.3.0]
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240) [ojdbc6.jar:11.2.0.3.0]
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:715)
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:607)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:265)
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 atg.adapter.gsa.GSATransaction.getConnection(GSATransaction.java:794) [_DAS_slib_sclasses.jar:]
at atg.adapter.gsa.GSAItemDescriptor.getConnection(GSAItemDescriptor.java:2751) [_DAS_slib_sclasses.jar:]

01:21:55,567 ERROR [stderr] (http-/144.230.25.156:8280-1 requestURI=/myapp/shop/phone_wall.jsp jsessionid=Uv2Z6OXb-cCJ-WJ0qzOaL71L.hjs-development1-shop_app remoteAddr=163.122.13.97 userid=st6203590000) oracle.jdbc.xa.OracleXAException
01:21:55,568 ERROR [stderr] (http-/144.230.25.156:8280-1 requestURI=/myapp/shop/phone_wall.jsp jsessionid=Uv2Z6OXb-cCJ-WJ0qzOaL71L.hjs-development1-shop_app remoteAddr=163.122.13.97 userid=st6203590000) at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)

01:21:55,856 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/myapp].[jsp]] (http-/144.230.25.156:8280-1) JBWEB000236: S
ervlet.service() for servlet jsp threw exception: java.lang.RuntimeException: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLExcept
ion: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listen
er.TxConnectionListener@24c9faa3[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@5d307ccb connection handles=0
lastUse=1423466514461 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@72a996da pool internal context=SemaphoreArrayLi
stManagedConnectionPool@5e31066f[pool=APPCOREDS] xaResource=XAResourceWrapperImpl@5beefd05[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConn
ection@5d307ccb pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit P
roduction
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options jndiName=java:/APPCOREDS] txSync=null]
at atg.adapter.gsa.GSAItemDescriptor.loadProperty(GSAItemDescriptor.java:6132) [_DAS_slib_sclasses.jar:]
at atg.adapter.gsa.GSAItem.getPersistentPropertyValue(GSAItem.java:1343) [_DAS_slib_sclasses.jar:]

Caused by: CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@24c9faa3[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@5d307ccb connection handles=0 lastUse=1423466514461 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@72a996da pool internal context=SemaphoreArrayListManagedConnectionPool@5e31066f[pool=APPCOREDS] xaResource=XAResourceWrapperImpl@5beefd05[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@5d307ccb pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options jndiName=java:/APPCOREDS] txSync=null]
at atg.adapter.gsa.GSAItemDescriptor.loadProperties(GSAItemDescriptor.java:6084) [_DAS_slib_sclasses.jar:]
at atg.adapter.gsa.GSAItemDescriptor.loadProperty(GSAItemDescriptor.java:6124) [_DAS_slib_sclasses.jar:]
... 63 more
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@24c9faa3[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@5d307ccb connection handles=0 lastUse=1423466514461 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@72a996da pool internal context=SemaphoreArrayListManagedConnectionPool@5e31066f[pool=APPCOREDS] xaResource=XAResourceWrapperImpl@5beefd05[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@5d307ccb pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options jndiName=java:/APPCOREDS] txSync=null]
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
at atg.adapter.gsa.GSATransaction.getConnection(GSATransaction.java:794) [_DAS_slib_sclasses.jar:]
at atg.adapter.gsa.GSAItemDescriptor.getConnection(GSAItemDescriptor.java:2751) [_DAS_slib_sclasses.jar:]
at atg.adapter.gsa.GSAItemDescriptor.loadProperties(GSAItemDescriptor.java:5992) [_DAS_slib_sclasses.jar:]
... 64 more
Caused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.
listener.TxConnectionListener@24c9faa3[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@5d307ccb connection hand
les=0 lastUse=1423466514461 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@72a996da pool internal context=SemaphoreA
rrayListManagedConnectionPool@5e31066f[pool=APPCOREDS] xaResource=XAResourceWrapperImpl@5beefd05[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManag
edConnection@5d307ccb pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 6
4bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options jndiName=java:/APPCOREDS] 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)
... 67 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)
... 69 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:ffff90e6199c:-203cbd2:54d85b4d:151a status: ActionStatus.ABORT_ONLY >
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:572)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:283)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
... 70 more

Su
Log in to join the conversation

Responses

Mustafa Musaji's picture Red Hat Guru 1798 points
9 February 2015 2:44 PM

A very similar issue was answered here - https://issues.jboss.org/browse/AS7-2562

Please check you have your datasources, would be non-XA and thus it looks like your configuration needs to be updated to make sure the datasources are listed under and not xa-datasources.

If that doesn't match your use case then it could be a bug in EAP 6.1 - https://bugzilla.redhat.com/show_bug.cgi?id=1058626 . Can you test this on EAP 6.3.0 and let me know if you still see the same issue?

Thanks
Mustafa

Su Newbie 10 points
11 February 2015 5:52 AM

Thanks Mustafa!

I am using XA-datasource and I don't see any configuration issues.

I have to test with EAP6.3.

KT Newbie 5 points
12 August 2015 9:52 PM

Hey Mustafa,

We are working wih EAP 6.1 and are getting the same error as mentioned below again:

2015-08-12 03:01:42,442 WARN [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@4e4909ea[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@1d2a09cd connection handles=0 lastUse=1439359180498 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2eb3ca33 pool internal context=SemaphoreArrayListManagedConnectionPool@4f91deef[pool=atgcore_ds] xaResource=XAResourceWrapperImpl@387cc1ec[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@1d2a09cd pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options jndiName=java:/atgcore_ds] txSync=null]: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1033)
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:607)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:265)
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 atg.dms.sql.SqlTopicManager.flagWithStatement(SqlTopicManager.java:1008)
at atg.dms.sql.SqlTopicManager.flagNewEntries(SqlTopicManager.java:894)
at atg.dms.sql.SqlTopicManager.pollForNewEntries(SqlTopicManager.java:838)
at atg.dms.sql.SqlJmsManager.poll(SqlJmsManager.java:1620)
at atg.dms.sql.SqlJmsManager.performScheduledTask(SqlJmsManager.java:930)
at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:479)
at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:780)
2015-08-12 03:01:42,447 WARN [com.arjuna.ats.jta] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) ARJUNA016061: TransactionImple.enlistResource - XAResource.start returned: XAException.XAER_RMFAIL for < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffff0a0101e7:397deef7:55cacf38:54375, node_name=1, branch_uid=0:ffff0a0101e7:397deef7:55cacf38:54377, subordinatenodename=null, eis_name=java:/atgcore_ds >: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1033)
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:607)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:265)
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 atg.dms.sql.SqlTopicManager.flagWithStatement(SqlTopicManager.java:1008)
at atg.dms.sql.SqlTopicManager.flagNewEntries(SqlTopicManager.java:894)
at atg.dms.sql.SqlTopicManager.pollForNewEntries(SqlTopicManager.java:838)
at atg.dms.sql.SqlJmsManager.poll(SqlJmsManager.java:1620)
at atg.dms.sql.SqlJmsManager.performScheduledTask(SqlJmsManager.java:930)
at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:479)
at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:780)
2015-08-12 03:01:42,450 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) oracle.jdbc.xa.OracleXAException
2015-08-12 03:01:42,450 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1033)
2015-08-12 03:01:42,450 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
2015-08-12 03:01:42,451 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)
2015-08-12 03:01:42,451 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.start(XAResourceWrapperImpl.java:191)
2015-08-12 03:01:42,451 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:636)
2015-08-12 03:01:42,451 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:397)
2015-08-12 03:01:42,452 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.enlist(TxConnectionListener.java:607)
2015-08-12 03:01:42,452 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:265)
2015-08-12 03:01:42,452 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
2015-08-12 03:01:42,453 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:599)
2015-08-12 03:01:42,453 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:467)
2015-08-12 03:01:42,453 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)
2015-08-12 03:01:42,454 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at atg.dms.sql.SqlTopicManager.flagWithStatement(SqlTopicManager.java:1008)
2015-08-12 03:01:42,454 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at atg.dms.sql.SqlTopicManager.flagNewEntries(SqlTopicManager.java:894)
2015-08-12 03:01:42,454 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at atg.dms.sql.SqlTopicManager.pollForNewEntries(SqlTopicManager.java:838)
2015-08-12 03:01:42,454 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at atg.dms.sql.SqlJmsManager.poll(SqlJmsManager.java:1620)
2015-08-12 03:01:42,455 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at atg.dms.sql.SqlJmsManager.performScheduledTask(SqlJmsManager.java:930)
2015-08-12 03:01:42,455 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:479)
2015-08-12 03:01:42,455 ERROR [stderr] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:780)
2015-08-12 03:01:42,456 ERROR [nucleusNamespace.atg.dynamo.messaging.SqlJmsProvider] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) null: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@4e4909ea[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@1d2a09cd connection handles=0 lastUse=1439359180498 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2eb3ca33 pool internal context=SemaphoreArrayListManagedConnectionPool@4f91deef[pool=atgcore_ds] xaResource=XAResourceWrapperImpl@387cc1ec[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@1d2a09cd pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options jndiName=java:/atgcore_ds] txSync=null]
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)
at atg.dms.sql.SqlTopicManager.flagWithStatement(SqlTopicManager.java:1008)
at atg.dms.sql.SqlTopicManager.flagNewEntries(SqlTopicManager.java:894)
at atg.dms.sql.SqlTopicManager.pollForNewEntries(SqlTopicManager.java:838)
at atg.dms.sql.SqlJmsManager.poll(SqlJmsManager.java:1620)
at atg.dms.sql.SqlJmsManager.performScheduledTask(SqlJmsManager.java:930)
at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:479)
at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:780)
Caused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@4e4909ea[state=DESTROYED managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@1d2a09cd connection handles=0 lastUse=1439359180498 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2eb3ca33 pool internal context=SemaphoreArrayListManagedConnectionPool@4f91deef[pool=atgcore_ds] xaResource=XAResourceWrapperImpl@387cc1ec[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@1d2a09cd pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options jndiName=java:/atgcore_ds] 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)
... 7 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)
... 9 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:ffff0a0101e7:397deef7:55cacf38:54375 status: ActionStatus.ABORT_ONLY >
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:572)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:283)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)
... 10 more
2015-08-12 03:01:44,383 WARN [com.arjuna.ats.jta] (Periodic Recovery:) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:638)
at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.recover(XAManagedConnection.java:358)
at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.recover(XAResourceWrapperImpl.java:165)
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoveryFirstPass(XARecoveryModule.java:534)
at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:168)
at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:743)
at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371)
2015-08-12 03:02:02,433 WARN [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (/atg/dynamo/service/Scheduler-reusablejobhandler-JMS-POLL:) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@5861e727[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@38edec6 connection handles=0 lastUse=1439359202445 trackByTx=true pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@2eb3ca33 pool internal context=SemaphoreArrayListManagedConnectionPool@4f91deef[pool=atgcore_ds] xaResource=XAResourceWrapperImpl@52424e4a[xaResource=org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@38edec6 pad=false overrideRmValue=false productName=Oracle productVersion=Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options jndiName=java:/atgcore_ds] txSync=null]: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1033)
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:607)
at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:265)
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 atg.dms.sql.SqlQueueManager.flagWithStatement(SqlQueueManager.java:1143)
at atg.dms.sql.SqlQueueManager.flagNewEntries(SqlQueueManager.java:1023)
at atg.dms.sql.SqlQueueManager.pollForNewEntries(SqlQueueManager.java:962)
at atg.dms.sql.SqlJmsManager.poll(SqlJmsManager.java:1614)
at atg.dms.sql.SqlJmsManager.performScheduledTask(SqlJmsManager.java:930)
at atg.service.scheduler.ScheduledJob.runJobs(ScheduledJob.java:479)
at atg.service.scheduler.Scheduler$2handler.run(Scheduler.java:780)

Our JBOSS settings are configured as below:


false
true

overrideRmValue=false
no-tx-separate-pools=true
Can you please suggest if we need to change some JBOSS setting for this or is it a bug still not fixed.

Thanks a lot.

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.