Select Your Language

Infrastructure and Management

Cloud Computing

Storage

Runtimes

Integration and Automation

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

    Posted on

    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

    by

    points

    Responses

    Red Hat LinkedIn YouTube Facebook X, formerly Twitter

    Quick Links

    Help

    Site Info

    Related Sites

    © 2025 Red Hat