[jbossts-issues] [JBoss JIRA] (JBTM-2392) XA recovery exceptions

[Mark S (JIRA)]

     [ https://issues.jboss.org/browse/JBTM-2392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark S updated JBTM-2392:
-------------------------
    Environment: wildfly-8.2.0.Final +  Windows 7 +  Microsoft SQL Server 2008 (SP2) + Microsoft JDBC 4.0 and 4.1 Drivers   (was: * wildfly-8.2.0.Final

* Windows 7

* Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)   Feb 25 2011 13:56:11   Copyright (c) 1988-2008 Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

* Both Microsoft JDBC Driver for SQL Server 4.0 and 4.1 Drivers)


> XA recovery exceptions
> ----------------------
>
>                 Key: JBTM-2392
>                 URL: https://issues.jboss.org/browse/JBTM-2392
>             Project: JBoss Transaction Manager
>          Issue Type: Feature Request
>         Environment: wildfly-8.2.0.Final +  Windows 7 +  Microsoft SQL Server 2008 (SP2) + Microsoft JDBC 4.0 and 4.1 Drivers 
>            Reporter: Mark S
>            Assignee: Tom Jenkinson
>
> h3. Wildfly Exception Stack Trace of Issue:
> {code}
> 12:12:42,427 WARN  [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016008: Local XARecoveryModule.xaRecovery - caught exception: java.lang.NullPointerException
> 	at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoverySecondPass(XARecoveryModule.java:650) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 	at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.bottomUpRecovery(XARecoveryModule.java:431) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 	at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:212) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 	at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:789) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 	at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 12:12:42,431 WARN  [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException: The function RECOVER: failed. The status is: -3. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_recover, state=1, StatusCode:-3 (0xFFFFFFFD) ***"
> 	at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:550)
> 	at com.microsoft.sqlserver.jdbc.SQLServerXAResource.recover(SQLServerXAResource.java:728)
> 	at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.recover(XAManagedConnection.java:362)
> 	at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.xaRecoverySecondPass(XARecoveryModule.java:740) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 	at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.bottomUpRecovery(XARecoveryModule.java:431) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 	at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkSecondPass(XARecoveryModule.java:212) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 	at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:789) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> 	at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:371) [narayana-jts-jacorb-5.0.0.Final.jar:5.0.0.Final (revision: 9aa71)]
> {code}
> h3. SQL Server Profiler Stack Trace of Issue:
> declare @p2 int
> set @p2=-3
> declare @p3 nvarchar(max)
> set @p3=N'*** SQLJDBC_XA DTC_ERROR Context: xa_recover, state=1, StatusCode:-3 (0xFFFFFFFD) ***'
> declare @p5 varbinary(max)
> set @p5=NULL
> exec sp_execute 1, at p2 output, at p3 output,8388608, at p5 output
> select @p2, @p3, @p5
> Possible Related Issues:
> * https://issues.jboss.org/browse/JBTM-1433
> * http://stackoverflow.com/questions/14476414/jboss-spamming-xa-recovery-warnings



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)