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

SK

Responses