Recovery Manager cannot recover pending transactions:ORA-01031: insufficient privileges ; JBOSS EAP 6.1.1
hillol.pal Apr 18, 2015 11:28 PMHello
We have a webservice deployed in JBOSS EAP 6.1.1 and Database in use is Oracle 11g.
At some point of time the Application was restarted when a transaction was in progress.
After restart, it is continuously logging the below message and when I checked the Oracle Database, I found one transaction is in pending state from DBA_2PC_pending table
I can understand the recovery manager is trying to rollback the transaction but unable to do it.
There is no change in credential in the configuration files.
Need your help to figure out what could be wrong and how to get rid of this issue.
Appreciate your help
11:27:54,893 ERROR [stderr] (Periodic Recovery) ... 8 more
11:30:04,916 ERROR [stderr] (Periodic Recovery) oracle.jdbc.xa.OracleXAException
11:30:04,917 ERROR [stderr] (Periodic Recovery) at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1213)
11:30:04,917 ERROR [stderr] (Periodic Recovery) at oracle.jdbc.xa.client.OracleXAResource.rollback(OracleXAResource.java:979)
11:30:04,917 ERROR [stderr] (Periodic Recovery) at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.rollback(XAManagedConnection.java:342)
11:30:04,918 ERROR [stderr] (Periodic Recovery) at org.jboss.jca.core.tx.jbossts.XAResourceWrapperImpl.rollback(XAResourceWrapperImpl.java:186)
11:30:04,918 ERROR [stderr] (Periodic Recovery) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.handleOrphan(XARecoveryModule.java:738)
11:30:04,919 ERROR [stderr] (Periodic Recovery) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoverySecondPass(XARecoveryModule.java:644)
11:30:04,919 ERROR [stderr] (Periodic Recovery) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.bottomUpRecovery(XARecoveryModule.java:417)
11:30:04,920 ERROR [stderr] (Periodic Recovery) at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:194)
11:30:04,920 ERROR [stderr] (Periodic Recovery) at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:789)
11:30:04,921 ERROR [stderr] (Periodic Recovery) at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371)
11:30:04,921 ERROR [stderr] (Periodic Recovery) Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
11:30:04,921 ERROR [stderr] (Periodic Recovery)
11:30:04,922 ERROR [stderr] (Periodic Recovery) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
P.S: My experience with JBOSS is pretty minimal