Atomikos Forum |
|
Hi,
we are using atomikos 3.9.22 with spring, mybatis, hornetq and oracle 11g. Facing the below issue sometimes. Its intermittent. We are unable to understand the cause of the issue : ERROR com.acn.hps.aops.cm.events.common.dao.impl.QuickLinkIntelligenceDAOImpl - executePLSQL() :: CallableStatementCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA] with heuristic messages: XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639'; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA] with heuristic messages: XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639' org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA] with heuristic messages: XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639'; nested exception is com.atomikos.jdbc.AtomikosSQLException: Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA] with heuristic messages: com.atomikos.jdbc.AtomikosSQLException: Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA] with heuristic messages: XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639' at com.atomikos.jdbc.AtomikosSQLException.throwAtomikosSQLException(AtomikosSQLException.java:46) at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:237) at com.atomikos.jdbc.AtomikosConnectionProxy.invoke(AtomikosConnectionProxy.java:142) at com.sun.proxy.$Proxy45.prepareCall(Unknown Source) at com.acn.hps.aops.arch.services.AopsCallableStatementCreator.createCallableStatement(AopsCallableStatementCreator.java:101) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014) ... 105 common frames omitted Caused by: com.atomikos.datasource.xa.session.InvalidSessionHandleStateException: Failed to resume branch: XAResourceTransaction: 3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639 [ACTIVE in resource aopsXA] with heuristic messages: XA resource 'aopsXA' accessed with Xid '3132372E302E302E312E746D30353832313030303038:3132372E302E302E312E746D34373639' at com.atomikos.datasource.xa.session.BranchEnlistedStateHandler.<init>(BranchEnlistedStateHandler.java:74) at com.atomikos.datasource.xa.session.BranchSuspendedStateHandler.transactionResumed(BranchSuspendedStateHandler.java:81) at com.atomikos.datasource.xa.session.TransactionContext.transactionResumed(TransactionContext.java:124) at com.atomikos.datasource.xa.session.SessionHandleState.notifyBeforeUse(SessionHandleState.java:173) at com.atomikos.jdbc.AtomikosConnectionProxy.enlist(AtomikosConnectionProxy.java:227) ... 109 common frames omitted Can anyone help us to know the reason why this kind of thing happens. Why its failing while resuming the branch of the transaction. |