SQL Server 2017的Linked Server配置触发的bug“Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION”
程序员文章站
2022-05-14 12:09:36
SQL Server 2017的Linked Server配置触发的bug“Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION” 现象描述： 数据库版本：SQL Server 2017 (RTM-CU14) (KB4484710) - 14.0.... ......
sql server 2017的linked server配置触发的bug“exception code = c0000005 exception_access_violation”
现象描述：
数据库版本：sql server 2017 (rtm-cu14) (kb4484710) - 14.0.3076.1 (x64) 出现大量的dump file文件，如下所示：
其中一个sqldump748.txt如下所示：
current time is 05:00:20 05/17/19.
=====================================================================
bugcheck dump
=====================================================================
this file is generated by microsoft sql server
version 14.0.3076.1
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) gold 6148 cpu @ 2.40ghz.
bios version is intel - 6040000
phoenixbios 4.0 release 6.0
8 x64 level 8664, 2 mhz processor (s).
windows nt 6.2 build 9200 csd .
memory
memoryload = 92%
total physical = 131071 mb
available physical = 10157 mb
total page file = 262143 mb
available page file = 135435 mb
total virtual = 134217727 mb
available virtual = 133928023 mb
***stack dump being sent to c:\program files\microsoft sql server\mssql14.mssqlserver\mssql\log\sqldump7265.txt
sqldumpexceptionhandler: process 59 generated fatal exception c0000005 exception_access_violation. sql server is
terminating this process.
* *******************************************************************************
*
* begin stack dump:
* 05/17/19 05:00:20 spid 59
*
*
* exception address = 000001df83dbc4ac module(oranls11+000000000004c4ac)
* exception code = c0000005 exception_access_violation
* access violation occurred writing address 00000000e7df2e60
* input buffer 140 bytes -
* exec [dbo].[usp_sdautouploadpriceanddeliverydatetoescm_new]
*
*
* module base end size
* sqlservr 00007ff6c47c0000 00007ff6c483efff 0007f000
* ntdll 00007ffe18480000 00007ffe1864ffff 001d0000
* kernel32 00007ffe16bc0000 00007ffe16c6bfff 000ac000
* kernelbase 00007ffe15340000 00007ffe1555cfff 0021d000
* sysfer 000000006e400000 000000006e494fff 00095000
* advapi32 00007ffe16d10000 00007ffe16db1fff 000a2000
* msvcrt 00007ffe165d0000 00007ffe1666dfff 0009e000
* sechost 00007ffe182d0000 00007ffe18328fff 00059000
* rpcrt4 00007ffe16910000 00007ffe16a30fff 00121000
* ole32 00007ffe15ce0000 00007ffe15e17fff 00138000
* combase 00007ffe15a10000 00007ffe15cd4fff 002c5000
* ucrtbase 00007ffe149e0000 00007ffe14ad3fff 000f4000
* bcryptprimitives 00007ffe14bf0000 00007ffe14c59fff 0006a000
* gdi32 00007ffe16420000 00007ffe16453fff 00034000
* gdi32full 00007ffe15610000 00007ffe15790fff 00181000
* user32 00007ffe15e80000 00007ffe15fe4fff 00165000
* netapi32 00007ffe0c660000 00007ffe0c677fff 00018000
* pdh 00007ffe11390000 00007ffe113dcfff 0004d000
* win32u 00007ffe14970000 00007ffe1498dfff 0001e000
* sqlmin 00007ffe02ec0000 00007ffe060b8fff 031f9000
* sqltses 00007ffe060c0000 00007ffe069eefff 0092f000
* sqllang 00007ffe00740000 00007ffe02ebafff 0277b000
* sqlos 00007ffe06ef0000 00007ffe06ef6fff 00007000
* sqldk 00007ffe069f0000 00007ffe06eebfff 004fc000
* oleaut32 00007ffe16500000 00007ffe165befff 000bf000
* msvcp_win 00007ffe157a0000 00007ffe1583bfff 0009c000
* opends60 00007ffe00730000 00007ffe00738fff 00009000
* qds 00007ffe00600000 00007ffe0072bfff 0012c000
* svl 00007ffe004e0000 00007ffe0050dfff 0002e000
* crypt32 00007ffe15840000 00007ffe15a08fff 001c9000
* msasn1 00007ffe14910000 00007ffe1491ffff 00010000
* ws2_32 00007ffe18350000 00007ffe183b9fff 0006a000
* msvcp120 00007ffe0bdf0000 00007ffe0be95fff 000a6000
* msvcr120 00007ffe0d6b0000 00007ffe0d79efff 000ef000
* winmm 00007ffe12cf0000 00007ffe12d12fff 00023000
* secur32 00007ffe11250000 00007ffe1125bfff 0000c000
* winhttp 00007ffe11280000 00007ffe1134bfff 000cc000
* odbc32 00007ffe00430000 00007ffe004defff 000af000
* secforwarder 00007ffe00510000 00007ffe00519fff 0000a000
* winmmbase 00007ffe12c90000 00007ffe12cbafff 0002b000
* cfgmgr32 00007ffe14990000 00007ffe149d1fff 00042000
* bcrypt 00007ffe14820000 00007ffe1484afff 0002b000
* ncrypt 00007ffe14430000 00007ffe14455fff 00026000
* ntasn1 00007ffe143f0000 00007ffe1442afff 0003b000
* sspicli 00007ffe14550000 00007ffe1457bfff 0002c000
* netutils 00007ffe13f70000 00007ffe13f7cfff 0000d000
* dpapi 00007ffe13b20000 00007ffe13b29fff 0000a000
* samcli 00007ffe11f50000 00007ffe11f68fff 00019000
* wintrust 00007ffe14b90000 00007ffe14be4fff 00055000
* userenv 00007ffe14030000 00007ffe1404efff 0001f000
* authz 00007ffe13bc0000 00007ffe13c09fff 0004a000
* profapi 00007ffe148e0000 00007ffe148f3fff 00014000
* xmllite 00007ffe0c8f0000 00007ffe0c925fff 00036000
* dhcpcsvc 00007ffe11260000 00007ffe11279fff 0001a000
* wininet 00007ffe07d40000 00007ffe08121fff 003e2000
* nsi 00007ffe165c0000 00007ffe165c7fff 00008000
* logoncli 00007ffe12780000 00007ffe127bdfff 0003e000
* psapi 00007ffe18340000 00007ffe18347fff 00008000
* kernel.appcore 00007ffe14900000 00007ffe1490efff 0000f000
* instapi140 00007ffdfd330000 00007ffdfd342fff 00013000
* cryptsp 00007ffe14350000 00007ffe14366fff 00017000
* rsaenh 00007ffe13dc0000 00007ffe13df2fff 00033000
* cryptbase 00007ffe14370000 00007ffe1437afff 0000b000
* imagehlp 00007ffe16a40000 00007ffe16a5bfff 0001c000
* gpapi 00007ffe138d0000 00007ffe138f2fff 00023000
* wkscli 00007ffe10de0000 00007ffe10df5fff 00016000
* cscapi 00007ffdfd350000 00007ffdfd361fff 00012000
* sqlevn70 000001dfeaf90000 000001dfeb29efff 0030f000
* clusapi 00007ffe09ee0000 00007ffe09f98fff 000b9000
* dnsapi 00007ffe13f80000 00007ffe14020fff 000a1000
* iphlpapi 00007ffe13f30000 00007ffe13f67fff 00038000
* resutils 00007ffe0a1b0000 00007ffe0a210fff 00061000
* version 00007ffe0c490000 00007ffe0c499fff 0000a000
* hkruntime 00007ffdfd490000 00007ffdfd760fff 002d1000
* hkcompile 00007ffdfc470000 00007ffdfc5d1fff 00162000
* shlwapi 00007ffe183c0000 00007ffe18411fff 00052000
* hkengine 00007ffdfbc30000 00007ffdfc33afff 0070b000
* dbghelp 000000006d570000 000000006d705fff 00196000
* ncryptprov 00007ffe0d9d0000 00007ffe0da23fff 00054000
* msv1_0 00007ffe14140000 00007ffe141a6fff 00067000
* ntlmshared 00007ffe14130000 00007ffe1413bfff 0000c000
* cryptdll 00007ffe14210000 00007ffe14224fff 00015000
* kerberos 00007ffe14260000 00007ffe1434ffff 000f0000
* schannel 00007ffe13d00000 00007ffe13d77fff 00078000
* security 000002073e580000 000002073e582fff 00003000
* mscoree 00007ffe07b20000 00007ffe07b85fff 00066000
* mscoreei 00007ffe07a80000 00007ffe07b1bfff 0009c000
* sqlserverspatial140 00007ffdfb8f0000 00007ffdfb9a1fff 000b2000
* clbcatq 00007ffe16c70000 00007ffe16d0efff 0009f000
* msxml3 00007ffdfb640000 00007ffdfb86bfff 0022c000
* sqlncli11 00007ffdfb2e0000 00007ffdfb632fff 00353000
* comdlg32 00007ffe16810000 00007ffe16909fff 000fa000
* shcore 00007ffe14ae0000 00007ffe14b88fff 000a9000
* shell32 00007ffe16dc0000 00007ffe182c4fff 01505000
* windows.storage 00007ffe14c60000 00007ffe15338fff 006d9000
* powrprof 00007ffe14920000 00007ffe1496bfff 0004c000
* msvcr100 000000006d490000 000000006d561fff 000d2000
* comctl32 00007ffe07c90000 00007ffe07d3bfff 000ac000
* imm32 00007ffe16460000 00007ffe1648dfff 0002e000
* sqlnclir11 000002073e710000 000002073e747fff 00038000
* netbios 00007ffdfc340000 00007ffdfc34bfff 0000c000
* sqlnclirda11 000000006d130000 000000006d488fff 00359000
* ualapi 00007ffdfb2c0000 00007ffdfb2d9fff 0001a000
* esent 00007ffe094e0000 00007ffe097d1fff 002f2000
* ntmarta 00007ffe13610000 00007ffe13641fff 00032000
* sqlnclirdar11 000002073e810000 000002073e847fff 00038000
* clr 00007ffe06f00000 00007ffe078ecfff 009ed000
* msvcr120_clr0400 00007ffe00270000 00007ffe00366fff 000f7000
* mscorlib.ni 00007ffdfeab0000 00007ffe00040fff 01591000
* sqlaccess 00007ffdfb240000 00007ffdfb2b4fff 00075000
* clrjit 00007ffdfd770000 00007ffdfd89afff 0012b000
* batchparser 00007ffdfac50000 00007ffdfac7bfff 0002c000
* srvcli 00007ffe09e70000 00007ffe09e95fff 00026000
* ftimport 0000000060000000 0000000060024fff 00025000
* msfte 0000000049980000 0000000049d2dfff 003ae000
* mskeyprotect 00007ffdfb870000 00007ffdfb884fff 00015000
* mswsock 00007ffe141b0000 00007ffe1420bfff 0005c000
* ntdsapi 00007ffe0a350000 00007ffe0a378fff 00029000
* dsparse 00007ffe0ee40000 00007ffe0ee4cfff 0000d000
* rasadhlp 00007ffe104b0000 00007ffe104b9fff 0000a000
* fwpuclnt 00007ffe11780000 00007ffe117e9fff 0006a000
* ncryptsslp 00007ffdfb8c0000 00007ffdfb8e0fff 00021000
* xpsqlbot 00007ffe0b930000 00007ffe0b937fff 00008000
* xpstar 00007ffe0b0a0000 00007ffe0b10dfff 0006e000
* sqlscm 00007ffdfb090000 00007ffdfb0a2fff 00013000
* xpstar 0000020923680000 000002092368cfff 0000d000
* cryptnet 00007ffdf7d10000 00007ffdf7d3efff 0002f000
* xplog70 00007ffdfd3a0000 00007ffdfd3b3fff 00014000
* xplog70 000001df80010000 000001df80013fff 00004000
* sort00060101 00007ffdf1030000 00007ffdf1042fff 00013000
* mlang 00007ffdf0d20000 00007ffdf0d5efff 0003f000
* system.data 00007ffdf8e30000 00007ffdf9195fff 00366000
* wldp 00007ffe13b00000 00007ffe13b17fff 00018000
* odsole70 00007ffe08440000 00007ffe08457fff 00018000
* scrrun 00007ffdfc3d0000 00007ffdfc401fff 00032000
* sxs 00007ffe14720000 00007ffe147b7fff 00098000
* oledb32 00007ffdec730000 00007ffdec81cfff 000ed000
* msdart 00007ffe07a50000 00007ffe07a75fff 00026000
* comctl32 00007ffdfb9b0000 00007ffdfbc29fff 0027a000
* msadce 00007ffdef670000 00007ffdef70bfff 0009c000
* msadcer 000001df82cd0000 000001df82cd2fff 00003000
* sqloledb 00007ffde9300000 00007ffde93d6fff 000d7000
* msdatl3 00007ffdfac90000 00007ffdfacb1fff 00022000
* oraoledb11 0000000010000000 000000001008efff 0008f000
* oraoledbgmr11 0000000044100000 0000000044126fff 00027000
* oraoledbrst11 0000000044400000 0000000044434fff 00035000
* oraoledbutl11 0000000044700000 0000000044708fff 00009000
* oci 0000000180000000 00000001800aafff 000ab000
* msvcr80 000000006de00000 000000006dec8fff 000c9000
* oraclient11 000001df838d0000 000001df83d6dfff 0049e000
* oracore11 000001df82de0000 000001df82f3ffff 00160000
* oranls11 000001df83d70000 000001df83e6efff 000ff000
* oraunls11 000001df82da0000 000001df82dbffff 00020000
* oracommon11 000001df83e70000 000001df84126fff 002b7000
* orageneric11 000001df84130000 000001df85030fff 00f01000
* oran11 000001df85040000 000001df85493fff 00454000
* orancrypt11 000001df854a0000 000001df854c3fff 00024000
* oraldapclnt11 000001df854d0000 000001df856c1fff 001f2000
* oranl11 000001df856e0000 000001df8574efff 0006f000
* oranro11 000001df85760000 000001df857bafff 0005b000
* orapls11 000001df857d0000 000001df85cf0fff 00521000
* orasql11 000001df85d10000 000001df85d6dfff 0005e000
* orauts 000001df85d80000 000001df85d86fff 00007000
* orasnls11 000001df85da0000 000001df85ddcfff 0003d000
* oraxml11 000001df85df0000 000001df862cefff 004df000
* oracell11 000001df862e0000 000001df8632afff 0004b000
* orannzsbb11 000001df86340000 000001df864c3fff 00184000
* orahasgen11 000001df864e0000 000001df867b5fff 002d6000
* oraocr11 000001df867d0000 000001df86897fff 000c8000
* orazt11 000001df868b0000 000001df86a9ffff 001f0000
* oranldap11 000001df86ab0000 000001df86afafff 0004b000
* oranhost11 000001df86b10000 000001df86b19fff 0000a000
* orancds11 000001df86b30000 000001df86b36fff 00007000
* orantns11 000001df86b50000 000001df86b60fff 00011000
* oraztkg11 000001df86b80000 000001df86c32fff 000b3000
* wsock32 00007ffe09100000 00007ffe09108fff 00009000
* orantcp11 000001df86c50000 000001df86c84fff 00035000
* oraslax11 000001df86ca0000 000001df86caefff 0000f000
* oravsn11 000001df86cc0000 000001df86cc6fff 00007000
* oraplp11 000001df86ce0000 000001df870d4fff 003f5000
* msvcp80 000000006df80000 000000006e088fff 00109000
* oraocrutl11 000001df870f0000 000001df87100fff 00011000
* oraocrb11 000001df87120000 000001df87213fff 000f4000
* oraplc11 000001df87230000 000001df8724ffff 00020000
* oraoledb11us 0000000044300000 0000000044305fff 00006000
* oraoledbpus11 0000000044200000 0000000044207fff 00008000
* msdaps 00007ffe0b1f0000 00007ffe0b250fff 00061000
* comsvcs 00007ffe0b280000 00007ffe0b41bfff 0019c000
* napinsp 00007ffe0da30000 00007ffe0da45fff 00016000
* winrnr 00007ffe0dca0000 00007ffe0dcadfff 0000e000
* nlaapi 00007ffe11620000 00007ffe11637fff 00018000
* apphelp 00007ffe12c10000 00007ffe12c89fff 0007a000
* dsrole 00007ffe122c0000 00007ffe122c9fff 0000a000
* rasapi32 00007ffdef7c0000 00007ffdef877fff 000b8000
* rasman 00007ffdfb1a0000 00007ffdfb1bffff 00020000
* rtutils 00007ffe0e2b0000 00007ffe0e2c3fff 00014000
* dhcpcsvc6 00007ffe10f10000 00007ffe10f25fff 00016000
* system.ni 00007ffdfda50000 00007ffdfe690fff 00c41000
* system.transactions 00007ffe0d7b0000 00007ffe0d7fefff 0004f000
* system.security.ni 00007ffdfe8b0000 00007ffdfe9a0fff 000f1000
* system.xml.ni 00007ffdf9ae0000 00007ffdfa36bfff 0088c000
* system.core.ni 00007ffdfc8a0000 00007ffdfd2effff 00a50000
* system.configuration.ni 00007ffdf8d00000 00007ffdf8e2afff 0012b000
* comres 000001df88040000 000001df8817dfff 0013e000
* xolehlp 00007ffdf1540000 00007ffdf1556fff 00017000
* msdtcprx 00007ffdfab60000 00007ffdfac41fff 000e2000
* mtxclu 00007ffdfaaf0000 00007ffdfab58fff 00069000
* ktmw32 00007ffe0b090000 00007ffe0b09afff 0000b000
* ondemandconnroutehelper 00007ffe10360000 00007ffe10374fff 00015000
* clrcompression 00007ffe0dc50000 00007ffe0dc73fff 00024000
* samlib 00007ffe0d100000 00007ffe0d122fff 00023000
* xprepl 00007ffe0b1d0000 00007ffe0b1e9fff 0001a000
* dbghelp 000000006ce90000 000000006d025fff 00196000
*
* p1home: 0000000000000000:
* p2home: 0000000000000000:
* p3home: 000000000000000c:
* p4home: 0000000000000000:
* p5home: 0000000000000000:
* p6home: 0000000000000000:
* contextflags: 000000000010005f:
* mxcsr: 0000000000001f80:
* segcs: 0000000000000033:
* segds: 000000000000002b:
* seges: 000000000000002b:
* segfs: 0000000000000053:
* seggs: 000000000000002b:
* segss: 000000000000002b:
* eflags: 0000000000010246:
* rax: 000000000000000c:
* rcx: 0000000000000031:
* rdx: 0000000000000031:
* rbx: 000000000000000c:
* rsp: 00000064ec3f80f0: 0000000000000000 000001dfb38c02a0 0000000000000020 000001dfea290d50 00000226
00000028 000001df8474c4f0
* rbp: 00000000e7df2e60:
* rsi: 000001df8726d7e0: 0b20010003000000 000026d900003085 0000000200000000 0000000000015a00 00000000
00000000 0000000000000000
* rdi: 000001df88630008: 000001df88630018 000001df83e5f120 000001df87265840 0000000000000000 00000000
00000000 000000000000001c
* r8: 00000000e7df2e60:
* r9: 00000225bf9b38c8: 2073776f72203631 000000006c696166 0000000000000000 0000000000000000 00000000
00000000 0000000000000000
* r10: 00000000000000b2:
* r11: 0000000000000001:
* r12: 00000000e7df2e60:
* r13: 00000225bf9b38c8: 2073776f72203631 000000006c696166 0000000000000000 0000000000000000 00000000
00000000 0000000000000000
* r14: 000000000000000c:
* r15: 000000000000000c:
* rip: 000001df83dbc4ac: 01c58349004d8966 35740000fffdf981 75ffc08302c58348 2b4d1e77fe3b45da e82b4928
6f894ce9 c48348e889fdd148
* *******************************************************************************
* -------------------------------------------------------------------------------
* short stack dump
000001df83dbc4ac module(oranls11+000000000004c4ac)
0000000180064570 module(oci+0000000000064570)
000000004440cc35 module(oraoledbrst11+000000000000cc35)
000000004442647b module(oraoledbrst11+000000000002647b)
000000001002f10a module(oraoledb11+000000000002f10a)
00000000100325ca module(oraoledb11+00000000000325ca)
0000000010035c78 module(oraoledb11+0000000000035c78)
00007ffdec7a9262 module(oledb32+0000000000079262)
00007ffdec7aa945 module(oledb32+000000000007a945)
00007ffe016b51dd module(sqllang+0000000000f751dd)
00007ffe0169d838 module(sqllang+0000000000f5d838)
00007ffe016114be module(sqllang+0000000000ed14be)
00007ffe01395a94 module(sqllang+0000000000c55a94)
00007ffe013984c8 module(sqllang+0000000000c584c8)
00007ffe01381ddc module(sqllang+0000000000c41ddc)
00007ffe0137ce68 module(sqllang+0000000000c3ce68)
00007ffe00754e70 module(sqllang+0000000000014e70)
00007ffe00755823 module(sqllang+0000000000015823)
00007ffe00755f24 module(sqllang+0000000000015f24)
00007ffe013802f3 module(sqllang+0000000000c402f3)
00007ffe0137fc90 module(sqllang+0000000000c3fc90)
00007ffe0137ca68 module(sqllang+0000000000c3ca68)
00007ffe00754e70 module(sqllang+0000000000014e70)
00007ffe00755823 module(sqllang+0000000000015823)
00007ffe00755f24 module(sqllang+0000000000015f24)
00007ffe013802f3 module(sqllang+0000000000c402f3)
00007ffe0137fc90 module(sqllang+0000000000c3fc90)
00007ffe0137ca68 module(sqllang+0000000000c3ca68)
00007ffe00754e70 module(sqllang+0000000000014e70)
00007ffe00755823 module(sqllang+0000000000015823)
00007ffe00755f24 module(sqllang+0000000000015f24)
00007ffe0075cb7d module(sqllang+000000000001cb7d)
00007ffe00753b12 module(sqllang+0000000000013b12)
00007ffe00753903 module(sqllang+0000000000013903)
00007ffe069f4dad module(sqldk+0000000000004dad)
00007ffe069f52e8 module(sqldk+00000000000052e8)
00007ffe069f4f5d module(sqldk+0000000000004f5d)
00007ffe06a15818 module(sqldk+0000000000025818)
00007ffe06a15910 module(sqldk+0000000000025910)
00007ffe06a15087 module(sqldk+0000000000025087)
00007ffe06a155d9 module(sqldk+00000000000255d9)
00007ffe16bc84d4 module(kernel32+00000000000084d4)
00007ffe184ee851 module(ntdll+000000000006e851)
csession @0x000001ee926287b0
----------------------------
m_sessionid = 59 m_cref = 18 m_rgcreftype[0] = 1
m_rgcreftype[1] = 1 m_rgcreftype[2] = 15 m_rgcreftype[3] = 1
m_rgcreftype[4] = 0 m_rgcreftype[5] = 0 m_pmo = 0x000001ee92628040
m_pstackbhfpool = 0x000001ec206375f0 m_dwloginflags = 0x100083e0 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 = 72716430 m_eclclient = 7 m_prottype = 6
cuenvtransient @0x000001ee92628c90
----------------------------------
m_ululrowcount = 0 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 = 000001ee92628e8c
cdbandsetopts @0x000001ee92628cb0
---------------------------------
m_fhasdbref = 0 m_fdatefirstset = 0 m_fdateformatset = 0
m_luseropt1 = 0x14016000 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 = 1024
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: a4010000 04000074 00100000 00000007 50300000 ¤......t........p0..
0000000000000014: 00000000 e0830010 20feffff 09040000 5e000800 ....à.. þÿÿ ...^...
0000000000000028: 00000000 00000000 6e004900 00010700 0e010400 ........n.i.........
000000000000003c: 12010400 1a010000 1a010600 005056b4 c19c2601 .............pv´á&.
0000000000000050: 78002601 00000000 00000000 0000 x.&...........
cphysicalconnection @0x000001ee92628400
---------------------------------------
m_pphyconn->m_pmo = 0x000001ee92628040
m_pphyconn->m_pnetconn = 0x000001ee92629070
m_pphyconn->m_pconnlist = 0x000001ee92628780
m_pphyconn->m_psess = 0x000001ee92628808 m_pphyconn->m_ftracked = -1
m_pphyconn->m_cbpacketsize = 4096 m_pphyconn->m_fmars = 0 m_pphyconn->m_fkill = 0
cbatch @0x000001ee92629cb0
--------------------------
m_psess = 0x000001ee926287b0 m_pconn = 0x000001ee926296b0 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 = 0x000001ebb55c84e8
except (null) @0x00000064ec3f4ef8
---------------------------------
exc_number = 0 exc_severity = 0 exc_func = sqldk.dll+0x000000000005d430
task @0x000001ebb55c84e8
------------------------
cpu ticks used (ms) = 20055 task state = 2
waitinfo_internal: waitresource = 0x0000000000000000 waitinfo_internal: waittype = 0x0
waitinfo_internal: waitspinlock = 0x0000000000000000
waitinfo_external: waitresource = 0x0000000000000000 waitinfo_external: waittype = 0x400070
waitinfo_external: waitspinlock = 0x0000000000000000
waitinfo_external: waitresource = 0x0000000000000000
waitinfo_external: waittype = 0x200001d7
waitinfo_external: waitspinlock = 0x0000000000000000
waitinfo_external: waitresource = 0x0000000000000000 waitinfo_external: waittype = 0x4000da
waitinfo_external: waitspinlock = 0x0000000000000000 schedulerid = 0x3
threadid = 0x3620 m_state = 0 m_eabortsev = 0
ec @0x000001ec20637720
----------------------
spid = 0 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x0 ec_atomic = 0x0 ectype = 0
__psetls = 0x000001ee92629720 __pseparams = 0x000001ee92629e60
seinternaltls @0x000001ee92629720
---------------------------------
m_activeheapdatasetlist = 0x000001ee92629b30
m_activeindexdatasetlist = 0x000001ee92629b40 m_flags = 0
m_tlsstatus = 3 m_criticalopdbid = 65535 m_cloudhostdbid = 65535
m_restoringdbid = 65535 m_restoretargetdbid = 0 m_nolockscancount = 0
m_readonlydatabasescan = false m_incatchupredo = false
m_pbulkoplocknotification = 0x0000000000000000 m_pdbcccontext = 0x0000000000000000
m_pcompressioncontext = 0x0000000000000000
m_pretentioncleanupcontext = 0x0000000000000000 m_pallocfilelimit = 0x0000000000000000
m_dekinstanceindex = 0x-1 m_pimbicontext = 0x0000000000000000
m_pnccithreadcontext = 0x0000000000000000
separams @0x000001ee92629e60
----------------------------
m_locktimeout = -1 m_isolevel = 4096 m_logdontreplicate = 0
m_neverreplicate = 0 m_xactworkspace = 0x000001eefa4ee040
m_execstats = 0x000001e4734ebb60
所有的dump文件都指向一个存储过程，而最终发现是sql agent上的一个作业调用这个存储过程。而咨询微软supprt的同事，人家反馈是因为这个存储过程使用了oracle linked server ，而且因为在oraoledb.oracle驱动上勾选了“allow inprocess”选项的缘故，具体邮件如下：
hello xxxxx,
many thanks for the feedback. if this is the case, there is a known issue when running queries through an oracle linked server, which you can find in the following article:
https://support.microsoft.com/en-us/help/2295405/sql-server-service-crashes-when-you-run-an-oracle-linked-server-query
this happens because it is not recommended to have external modules loaded into the sql server memory, as they can cause these types of unexpected behaviors. to try and troubleshoot this issue i propose the following action plan:
- in the ssms, open “server objects” -> “linked servers” -> “providers”
- select the oracledb provider, right click and go to “properties”
- in the “properties” window uncheck the “allow inprocess” option
- reboot the server
this process will remove from the sql server memory those dlls and this should prevent the issue from happening again. let me know if this plan would be possible to execute from your side and, if so, tell me how it went once it is done.
i will be waiting on your feedback, if you have any questions in the meantime feel free to reach out to me.
best regards,
虽然微软的技术支持反馈出现dump文件是因为oraoledb.oracle驱动上勾选了“allow inprocess”选项的缘故，但是他提供的官方文档是sql 2005、2008的相关文档，而不是sql server 2017d的相关文档，而且在ssms里面调用oracle linked server不报错。这个让我有点质疑其答复。后面按照其要求处理后，确实发现sql dump文件消失了。下面是对整个过程的一个复盘：
1： 当初在oraoledb.oracle驱动上勾选了“allow inprocess”选项，是因为开发使用openquery查询时，报错如下错误
其实出现这个错误，是因为启动sql server实例的账号是nt service\mssqlserver， 如果是localsystem等这类账号就不会报这个错误。主要是因为msdainitialize properties的安全设置。
- click start, type dcomcnfg in the search programs and files box, and then press enter.
- expand component services, expand computers, expand my computer, and then click dcom config.
- right-click msdainitialize, and then click properties.
- on the security tab, under launch and activation permissions, click customize, and then click edit.
- add the administrators group or the user account that you want.
如下所示，在安全选项里面使用“customize"里面，加上启动sql server服务（nt service\mssqlserver）或sql server agent服务的账号（nt service\sqlserveragent）的权限，如下所示：
详细步骤参考下面过程
verify below settings in dcomcnfg: start --> run –> dcomcnfg
1. component services -->my computer ---> properties verify that below options are set:
in the 'default properties' tab:
- 'enable distributed com on this computer' is checked.
- default authentication = connect.
- default impersonation level = identify or impersonate.
2. component services --> my computer --> dcom config --> msdainitialize
-right click on msdainitialize --> properties -->security
-add the sql server service account (if connected to sql server using sql login) or windows user account under "launch and activation permissions", "access permissions" and "configuration permissions".
-give full rights to these accounts.
-restart the server
回到之前问题，取消了oraoledb.oracle驱动上的“allow inprocess”选项后，sql dump文件缺失消失了。也就是说这个确实是因为“sql server service crashes when you run an oracle linked server query” 这个缘故导致的。不过在测试过程中，我简单的查询是不会触发这个bug。尚不清楚内部的具体原因，另外，还有就是有些版本勾选了这个选项，也没有触发这个bug。目前只在sql server 2017 (rtm-cu14) (kb4484710) - 14.0.3076.1 (x64) 这个版本中发现了这个问题。
参考资料：
https://support.microsoft.com/en-us/help/2295405/sql-server-service-crashes-when-you-run-an-oracle-linked-server-query
https://support.microsoft.com/en-gb/help/2647989/error-message-when-you-try-to-create-an-instance-of-an-ole-db-provider
上一篇： MySQL之单表查询、多表查询
下一篇： oracle资料库函式库