]
Mark S updated JBTM-2392:
-------------------------
Environment:
* 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
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) - 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
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,@p2 output,@p3 output,8388608,@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-wa...