October 11, 2017 at 11:39 am
Trying to track down a bug. Not sure if the source is in SQL Server or not. I've got an exception happening on the SQL Server host:
Exception happened when running extended stored procedure 'xp_sqljdbc_xa_start' in the library 'SQLJDBC_XA.dll'. SQL Server is terminating process 61. Exception type: Win32 exception; Exception code: 0xc0000005. To generate a minidump, create an xevent session using the dump routine event with the create dump action.
Error: 18002, Severity: 20, State: 1.
This happens from a jBoss JavaEE application using XA transactions, but only in a certain scenario. I'm not sure if the SQL Server is the cause or the Java code is the cause. The code was working OK on Oracle 12c, I'm in the process of migrating to Microsoft SQL Server 2016 (SP1) (KB3182545) -13.0.4001.0 (X64).
The application itself is working good now, but the jBPM module is throwing this error. Curious if any SQL people can help decipher the sql dump as it's pretty much voodo to me.
Java Error (using mssql-jdbc-6.2.1.jre7.jar):13:11:00,352 [WorkManager(2)-102] DEBUG [AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 1)
13:11:00,352 [WorkManager(2)-102] DEBUG [ConnectionManager] opening JDBC connection
13:11:00,353 [WorkManager(2)-102] DEBUG [JDBCExceptionReporter] Cannot open connection [???]
org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -71740de1:b97:59de3c6a:222c status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -71740de1:b97:59de3c6a:222c status: ActionStatus.ABORT_ONLY > )
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
SQL Dump:Current time is 13:10:53 10/11/17.
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 13.0.4001.0
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is Intel(R) Xeon(R) CPU E5-2680 0 @ 2.70GHz.
Bios Version is INTEL - 6040000
PhoenixBIOS 4.0 Release 6.0
4 X64 level 8664, 14 Mhz processor (s).
Windows NT 6.2 Build 9200 CSD .
Memory
MemoryLoad = 27%
Total Physical = 32767 MB
Available Physical = 23719 MB
Total Page File = 37631 MB
Available Page File = 27399 MB
Total Virtual = 134217727 MB
Available Virtual = 134163771 MB
***Stack Dump being sent to G:\MedSt\MSSQL13.MEDST\MSSQL\LOG\SQLDump0032.txt
SqlDumpExceptionHandler: Process 61 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 10/11/17 13:10:53 spid 61
*
*
* Exception Address = 00007FFBF335B128 Module(SQLJDBC_XA+000000000000B128)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00007FFBF3382000
* Input Buffer 255 bytes -
* 16 00 00 00 12 00 00 00 02 00 00 00 00 00 00 00 00 00
* ÿÿ ç@ Ð 01 00 00 00 ff ff 0a 00 00 00 00 00 e7 40 1f 09 04 d0
* Þ E X E C m a 00 00 de 01 45 00 58 00 45 00 43 00 20 00 6d 00 61 00
* s t e r . . x p _ 73 00 74 00 65 00 72 00 2e 00 2e 00 78 00 70 00 5f 00
* s q l j d b c _ x 73 00 71 00 6c 00 6a 00 64 00 62 00 63 00 5f 00 78 00
* a _ s t a r t @ 61 00 5f 00 73 00 74 00 61 00 72 00 74 00 20 00 40 00
* P 0 O U T , @ 50 00 30 00 20 00 4f 00 55 00 54 00 2c 00 20 00 40 00
* P 1 O U T , @ 50 00 31 00 20 00 4f 00 55 00 54 00 2c 00 20 00 40 00
* P 2 , @ P 3 , 50 00 32 00 2c 00 20 00 40 00 50 00 33 00 2c 00 20 00
* @ P 4 , @ P 5 40 00 50 00 34 00 2c 00 20 00 40 00 50 00 35 00 20 00
* O U T , @ P 6 , 4f 00 55 00 54 00 2c 00 20 00 40 00 50 00 36 00 2c 00
* @ P 7 , @ P 8 20 00 40 00 50 00 37 00 2c 00 20 00 40 00 50 00 38 00
* O U T , @ P 9 20 00 4f 00 55 00 54 00 2c 00 20 00 40 00 50 00 39 00
* , @ P 1 0 , @ 2c 00 20 00 40 00 50 00 31 00 30 00 2c 00 20 00 40 00
* P 1 1 , @ P 1 2 50 00 31 00 31 00 2c 00 20 00 40 00 50 00 31 00 32 00
* , @ P 1 3 , @ 2c 00 20 00 40 00 50 00 31 00 33 00 2c 00 20 00 40 00
* P 1 4 , @ P 1 5 50 00 31 00 34 00 2c 00 20 00 40 00 50 00 31 00 35 00
* O U T 20 00 4f 00 55 00 54 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00 20 00
* ç@ 20 00 20 00 20 00 20 00 20 00 20 00 20 00 00 00 e7 40
* Ð ô @ P 0 i 1f 09 04 d0 00 00 f4 01 40 00 50 00 30 00 20 00 69 00
* n t O U T P U T 6e 00 74 00 20 00 4f 00 55 00 54 00 50 00 55 00 54 00
* , @ P 1 n v a r 2c 00 40 00 50 00 31 00 20 00 6e 00 76 00 61 00 72 00
* c h a r ( 4 0 0 0 63 00 68 00 61 00 72 00 28 00 34 00 30 00 30 00 30 00
* ) O U T P U T , 29 00 20 00 4f 00 55 00 54 00 50 00 55 00 54 00 2c 00
* @ P 2 v a r b i 40 00 50 00 32 00 20 00 76 00 61 00 72 00 62 00 69 00
* n a r y ( 8 0 0 0 6e 00 61 00 72 00 79 00 28 00 38 00 30 00 30 00 30 00
* ) , @ P 3 v a r 29 00 2c 00 40 00 50 00 33 00 20 00 76 00 61 00 72 00
* b i n a r y ( 8 0 62 00 69 00 6e 00 61 00 72 00 79 00 28 00 38 00 30 00
* 0 0 ) , @ P 4 i 30 00 30 00 29 00 2c 00 40 00 50 00 34 00 20 00 69 00
* n t , @ P 5 v a 6e 00 74 00 2c 00 40 00 50 00 35 00 20 00 76 00 61 00
* r b i n a r y ( 8 72 00 62 00 69 00 6e 00 61 00 72 00 79 00 28 00 38 00
* 0 0 0 ) O U T P 30 00 30 00 30 00 29 00 20 00 4f 00 55 00 54 00 50 00
* U T , @ P 6 i n 55 00 54 00 2c 00 40 00 50 00 36 00 20 00 69 00 6e 00
* t , @ P 7 i n t 74 00 2c 00 40 00 50 00 37 00 20 00 69 00 6e 00 74 00
* , @ P 8 n v a r 2c 00 40 00 50 00 38 00 20 00 6e 00 76 00 61 00 72 00
* c h a r ( 4 0 0 0 63 00 68 00 61 00 72 00 28 00 34 00 30 00 30 00 30 00
* ) O U T P U T , 29 00 20 00 4f 00 55 00 54 00 50 00 55 00 54 00 2c 00
* @ P 9 i n t , @ 40 00 50 00 39 00 20 00 69 00 6e 00 74 00 2c 00 40 00
* P 1 0 i n t , @ 50 00 31 00 30 00 20 00 69 00 6e 00 74 00 2c 00 40 00
* P 1 1 v a r b i 50 00 31 00 31 00 20 00 76 00 61 00 72 00 62 00 69 00
* n a r y ( 8 0 0 0 6e 00 61 00 72 00 79 00 28 00 38 00 30 00 30 00 30 00
* ) , @ P 1 2 i n 29 00 2c 00 40 00 50 00 31 00 32 00 20 00 69 00 6e 00
* t , @ P 1 3 i n 74 00 2c 00 40 00 50 00 31 00 33 00 20 00 69 00 6e 00
* t , @ P 1 4 i n 74 00 2c 00 40 00 50 00 31 00 34 00 20 00 69 00 6e 00
* t , @ P 1 5 v a 74 00 2c 00 40 00 50 00 31 00 35 00 20 00 76 00 61 00
* r b i n a r y ( 8 72 00 62 00 69 00 6e 00 61 00 72 00 79 00 28 00 38 00
* 0 0 0 ) O U T P 30 00 30 00 30 00 29 00 20 00 4f 00 55 00 54 00 50 00
* U T & çÿÿ Ð 55 00 54 00 00 01 26 04 00 00 01 e7 ff ff 09 04 d0 00
* ÿÿÿÿÿÿÿÿ ¥@ 1- 00 ff ff ff ff ff ff ff ff 00 00 a5 40 1f 1d 00 31 2d
* -71740de1:b97:59de 2d 37 31 37 34 30 64 65 31 3a 62 39 37 3a 35 39 64 65
* 3c6a:222c ¥@ -7 33 63 36 61 3a 32 32 32 63 00 00 a5 40 1f 1b 00 2d 37
* 1740de1:b97:59de3c 31 37 34 30 64 65 31 3a 62 39 37 3a 35 39 64 65 33 63
* 6a:222e & 36 61 3a 32 32 32 65 00 00 26 04 04 00 00 00 00 00 01
* ¥ÿÿÿÿÿÿÿÿÿÿ & O a5 ff ff ff ff ff ff ff ff ff ff 00 00 26 04 04 80 4f
* & çÿÿ 12 00 00 00 26 04 04 03 00 02 00 00 01 e7 ff ff 09 04
* Ð ÿÿÿÿÿÿÿÿ & d0 00 00 ff ff ff ff ff ff ff ff 00 00 26 04 04 0d 00
* & ¥@ 00 00 00 00 26 04 04 05 00 00 00 00 00 a5 40 1f 05 00
* MEDST & @ & 4d 45 44 53 54 00 00 26 04 04 40 00 00 00 00 00 26 04
* @ & ¥ÿ 04 40 00 00 00 00 00 26 04 04 01 00 00 00 00 01 a5 ff
* ÿÿÿÿÿÿÿÿÿ ff ff ff ff ff ff ff ff ff
*
*
* MODULE BASE END SIZE
* sqlservr 00007FF69F0C0000 00007FF69F127FFF 00068000
* ntdll 00007FFC01340000 00007FFC014ECFFF 001ad000
* KERNEL32 00007FFBFEE90000 00007FFBFEFCDFFF 0013e000
* KERNELBASE 00007FFBFE800000 00007FFBFE914FFF 00115000
* NETAPI32 00007FFBFBDF0000 00007FFBFBE05FFF 00016000
* pdh 00007FFBF8590000 00007FFBF85DEFFF 0004f000
* ADVAPI32 00007FFC011D0000 00007FFC01279FFF 000aa000
* ole32 00007FFBFF860000 00007FFBFF9F3FFF 00194000
* SQLOS 00007FFBFB7D0000 00007FFBFB7D6FFF 00007000
* sqlmin 00007FFBF3B80000 00007FFBF604AFFF 024cb000
* sqllang 00007FFBCC0F0000 00007FFBCE696FFF 025a7000
* sqlTsEs 00007FFBF7C70000 00007FFBF84FAFFF 0088b000
* sqldk 00007FFBF77A0000 00007FFBF7C67FFF 004c8000
* opends60 00007FFBFB780000 00007FFBFB788FFF 00009000
* qds 00007FFBF76C0000 00007FFBF779BFFF 000dc000
* MSVCP120 00007FFBF8750000 00007FFBF87F5FFF 000a6000
* MSVCR120 00007FFBF8660000 00007FFBF874EFFF 000ef000
* netutils 00007FFBFCD60000 00007FFBFCD6BFFF 0000c000
* srvcli 00007FFBFE1F0000 00007FFBFE215FFF 00026000
* wkscli 00007FFBFCE30000 00007FFBFCE46FFF 00017000
* msvcrt 00007FFBFEFD0000 00007FFBFF079FFF 000aa000
* RPCRT4 00007FFBFF310000 00007FFBFF44FFFF 00140000
* sechost 00007FFC01170000 00007FFC011C8FFF 00059000
* combase 00007FFBFF080000 00007FFBFF291FFF 00212000
* GDI32 00007FFBFEB60000 00007FFBFECAAFFF 0014b000
* USER32 00007FFBFFAC0000 00007FFBFFC36FFF 00177000
* CRYPT32 00007FFBFE5C0000 00007FFBFE79EFFF 001df000
* Secur32 00007FFBFD640000 00007FFBFD64BFFF 0000c000
* WS2_32 00007FFBFF520000 00007FFBFF579FFF 0005a000
* WINHTTP 00007FFBF2B20000 00007FFBF2BE8FFF 000c9000
* bcrypt 00007FFBFDF50000 00007FFBFDF75FFF 00026000
* OLEAUT32 00007FFBFF450000 00007FFBFF515FFF 000c6000
* ODBC32 00007FFBF2A50000 00007FFBF2B11FFF 000c2000
* USERENV 00007FFBFDCF0000 00007FFBFDD10FFF 00021000
* AUTHZ 00007FFBFD710000 00007FFBFD757FFF 00048000
* WINTRUST 00007FFBFE7A0000 00007FFBFE7F0FFF 00051000
* XmlLite 00007FFBF9CD0000 00007FFBF9D08FFF 00039000
* dhcpcsvc 00007FFBFA3D0000 00007FFBFA3E9FFF 0001a000
* WINMM 00007FFBF27B0000 00007FFBF27D1FFF 00022000
* SspiCli 00007FFBFE540000 00007FFBFE56DFFF 0002e000
* MSASN1 00007FFBFE520000 00007FFBFE530FFF 00011000
* NSI 00007FFBFFA00000 00007FFBFFA08FFF 00009000
* profapi 00007FFBFE430000 00007FFBFE444FFF 00015000
* WINMMBASE 00007FFBF2780000 00007FFBF27A9FFF 0002a000
* LOGONCLI 00007FFBFDC90000 00007FFBFDCCEFFF 0003f000
* cfgmgr32 00007FFBFE570000 00007FFBFE5BEFFF 0004f000
* DEVOBJ 00007FFBFD2C0000 00007FFBFD2E7FFF 00028000
* SAMCLI 00007FFBF8C40000 00007FFBF8C56FFF 00017000
* psapi 00007FFBFF6A0000 00007FFBFF6A6FFF 00007000
* kernel.appcore 00007FFBFD100000 00007FFBFD10AFFF 0000b000
* CRYPTBASE 00007FFBFE450000 00007FFBFE45AFFF 0000b000
* bcryptPrimitives 00007FFBFE270000 00007FFBFE2D2FFF 00063000
* instapi130 00007FFBF2740000 00007FFBF274FFFF 00010000
* CRYPTSP 00007FFBFDD20000 00007FFBFDD3FFFF 00020000
* rsaenh 00007FFBFD930000 00007FFBFD965FFF 00036000
* imagehlp 00007FFBFEB40000 00007FFBFEB55FFF 00016000
* ncrypt 00007FFBFDF20000 00007FFBFDF44FFF 00025000
* NTASN1 00007FFBFDEA0000 00007FFBFDED6FFF 00037000
* gpapi 00007FFBFD660000 00007FFBFD683FFF 00024000
* cscapi 00007FFBECF10000 00007FFBECF21FFF 00012000
* sqlevn70 00007FFBF73D0000 00007FFBF76BDFFF 002ee000
* CLUSAPI 00007FFBEB5E0000 00007FFBEB64DFFF 0006e000
* cryptdll 00007FFBFDCD0000 00007FFBFDCE9FFF 0001a000
* RESUTILS 00007FFBEB590000 00007FFBEB5DBFFF 0004c000
* VERSION 00007FFBF8FD0000 00007FFBF8FD9FFF 0000a000
* hkruntime 00007FFBF7100000 00007FFBF73CFFFF 002d0000
* hkcompile 00007FFBF6FB0000 00007FFBF70F1FFF 00142000
* hkengine 00007FFBF6A40000 00007FFBF6FAAFFF 0056b000
* dbghelp 0000000071EE0000 0000000072075FFF 00196000
* SHLWAPI 00007FFBFF2B0000 00007FFBFF303FFF 00054000
* pcwum 00007FFBFD6A0000 00007FFBFD6ADFFF 0000e000
* msv1_0 00007FFBFDC10000 00007FFBFDC7DFFF 0006e000
* kerberos 00007FFBFDD40000 00007FFBFDE31FFF 000f2000
* schannel 00007FFBFD8C0000 00007FFBFD92DFFF 0006e000
* MSCOREE 00007FFBF1B50000 00007FFBF1BB3FFF 00064000
* mscoreei 00007FFBF1AB0000 00007FFBF1B47FFF 00098000
* SqlServerSpatial130 00007FFBF6980000 00007FFBF6A31FFF 000b2000
* security 00007FFBF8640000 00007FFBF8642FFF 00003000
* clbcatq 00007FFC01280000 00007FFC01335FFF 000b6000
* BatchParser 00007FFBFA6A0000 00007FFBFA6CBFFF 0002c000
* DPAPI 00007FFBFD7F0000 00007FFBFD7F9FFF 0000a000
* sqlncli11 00007FFBE9FC0000 00007FFBEA312FFF 00353000
* MSVCR100 0000000072140000 0000000072211FFF 000d2000
* COMCTL32 00007FFBE9F10000 00007FFBE9FB3FFF 000a4000
* COMDLG32 00007FFBFF5E0000 00007FFBFF695FFF 000b6000
* SHELL32 00007FFBFFC40000 00007FFC01168FFF 01529000
* SHCORE 00007FFBFCD70000 00007FFBFCE21FFF 000b2000
* SQLNCLIR11 0000000071B40000 0000000071B77FFF 00038000
* netbios 00007FFBE9F00000 00007FFBE9F0AFFF 0000b000
* sqlnclirda11 00000000717E0000 0000000071B38FFF 00359000
* SQLNCLIRDAR11 00000000717A0000 00000000717D7FFF 00038000
* clr 00007FFBF10D0000 00007FFBF1AAEFFF 009df000
* MSVCR120_CLR0400 00007FFBF0FD0000 00007FFBF10C6FFF 000f7000
* mswsock 00007FFBFDB90000 00007FFBFDBE8FFF 00059000
* ntmarta 00007FFBFB210000 00007FFBFB241FFF 00032000
* mscorlib.ni 00007FFBDEC10000 00007FFBE018DFFF 0157e000
* ntdsapi 00007FFBFBE10000 00007FFBFBE38FFF 00029000
* DSPARSE 00007FFBF9190000 00007FFBF919BFFF 0000c000
* clrjit 00007FFBECDF0000 00007FFBECF03FFF 00114000
* DNSAPI 00007FFBFDA00000 00007FFBFDAA3FFF 000a4000
* rasadhlp 00007FFBF9490000 00007FFBF9499FFF 0000a000
* IPHLPAPI 00007FFBFAE50000 00007FFBFAE79FFF 0002a000
* WINNSI 00007FFBFA9E0000 00007FFBFA9E9FFF 0000a000
* fwpuclnt 00007FFBFA5B0000 00007FFBFA61AFFF 0006b000
* netfxperf 00007FFBFB770000 00007FFBFB77EFFF 0000f000
* perfcounter 00007FFBE96D0000 00007FFBE970CFFF 0003d000
* CorperfmonExt 00007FFBF85E0000 00007FFBF8604FFF 00025000
* WTSAPI32 00007FFBFA4B0000 00007FFBFA4C1FFF 00012000
* esentprf 00007FFBF88D0000 00007FFBF88E7FFF 00018000
* msdtcuiu 00007FFBF6910000 00007FFBF695FFFF 00050000
* ATL 00007FFBFB7A0000 00007FFBFB7BFFFF 00020000
* MSDTCPRX 00007FFBE9530000 00007FFBE960CFFF 000dd000
* MTXCLU 00007FFBE8E20000 00007FFBE8E86FFF 00067000
* ktmw32 00007FFBF9E50000 00007FFBF9E5AFFF 0000b000
* MSMDCTR130 00007FFBF88B0000 00007FFBF88BAFFF 0000b000
* perf-MSSQL$MEDST-sqlctr13.1.4001.0 00007FFBF6880000 00007FFBF68DAFFF 0005b000
* perf-MSSQLSERVER-sqlctr11.3.6020.0 00007FFBF6610000 00007FFBF665EFFF 0004f000
* instapi110 00007FFBECF50000 00007FFBECF5DFFF 0000e000
* perfdisk 00007FFBE94F0000 00007FFBE94FEFFF 0000f000
* WMICLNT 00007FFBFA420000 00007FFBFA42EFFF 0000f000
* perfnet 00007FFBF6970000 00007FFBF6979FFF 0000a000
* BROWCLI 00007FFBE8FC0000 00007FFBE8FD2FFF 00013000
* perfos 00007FFBE8FB0000 00007FFBE8FBCFFF 0000d000
* perfproc 00007FFBF6600000 00007FFBF660EFFF 0000f000
* rasctrs 00007FFBF65C0000 00007FFBF65C8FFF 00009000
* rasman 00007FFBFA9B0000 00007FFBFA9DFFFF 00030000
* perf-ReportServer$MEDST-rsctr13.1.4001.0 00007FFBF65A0000 00007FFBF65B7FFF 00018000
* ncryptsslp 00007FFBEA400000 00007FFBEA41CFFF 0001d000
* winspool 00007FFBE8EE0000 00007FFBE8F61FFF 00082000
* perf-MSSQL13.MEDST-sqlagtctr 00007FFBF6580000 00007FFBF659AFFF 0001b000
* perf-MSSQL11.MSSQLSERVER-sqlagtctr 00007FFBF6560000 00007FFBF6579FFF 0001a000
* tapiperf 00007FFBF6550000 00007FFBF6557FFF 00008000
* Perfctrs 00007FFBE8460000 00007FFBE8470FFF 00011000
* perfts 00007FFBF6540000 00007FFBF6548FFF 00009000
* WINSTA 00007FFBFE380000 00007FFBFE3D9FFF 0005a000
* UTILDLL 00007FFBE8420000 00007FFBE8436FFF 00017000
* SETUPAPI 00007FFBFECB0000 00007FFBFEE89FFF 001da000
* usbperf 00007FFBF6530000 00007FFBF6537FFF 00008000
* msxml3 00007FFBE9CB0000 00007FFBE9EF1FFF 00242000
* ualapi 00007FFBF9470000 00007FFBF9488FFF 00019000
* ESENT 00007FFBF91A0000 00007FFBF9469FFF 002ca000
* xpsqlbot 00007FFBF6520000 00007FFBF6527FFF 00008000
* xpstar 00007FFBF64B0000 00007FFBF6518FFF 00069000
* SQLSCM 00007FFBFA690000 00007FFBFA69FFFF 00010000
* xpstar 00007FFBF64A0000 00007FFBF64ACFFF 0000d000
* SQLJDBC_XA 00007FFBF3350000 00007FFBF3381FFF 00032000
* XOLEHLP 00007FFBE51B0000 00007FFBE51C5FFF 00016000
* COMRES 00007FFBE8810000 00007FFBE894DFFF 0013e000
* xplog70 00007FFBF60A0000 00007FFBF60B0FFF 00011000
* xplog70 00007FFBF8570000 00007FFBF8573FFF 00004000
* dbghelp 00000000700D0000 0000000070265FFF 00196000
*
* P1Home: 0000000000000000:
* P2Home: 0000000000000000:
* P3Home: 0000007738ADA6E8: 0000007739533060 0000007738ADA708 000000000000002F 0000000000124FAF 0000C857
80796A4A 0000000000000000
* P4Home: 0000007738ADECE0: 000096D9DD09799D 0000007738ADEF78 00007FFBCC3E4DB0 0000007738000000 00000000
00000000 0000007738ADF088
* P5Home: 00007FFBF780DAC0: 9090C300000003B8 9090909090909090 9090C300000002B8 9090909090909090 FB35A7E8
28EC8348 909090909090CCFF
* P6Home: 0000006F69000000: 0001000200000000 0000006F69000040 0006000700000001 0000000000000DC0 00000000
00000000 0000000000000000
* ContextFlags: 000000000010005F:
* MxCsr: 0000000000001FA8:
* SegCs: 0000000000000033:
* SegDs: 000000000000002B:
* SegEs: 000000000000002B:
* SegFs: 0000000000000053:
* SegGs: 000000000000002B:
* SegSs: 000000000000002B:
* EFlags: 0000000000010202:
* Rax: 0000007738ADA6E8: 0000007739533060 0000007738ADA708 000000000000002F 0000000000124FAF 0000C857
80796A4A 0000000000000000
* Rcx: 0000007739548220: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 00000000
00000000 0000000000000000
* Rdx: 00007F84B9E39DD1:
* Rbx: 0000007738ADA6E8: 0000007739533060 0000007738ADA708 000000000000002F 0000000000124FAF 0000C857
80796A4A 0000000000000000
* Rsp: 0000007738ADA688: 00007FFBF33544FC 0000007738ADA6E8 0000000000124FAF 000000000000002F 00000077
38ADA7A4 0000000000124F80
* Rbp: 00007FFBF336CE60: 74756F656D69540A 3D2065756C617620 0000000000642520 4552415754464F53 32333436
776F575C 63694D5C65646F4E
* Rsi: 0000000000124F80:
* Rdi: 0000000000124FAF:
* R8: 0000000000124F6F:
* R9: 00000000000021FB:
* R10: 00007FFBF336CE60: 74756F656D69540A 3D2065756C617620 0000000000642520 4552415754464F53 32333436
776F575C 63694D5C65646F4E
* R11: 000000773953308F: 74756F656D69540A 3D2065756C617620 0000000000642520 4552415754464F53 32333436
776F575C 63694D5C65646F4E
* R12: 0000007738ADC401: 5000000000FF0000 A00050004F005200 140000006F612C13 0000007FFBF77A30 00000000
00000000 000000006F000000
* R13: 0000006F40101110: 004A004C00510053 005F004300420044 0064002E00410058 00000000006C006C 00000020
0009FA45 0000000000000030
* R14: 0000000000124F80:
* R15: 0000000000000001:
* Rip: 00007FFBF335B128: 0A4C100F0A04100F 00000080C1814810 9049290F8041290F 4C100FA00A44100F 41290FC9
FF49B00A 44100FB049290FA0
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
00007FFBF335B128 Module(SQLJDBC_XA+000000000000B128)
00007FFBF33544FC Module(SQLJDBC_XA+00000000000044FC)
00007FFBF33522F8 Module(SQLJDBC_XA+00000000000022F8)
00007FFBF33574FD Module(SQLJDBC_XA+00000000000074FD)
00007FFBCD019782 Module(sqllang+0000000000F29782)
00007FFBCD0194F8 Module(sqllang+0000000000F294F8)
00007FFBCD01847A Module(sqllang+0000000000F2847A)
00007FFBCD0188B9 Module(sqllang+0000000000F288B9)
00007FFBCCDD0A0E Module(sqllang+0000000000CE0A0E)
00007FFBCC4F2930 Module(sqllang+0000000000402930)
00007FFBCCE0D83D Module(sqllang+0000000000D1D83D)
00007FFBCCE0D241 Module(sqllang+0000000000D1D241)
00007FFBCCE09F98 Module(sqllang+0000000000D19F98)
00007FFBCC1019CA Module(sqllang+00000000000119CA)
00007FFBCC102933 Module(sqllang+0000000000012933)
00007FFBCC102041 Module(sqllang+0000000000012041)
00007FFBCCDC3F6D Module(sqllang+0000000000CD3F6D)
00007FFBCCDD0E6C Module(sqllang+0000000000CE0E6C)
00007FFBCCDD1549 Module(sqllang+0000000000CE1549)
00007FFBCC10A82B Module(sqllang+000000000001A82B)
00007FFBCC111542 Module(sqllang+0000000000021542)
00007FFBCC1110A3 Module(sqllang+00000000000210A3)
00007FFBF77A5BFD Module(sqldk+0000000000005BFD)
00007FFBF77A58F5 Module(sqldk+00000000000058F5)
00007FFBF77A554D Module(sqldk+000000000000554D)
00007FFBF77CD7C8 Module(sqldk+000000000002D7C8)
00007FFBF77CDB10 Module(sqldk+000000000002DB10)
00007FFBF77CDCD7 Module(sqldk+000000000002DCD7)
00007FFBF77CD9F8 Module(sqldk+000000000002D9F8)
00007FFBFEE913D2 Module(KERNEL32+00000000000013D2)
00007FFC013554F4 Module(ntdll+00000000000154F4)
CSession @0x0000006F224DC6B0
----------------------------
m_sessionId = 61 m_cRef = 11 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 8 m_rgcRefType[3] = 1
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x0000006F224DC040
m_pstackBhfPool = 0x0000006F224D8370 m_dwLoginFlags = 0x180003e0 m_fBackground = 0
m_eConnResetOption = 0 m_fUserProc = 1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fAuditLoginSent = 1
m_fAuditLoginFailedSent = 0 m_fReplRelease = 0 m_fKill = 0
m_ulLoginStamp = 185522 m_eclClient = 7 m_protType = 5
CUEnvTransient @0x0000006F224DCB40
----------------------------------
m_ululRowcount = 1 m_cidLastOpen = 0 m_lFetchStat = 0
m_lRetStat = 0 m_lLastError = 0 m_lPrevError = 0
m_cNestLevel = 0 m_lHoldRand1 = 0 m_lHoldRand2 = 0
m_cbContextInfo = 0 m_rgbContextInfo = 0000006F224DCD2C
CDbAndSetOpts @0x0000006F224DCB60
---------------------------------
m_fHasDbRef = 0 m_fDateFirstSet = 0 m_fDateFormatSet = 0
m_lUserOpt1 = 0x14816000 m_lUserOpt2 = 0x0 m_lUserOpt1SetMask = 0xffffe7f7
m_idtInsert.objid = 0 m_idtInsert.state = 0 m_idtInsert.dbid = 0
m_llRowcnt = 0 m_lStatList = 0 m_lTextSize = -1
m_lOffsets = 0x0 m_ulLockTimeout = 4294967295 m_ulQueryGov = 0
m_eDtFmt = 1 m_eDayDateFirst = 7 m_eDdLckPri = 0
m_eIsoLvl = 2 m_eFipsFlag = 0x0 m_sLangId = 0
m_pV7LoginRec
---------------------
0000000000000000: 39010000 04000074 401f0000 00010206 00000000 9......t@...........
0000000000000014: 00000000 e0030018 00000000 00000000 5e000a00 ....à...........^...
0000000000000028: 72000600 7e000000 90002400 d8000900 ea000400 r...~.....$.Ø. .ê...
000000000000003C: ee001900 00000000 20010900 00000000 00000000 î....... . .........
0000000000000050: 00000000 00000000 00000000 0000 ..............
CPhysicalConnection @0x0000006F224DC3D0
---------------------------------------
m_pPhyConn->m_pmo = 0x0000006F224DC040
m_pPhyConn->m_pNetConn = 0x0000006F224DCF10
m_pPhyConn->m_pConnList = 0x0000006F224DC680
m_pPhyConn->m_pSess = 0x0000006F224DC708 m_pPhyConn->m_fTracked = -1
m_pPhyConn->m_cbPacketsize = 8000 m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0
CBatch @0x0000006F224DDAC0
--------------------------
m_pSess = 0x0000006F224DC6B0 m_pConn = 0x0000006F224DD4E0 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x0000006F612A0CA8
EXCEPT (null) @0x0000007738AD7500
---------------------------------
exc_number = 0 exc_severity = 0 exc_func = sqldk.dll+0x000000000006D9C0
Task @0x0000006F612A0CA8
------------------------
CPU Ticks used (ms) = 0 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x0000000000000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x0000000000000000
WAITINFO_EXTERNAL: WaitResource = 0x0000000000000000 WAITINFO_EXTERNAL: WaitType = 0x4000D6
WAITINFO_EXTERNAL: WaitSpinlock = 0x0000000000000000 SchedulerId = 0x2
ThreadId = 0x2ecc m_state = 0 m_eAbortSev = 0
EC @0x0000006F224D7780
----------------------
spid = 0 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 ecType = 0
__pSETLS = 0x0000006F224DD550 __pSEParams = 0x0000006F224DDC60
SEInternalTLS @0x0000006F224DD550
---------------------------------
m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x0000006F612A0CA8
m_activeHeapDatasetList = 0x0000006F224DD960
m_activeIndexDatasetList = 0x0000006F224DD970 m_pDbccContext = 0x0000000000000000
m_pAllocFileLimit = 0x0000000000000000 m_dekInstanceIndex = 0x-1
m_pImbiContext = 0x0000000000000000
SEParams @0x0000006F224DDC60
----------------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x0000006F224E8040
m_execStats = 0x0000006F31C456E0
October 11, 2017 at 12:46 pm
Is there a MSDTC (Distributed Transaction Coordinator) running on the new SQL Server? Check to make sure it is allowing XA transactions:
Better info here: https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions
October 11, 2017 at 2:30 pm
The module name is in the dump:
Exception Address = 00007FFBF335B128 Module(SQLJDBC_XA+000000000000B128)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
Doesn't necessarily mean it's not SQL Server but I would probably start looking at the Java error being thrown. There are some similar errors posted on the JBoss developer forums. That might be a good place to start. For example, this has the same errors:
Transaction is not active with @create annotation
But I don't know anything about Java other than the coffee one so I have no idea which ones would apply in your case. I did notice that thread I posted has a few people mentioning addressing the error by changing the transaction attribute.
Sue
October 12, 2017 at 5:16 am
crow1969 - Wednesday, October 11, 2017 12:46 PMIs there a MSDTC (Distributed Transaction Coordinator) running on the new SQL Server? Check to make sure it is allowing XA transactions:Better info here: https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions
The DBA's tell me they have check on this and that it is running and configured for XA. Was my first thought as well.
October 12, 2017 at 5:21 am
Sue_H - Wednesday, October 11, 2017 2:30 PMThe module name is in the dump:
Exception Address = 00007FFBF335B128 Module(SQLJDBC_XA+000000000000B128)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
Doesn't necessarily mean it's not SQL Server but I would probably start looking at the Java error being thrown. There are some similar errors posted on the JBoss developer forums. That might be a good place to start. For example, this has the same errors:
Transaction is not active with @create annotationBut I don't know anything about Java other than the coffee one so I have no idea which ones would apply in your case. I did notice that thread I posted has a few people mentioning addressing the error by changing the transaction attribute.
Sue
Hmm missed that thread. I do have the "TransactionAttributeType.REQUIRES_NEW" but I'll poke in the jboss forums some more. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply