非常酷的手套 · 华高莱斯丨城市洞察:大都市光环下的德国中小城 ...· 2 月前 · |
踏实的匕首 · 使用命令输出:Exchange 2013 ...· 2 月前 · |
文武双全的松鼠 · 省委书记梁保华为我校唐仲英血液学研究中心揭牌· 2 月前 · |
不拘小节的菠萝 · 如何在Python中获取List中字符串值内 ...· 3 月前 · |
爱热闹的熊猫 · “珍爱和平,共筑中国梦”南京参观活动· 3 月前 · |
Hey all,
Had an instance restart on me yesterday and found a nice little stack dump in my error log at the time it occurred (see below). Also with in this time frame I am seeing thousands of application event viewer errors ... these two over and over and over:
[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 2746; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
[sqsrvres] ODBC sqldriverconnect failed
This is running SQL Server 2000 SP4 in an A/P cluster. Sorry for posting 2000 in a 2005 forum, but this board gets much more traffic and is usually where I hang out while on SSC.
The thing that has me worried is that where it's showing the input buffer, is my weekly stats update maintenance procedure that runs. Now I have been using this proc for several years in different environments, and never once had a problem. All it is doing is an update stats with full scan on each table in all databases. Any insight would be most appreciated.
2009-06-14 04:36:35.32 spid54 SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/14/09 04:36:35 spid 54
*
* Exception Address = 00436E23
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
* Input Buffer 82 bytes -
* EXEC [admin].[dbo].[Weekly_DBMaint_Stats]
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* ntdll 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* ADVAPI32 77F50000 77FEAFFF 0009b000
* RPCRT4 77C50000 77CEEFFF 0009f000
* Secur32 76F50000 76F62FFF 00013000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7C8D0000 7D0CDFFF 007fe000
* msvcrt 77BA0000 77BF9FFF 0005a000
* GDI32 77C00000 77C47FFF 00048000
* USER32 77380000 77410FFF 00091000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* comctl32 77420000 77522FFF 00103000
* sqlevn70 41080000 4108AFFF 0000b000
* CLUSAPI 74DE0000 74DF1FFF 00012000
* ole32 77670000 777A8FFF 00139000
* OLEAUT32 77D00000 77D8AFFF 0008b000
* RESUTILS 74EF0000 74F02FFF 00013000
* USERENV 76920000 769E1FFF 000c2000
* NETAPI32 03740000 03796FFF 00057000
* AUTHZ 037A0000 037B3FFF 00014000
* COMRES 03C50000 03D15FFF 000c6000
* XOLEHLP 03D20000 03D25FFF 00006000
* MSDTCPRX 03D30000 03DA8FFF 00079000
* msvcp60 03DB0000 03E14FFF 00065000
* MTXCLU 03E20000 03E38FFF 00019000
* VERSION 03E40000 03E47FFF 00008000
* WSOCK32 03E50000 03E58FFF 00009000
* WS2_32 03E60000 03E76FFF 00017000
* WS2HELP 03E90000 03E97FFF 00008000
* mswsock 03EF0000 03F30FFF 00041000
* DNSAPI 03F40000 03F69FFF 0002a000
* winrnr 03FB0000 03FB6FFF 00007000
* WLDAP32 03FC0000 03FEDFFF 0002e000
* rasadhlp 04010000 04014FFF 00005000
* hnetcfg 04020000 04079FFF 0005a000
* wshtcpip 040C0000 040C7FFF 00008000
* msv1_0 04160000 04186FFF 00027000
* iphlpapi 04190000 041A9FFF 0001a000
* PSAPI 041B0000 041BAFFF 0000b000
* SSNETLIB 04A10000 04A25FFF 00016000
* NTMARTA 04A80000 04AA0FFF 00021000
* SAMLIB 04AD0000 04ADEFFF 0000f000
* security 04DC0000 04DC3FFF 00004000
* SSmsLPCn 05FF0000 05FF7FFF 00008000
* SSnmPN70 06000000 06006FFF 00007000
* ntdsapi 06110000 06123FFF 00014000
* kerberos 06150000 061A7FFF 00058000
* cryptdll 061B0000 061BBFFF 0000c000
* MSASN1 061C0000 061D1FFF 00012000
* rsaenh 06830000 06864FFF 00035000
* xpsp2res 076C0000 07984FFF 002c5000
* CLBCatQ 05560000 055E2FFF 00083000
* sqloledb 055F0000 05670FFF 00081000
* MSDART 04FF0000 05009FFF 0001a000
* MSDATL3 05010000 05024FFF 00015000
* oledb32 07E90000 07F08FFF 00079000
* OLEDB32R 05030000 05040FFF 00011000
* xpstar 05160000 051ACFFF 0004d000
* SQLRESLD 05120000 0512BFFF 0000c000
* SQLSVC 05130000 0514AFFF 0001b000
* ODBC32 07F10000 07F4CFFF 0003d000
* COMCTL32 07F50000 07FE6FFF 00097000
* comdlg32 08170000 081B8FFF 00049000
* odbcbcp 051B0000 051B5FFF 00006000
* W95SCM 051C0000 051CCFFF 0000d000
* SQLUNIRL 083C0000 083ECFFF 0002d000
* WINSPOOL 083F0000 08416FFF 00027000
* SHFOLDER 051D0000 051D8FFF 00009000
* odbcint 08A60000 08A76FFF 00017000
* NDDEAPI 08D00000 08D07FFF 00008000
* SQLSVC 09010000 09015FFF 00006000
* xpstar 09020000 09028FFF 00009000
* sqlvdi 0A930000 0A93CFFF 0000d000
* SQLFTQRY 0B610000 0B635FFF 00026000
* xpsqlbot 05A00000 05A05FFF 00006000
* xplog70 05A30000 05A3EFFF 0000f000
* xplog70 05A40000 05A44FFF 00005000
* xpsmtp80 0BC80000 0BC9AFFF 0001b000
* tquery 10640000 107B8FFF 00179000
* mssws 04140000 04147FFF 00008000
* msxmlsql 08E10000 08EE1FFF 000d2000
* msxml2 09650000 096FEFFF 000af000
* msxml3 107C0000 108D9FFF 0011a000
* ACTIVEDS 053A0000 053D3FFF 00034000
* adsldpc 05860000 05887FFF 00028000
* credui 05890000 058BDFFF 0002e000
* ATL 058C0000 058D7FFF 00018000
* adsldp 069F0000 06A1DFFF 0002e000
* SXS 127E0000 1289CFFF 000bd000
* sqlmap70 05060000 0508CFFF 0002d000
* MAPI32 04D40000 04D5EFFF 0001f000
* srchadm 05300000 05335FFF 00036000
* athprxy 01080000 01087FFF 00008000
* DBNETLIB 05340000 0535BFFF 0001c000
* crypt32 0AB90000 0AC22FFF 00093000
* dbghelp 0B740000 0B83FFFF 00100000
*
* Edi: 00000000:
* Esi: 80C0A038: 03FE003A 01010000 02010001 03010002 04010003 05010004
* Eax: 00000000:
* Ebx: 86DC79A1: 82400009 00000000 0000001F 00000000 00000000 00000000
* Ecx: 00000000:
* Edx: 80C0A038: 03FE003A 01010000 02010001 03010002 04010003 05010004
* Eip: 00436E23: 8D07B60F 47048644 00027882 097A840F 008B0021 75184538
* Ebp: 115C87A8: 115C87D4 004417B3 80C0A038 00000000 00000000 00000000
* SegCs: 0000001B:
* EFlags: 00010297: 61006300 69007400 6E006F00 44002000 74006100 5C006100
* Esp: 115C8788: 115C88CC 0000907F 00000000 8267C3D3 8267C3F7 115C87C4
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 00436E23 Module(sqlservr+00036E23)
* 004417B3 Module(sqlservr+000417B3)
* 004A8A4F Module(sqlservr+000A8A4F)
* 005C14F2 Module(sqlservr+001C14F2) (SQLExit+000599FB)
* 005C1307 Module(sqlservr+001C1307) (SQLExit+00059810)
* 005C13C9 Module(sqlservr+001C13C9) (SQLExit+000598D2)
* 005C141E Module(sqlservr+001C141E) (SQLExit+00059927)
* 0042C73E Module(sqlservr+0002C73E)
* 0042B57E Module(sqlservr+0002B57E)
* 004194B9 Module(sqlservr+000194B9)
* 004193E4 Module(sqlservr+000193E4)
* 00429EAA Module(sqlservr+00029EAA)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 005C052B Module(sqlservr+001C052B) (SQLExit+00058A34)
* 005C0DEE Module(sqlservr+001C0DEE) (SQLExit+000592F7)
* 005BF8F4 Module(sqlservr+001BF8F4) (SQLExit+00057DFD)
* 0065934E Module(sqlservr+0025934E) (SQLExit+000F1857)
* 00776604 Module(sqlservr+00376604) (SQLExit+0020EB0D)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 00783BFE Module(sqlservr+00383BFE) (SQLExit+0021C107)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 0050BCEF Module(sqlservr+0010BCEF)
* 0050BB13 Module(sqlservr+0010BB13)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 0050BCEF Module(sqlservr+0010BCEF)
* 0050BB13 Module(sqlservr+0010BB13)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 0049C32E Module(sqlservr+0009C32E)
* 0049C46A Module(sqlservr+0009C46A)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E64829 Module(kernel32+00024829) (GetModuleHandleA+000000DF)
* -------------------------------------------------------------------------------
2009-06-14 04:36:44.79 spid54 Stack Signature for the dump is 0x25A95552
Well, isn't this interesting ... the test instance for this environment, also had almost the same error. The crazy thing is that the input buffer is showing my CheckDB proc, which appears to have finished successfully yet the output of my stats job is showing the dump.
Now I'm confused.
2009-06-14 12:00:18.67 spid54 SqlDumpExceptionHandler: Process 5684 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/14/09 12:00:18 spid 54
*
* Exception Address = 005B7F5E (SQLExit + 00050467 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address AF780000
* Input Buffer 86 bytes -
* EXEC [admin].[dbo].[Weekly_DBMaint_CheckDB]
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00CBAFFF 008bb000
* ntdll 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* ADVAPI32 77F50000 77FEAFFF 0009b000
* RPCRT4 77C50000 77CEEFFF 0009f000
* Secur32 76F50000 76F62FFF 00013000
* MSVCP71 7C3A0000 7C41AFFF 0007b000
* MSVCR71 7C340000 7C395FFF 00056000
* opends60 41060000 41065FFF 00006000
* SHELL32 7C8D0000 7D0CDFFF 007fe000
* msvcrt 77BA0000 77BF9FFF 0005a000
* GDI32 77C00000 77C47FFF 00048000
* USER32 77380000 77410FFF 00091000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* sqlsort 42AE0000 42B6FFFF 00090000
* ums 41070000 4107DFFF 0000e000
* comctl32 77420000 77522FFF 00103000
* sqlevn70 41080000 4108AFFF 0000b000
* NETAPI32 02CA0000 02CF6FFF 00057000
* AUTHZ 02D00000 02D13FFF 00014000
* COMRES 02EB0000 02F75FFF 000c6000
* ole32 03100000 03238FFF 00139000
* XOLEHLP 03240000 03245FFF 00006000
* MSDTCPRX 03250000 032C8FFF 00079000
* OLEAUT32 032D0000 0335AFFF 0008b000
* msvcp60 03360000 033C4FFF 00065000
* MTXCLU 033D0000 033E8FFF 00019000
* VERSION 033F0000 033F7FFF 00008000
* WSOCK32 03400000 03408FFF 00009000
* WS2_32 03410000 03426FFF 00017000
* WS2HELP 03430000 03437FFF 00008000
* CLUSAPI 03480000 03491FFF 00012000
* RESUTILS 034A0000 034B2FFF 00013000
* USERENV 034C0000 03581FFF 000c2000
* mswsock 035A0000 035E0FFF 00041000
* DNSAPI 035F0000 03619FFF 0002a000
* winrnr 03660000 03666FFF 00007000
* WLDAP32 03670000 0369DFFF 0002e000
* rasadhlp 036C0000 036C4FFF 00005000
* SSNETLIB 00E50000 00E65FFF 00016000
* NTMARTA 00EA0000 00EC0FFF 00021000
* SAMLIB 03EA0000 03EAEFFF 0000f000
* security 041B0000 041B3FFF 00004000
* hnetcfg 045C0000 04619FFF 0005a000
* wshtcpip 04660000 04667FFF 00008000
* SSmsLPCn 046F0000 046F7FFF 00008000
* SSnmPN70 04700000 04706FFF 00007000
* ntdsapi 04790000 047A3FFF 00014000
* kerberos 047C0000 04817FFF 00058000
* cryptdll 04820000 0482BFFF 0000c000
* MSASN1 04830000 04841FFF 00012000
* msv1_0 04300000 04326FFF 00027000
* iphlpapi 043C0000 043D9FFF 0001a000
* PSAPI 04330000 0433AFFF 0000b000
* SQLFTQRY 043F0000 04415FFF 00026000
* xpsp2res 050E0000 053A4FFF 002c5000
* CLBCatQ 04420000 044A2FFF 00083000
* sqloledb 044D0000 04550FFF 00081000
* MSDART 04560000 04579FFF 0001a000
* MSDATL3 04580000 04594FFF 00015000
* oledb32 05630000 056A8FFF 00079000
* OLEDB32R 045A0000 045B0FFF 00011000
* xpsqlbot 04280000 04285FFF 00006000
* xpstar 042B0000 042FCFFF 0004d000
* SQLRESLD 05730000 0573BFFF 0000c000
* SQLSVC 05740000 0575AFFF 0001b000
* ODBC32 05760000 0579CFFF 0003d000
* COMCTL32 057A0000 05836FFF 00097000
* comdlg32 05840000 05888FFF 00049000
* odbcbcp 05890000 05895FFF 00006000
* W95SCM 058A0000 058ACFFF 0000d000
* SQLUNIRL 058B0000 058DCFFF 0002d000
* WINSPOOL 058E0000 05906FFF 00027000
* SHFOLDER 05910000 05918FFF 00009000
* odbcint 05A70000 05A86FFF 00017000
* NDDEAPI 05BA0000 05BA7FFF 00008000
* SQLSVC 05BB0000 05BB5FFF 00006000
* xpstar 05BC0000 05BC8FFF 00009000
* rsaenh 05CD0000 05D04FFF 00035000
* sqlvdi 05D50000 05D5CFFF 0000d000
* xplog70 05D70000 05D7EFFF 0000f000
* xplog70 06120000 06124FFF 00005000
* tquery 06AE0000 06C58FFF 00179000
* mssws 03ED0000 03ED7FFF 00008000
* dbghelp 063E0000 064DFFFF 00100000
*
* Edi: 216DE244: 5831AB4A 00000000 00000000 00000001 00B3BD6C 00003803
* Esi: 5831AB4A: 00485831 00010006 AF780000 00004EA2 8F8C0000 8F8D5831
* Eax: 00485831: 1EBD6984 D445DD00 00000AB9 109DDD00 8DFFFFFF FFFF38B5
* Ebx: 00000000:
* Ecx: AF780000:
* Edx: 00B3B400: 004248AA 004193F1 008532AE 00853226 00424A93 0049758D
* Eip: 005B7F5E: 85993C8B 571074FF E49FC1E8 83108BFF 505704C4 8B1452FF
* Ebp: 06A5FA40: 06A5FA6C 00497525 216DE244 00000001 216DE068 216DE020
* SegCs: 0000001B:
* EFlags: 00010286: 00530045 004F0053 00530052 0032003D 004F0000 003D0053
* Esp: 06A5FA28: 00000000 216DE244 5831AB4A 00426462 216DE068 00000001
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 005B7F5E Module(sqlservr+001B7F5E) (SQLExit+00050467)
* 00497525 Module(sqlservr+00097525)
* 0044D56B Module(sqlservr+0004D56B)
* 0044BFA3 Module(sqlservr+0004BFA3)
* 006CE2BC Module(sqlservr+002CE2BC) (SQLExit+001667C5)
* 004149D1 Module(sqlservr+000149D1)
* 00A6B361 Module(sqlservr+0066B361) (CDStream::PrintDumpHeader+000AC285)
* 00A604CE Module(sqlservr+006604CE) (CDStream::PrintDumpHeader+000A13F2)
* 00A60B9F Module(sqlservr+00660B9F) (CDStream::PrintDumpHeader+000A1AC3)
* 00A60E4C Module(sqlservr+00660E4C) (CDStream::PrintDumpHeader+000A1D70)
* 00A6127B Module(sqlservr+0066127B) (CDStream::PrintDumpHeader+000A219F)
* 00A4DF6D Module(sqlservr+0064DF6D) (CDStream::PrintDumpHeader+0008EE91)
* 00A26B18 Module(sqlservr+00626B18) (CDStream::PrintDumpHeader+00067A3C)
* 00A514DC Module(sqlservr+006514DC) (CDStream::PrintDumpHeader+00092400)
* 00A92275 Module(sqlservr+00692275) (CDStream::PrintDumpHeader+000D3199)
* 0060ECB0 Module(sqlservr+0020ECB0) (SQLExit+000A71B9)
* 0087BD8E Module(sqlservr+0047BD8E) (GetIMallocForMsxml+0008720E)
* 0087E509 Module(sqlservr+0047E509) (GetIMallocForMsxml+00089989)
* 0055C692 Module(sqlservr+0015C692)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E64829 Module(kernel32+00024829) (GetModuleHandleA+000000DF)
* -------------------------------------------------------------------------------
*Dump thread - spid = 54, PSS = 0x48c8b280, EC = 0x48c8b5b0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0087.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/14/09 12:00:27 spid 54
*
* StackDump ()
*
* Input Buffer 86 bytes -
* EXEC [admin].[dbo].[Weekly_DBMaint_CheckDB]
*
*
* Edi: 00000000:
* Esi: 00000DFC:
* Eax: 4A633FF0: 00000000 00000000 00000000 00000000 7BB46020 00000002
* Ebx: 002A6B18: 41076770 00000000 0000000C 00000000 00F7935C 00000004
* Ecx: FFFFFFFF:
* Edx: 4A632020: 00B3BCB8 00000000 4A632020 00C4E0E8 00000002 00000002
* Eip: 7C8285EC: 24A48DC3 00000000 0024648D 0824548D 55C32ECD A48DEC8B
* Ebp: 07399D38: 002A6B70 41074AEE 00000DFC FFFFFFFF 00000001 05E8F5E0
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 07399CC8: 7C827D0B 77E61D1E 00000DFC 00000001 00000000 77E61C96
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 7C8285EC Module(ntdll+000285EC) (KiFastSystemCallRet+00000000)
* 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)
* 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)
* 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)
* 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)
* 00401261 Module(sqlservr+00001261)
* 0042341D Module(sqlservr+0002341D)
* 0084F786 Module(sqlservr+0044F786) (GetIMallocForMsxml+0005AC06)
* 0084FA99 Module(sqlservr+0044FA99) (GetIMallocForMsxml+0005AF19)
* 00875935 Module(sqlservr+00475935) (GetIMallocForMsxml+00080DB5)
* 0087EA3C Module(sqlservr+0047EA3C) (GetIMallocForMsxml+00089EBC)
* 004193E4 Module(sqlservr+000193E4)
* 004384BB Module(sqlservr+000384BB)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 0060204C Module(sqlservr+0020204C) (SQLExit+0009A555)
* 00602170 Module(sqlservr+00202170) (SQLExit+0009A679)
* 00A246FF Module(sqlservr+006246FF) (CDStream::PrintDumpHeader+00065623)
* 00A4B304 Module(sqlservr+0064B304) (CDStream::PrintDumpHeader+0008C228)
* 00A4E27C Module(sqlservr+0064E27C) (CDStream::PrintDumpHeader+0008F1A0)
* 00A37F06 Module(sqlservr+00637F06) (CDStream::PrintDumpHeader+00078E2A)
* 0077F994 Module(sqlservr+0037F994) (SQLExit+00217E9D)
* 007804FE Module(sqlservr+003804FE) (SQLExit+00218A07)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 00783BFE Module(sqlservr+00383BFE) (SQLExit+0021C107)
* 00786825 Module(sqlservr+00386825) (SQLExit+0021ED2E)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 00783BFE Module(sqlservr+00383BFE) (SQLExit+0021C107)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 0050BCEF Module(sqlservr+0010BCEF)
* 0050BB13 Module(sqlservr+0010BB13)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 0050BCEF Module(sqlservr+0010BCEF)
* 0050BB13 Module(sqlservr+0010BB13)
* 00415D04 Module(sqlservr+00015D04)
* 00416214 Module(sqlservr+00016214)
* 00415F28 Module(sqlservr+00015F28)
* 0049C32E Module(sqlservr+0009C32E)
* 0049C46A Module(sqlservr+0009C46A)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E64829 Module(kernel32+00024829) (GetModuleHandleA+000000DF)
* -------------------------------------------------------------------------------
*Dump thread - spid = 54, PSS = 0x48c8b280, EC = 0x48c540c0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0087.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/14/09 12:00:29 spid 54
*
* StackDump ()
*
* Input Buffer 86 bytes -
* EXEC [admin].[dbo].[Weekly_DBMaint_CheckDB]
*
*
* Edi: 48C540C0: 48C8B280 48C540C4 48C540C4 48C54618 48C54618 48C54038
* Esi: 48C8B280: 00000036 00000000 00C5C4AA 00009C28 00000000 00000000
* Eax: 00000000:
* Ebx: 06A5EF38: 001076A0 48C86640 06A5EF70 00408EF4 00001920 00000088
* Ecx: 06A5E030: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: 0011AA90: 00000000 48C8B280 48C540C0 00000001 0003000B 000D00D6
* Eip: 009BA08C: 26EB0088 90909090 EC458B90 83E47D8B B3B904C7 8B000000
* Ebp: 06A5DFB4: 06A5E7F4 009BA9B5 48C8B280 00BCD818 48C540C0 0000020B
* SegCs: 0000001B:
* EFlags: 00010246: 004E005F 005F004F 004F0048 00540053 0043005F 00450048
* Esp: 06A5DF8C: 48C540C0 48C8B280 06A5EF38 06A5E030 06A5DF8C 06A5DBB8
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 009BA08C Module(sqlservr+005BA08C) (GetOSErrString+00004F68)
* 009BA9B5 Module(sqlservr+005BA9B5) (GetOSErrString+00005891)
* 00A59EA2 Module(sqlservr+00659EA2) (CDStream::PrintDumpHeader+0009ADC6)
* 009B9F56 Module(sqlservr+005B9F56) (GetOSErrString+00004E32)
* 009BA259 Module(sqlservr+005BA259) (GetOSErrString+00005135)
* 00A9A049 Module(sqlservr+0069A049) (CDStream::PrintDumpHeader+000DAF6D)
* 7C359C97 Module(MSVCR71+00019C97) (_CxxLongjmpUnwind+000000EA)
* 7C359629 Module(MSVCR71+00019629) (_CxxExceptionFilter+000001C4)
* 7C3598AD Module(MSVCR71+000198AD) (_CxxExceptionFilter+00000448)
* 7C35994A Module(MSVCR71+0001994A) (_CxxExceptionFilter+000004E5)
* 7C359B9D Module(MSVCR71+00019B9D) (_CxxFrameHandler+00000026)
* 7C828752 Module(ntdll+00028752) (RtlRaiseStatus+000000E0)
* 7C828723 Module(ntdll+00028723) (RtlRaiseStatus+000000B1)
* 7C82855E Module(ntdll+0002855E) (KiUserExceptionDispatcher+0000000E)
* 00497525 Module(sqlservr+00097525)
* 0044D56B Module(sqlservr+0004D56B)
* 0044BFA3 Module(sqlservr+0004BFA3)
* 006CE2BC Module(sqlservr+002CE2BC) (SQLExit+001667C5)
* 004149D1 Module(sqlservr+000149D1)
* 00A6B361 Module(sqlservr+0066B361) (CDStream::PrintDumpHeader+000AC285)
* 00A604CE Module(sqlservr+006604CE) (CDStream::PrintDumpHeader+000A13F2)
* 00A60B9F Module(sqlservr+00660B9F) (CDStream::PrintDumpHeader+000A1AC3)
* 00A60E4C Module(sqlservr+00660E4C) (CDStream::PrintDumpHeader+000A1D70)
* 00A6127B Module(sqlservr+0066127B) (CDStream::PrintDumpHeader+000A219F)
* 00A4DF6D Module(sqlservr+0064DF6D) (CDStream::PrintDumpHeader+0008EE91)
* 00A26B18 Module(sqlservr+00626B18) (CDStream::PrintDumpHeader+00067A3C)
* 00A514DC Module(sqlservr+006514DC) (CDStream::PrintDumpHeader+00092400)
* 00A92275 Module(sqlservr+00692275) (CDStream::PrintDumpHeader+000D3199)
* 0060ECB0 Module(sqlservr+0020ECB0) (SQLExit+000A71B9)
* 0087BD8E Module(sqlservr+0047BD8E) (GetIMallocForMsxml+0008720E)
* 0087E509 Module(sqlservr+0047E509) (GetIMallocForMsxml+00089989)
* 0055C692 Module(sqlservr+0015C692)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E64829 Module(kernel32+00024829) (GetModuleHandleA+000000DF)
* -------------------------------------------------------------------------------
*Dump thread - spid = 54, PSS = 0x48c8b280, EC = 0x473d20c0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0087.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/14/09 12:00:30 spid 54
*
* StackDump ()
*
* Input Buffer 86 bytes -
* EXEC [admin].[dbo].[Weekly_DBMaint_CheckDB]
*
*
* Edi: 00000000:
* Esi: 000009B4:
* Eax: 20BCEA08: 000EF002 000EF002 F0020F06 F008000E 0F06000E 000EF002
* Ebx: 002A6B18: 41076770 00000000 0000000C 00000000 00F7935C 00000004
* Ecx: 00000002:
* Edx: 0729F0E4: 0003FFF5 4A541258 0729FCB0 00B337B0 FFFFFFFF 0729F124
* Eip: 7C8285EC: 24A48DC3 00000000 0024648D 0824548D 55C32ECD A48DEC8B
* Ebp: 0729FAC0: 002A6B70 41074AEE 000009B4 FFFFFFFF 00000001 05E8EF98
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 0729FA50: 7C827D0B 77E61D1E 000009B4 00000001 00000000 77E61C96
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 7C8285EC Module(ntdll+000285EC) (KiFastSystemCallRet+00000000)
* 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)
* 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)
* 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)
* 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)
* 00401261 Module(sqlservr+00001261)
* 00408B31 Module(sqlservr+00008B31)
* 004024E7 Module(sqlservr+000024E7)
* 00A4DF37 Module(sqlservr+0064DF37) (CDStream::PrintDumpHeader+0008EE5B)
* 00A26B18 Module(sqlservr+00626B18) (CDStream::PrintDumpHeader+00067A3C)
* 00A514DC Module(sqlservr+006514DC) (CDStream::PrintDumpHeader+00092400)
* 00A92275 Module(sqlservr+00692275) (CDStream::PrintDumpHeader+000D3199)
* 0060ECB0 Module(sqlservr+0020ECB0) (SQLExit+000A71B9)
* 0087BD8E Module(sqlservr+0047BD8E) (GetIMallocForMsxml+0008720E)
* 0087E509 Module(sqlservr+0047E509) (GetIMallocForMsxml+00089989)
* 0055C692 Module(sqlservr+0015C692)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E64829 Module(kernel32+00024829) (GetModuleHandleA+000000DF)
* -------------------------------------------------------------------------------
*Dump thread - spid = 54, PSS = 0x48c8b280, EC = 0x4a6b20c0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0087.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/14/09 12:00:31 spid 54
*
* StackDump ()
*
* Input Buffer 86 bytes -
* EXEC [admin].[dbo].[Weekly_DBMaint_CheckDB]
*
*
* Edi: 00000000:
* Esi: 000008E0:
* Eax: 00000000:
* Ebx: 002A6D20: 41076770 00000001 0000000C 00F814FC 00F814FC 00000000
* Ecx: 00000000:
* Edx: 490465C8: 00000000 00000000 00000000 00000000 00000000 00000000
* Eip: 7C8285EC: 24A48DC3 00000000 0024648D 0824548D 55C32ECD A48DEC8B
* Ebp: 063DFB88: 002A6D78 41074AEE 000008E0 FFFFFFFF 00000001 05E8D618
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 063DFB18: 7C827D0B 77E61D1E 000008E0 00000001 00000000 77E61C96
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 7C8285EC Module(ntdll+000285EC) (KiFastSystemCallRet+00000000)
* 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)
* 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)
* 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)
* 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)
* 00401261 Module(sqlservr+00001261)
* 0042341D Module(sqlservr+0002341D)
* 0087F0C2 Module(sqlservr+0047F0C2) (GetIMallocForMsxml+0008A542)
* 0087F5D3 Module(sqlservr+0047F5D3) (GetIMallocForMsxml+0008AA53)
* 008814E2 Module(sqlservr+004814E2) (GetIMallocForMsxml+0008C962)
* 0087B18B Module(sqlservr+0047B18B) (GetIMallocForMsxml+0008660B)
* 005B820A Module(sqlservr+001B820A) (SQLExit+00050713)
* 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F)
* 0041D396 Module(sqlservr+0001D396)
* 0042B550 Module(sqlservr+0002B550)
* 0041D396 Module(sqlservr+0001D396)
* 0087B9BB Module(sqlservr+0047B9BB) (GetIMallocForMsxml+00086E3B)
* 0087E509 Module(sqlservr+0047E509) (GetIMallocForMsxml+00089989)
* 0055C692 Module(sqlservr+0015C692)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E64829 Module(kernel32+00024829) (GetModuleHandleA+000000DF)
* -------------------------------------------------------------------------------
*Dump thread - spid = 54, PSS = 0x48c8b280, EC = 0x4a5f40c0
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0087.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/14/09 12:00:31 spid 54
*
* StackDump ()
*
* Input Buffer 86 bytes -
* EXEC [admin].[dbo].[Weekly_DBMaint_CheckDB]
*
*
* Edi: 00000000:
* Esi: 0000094C:
* Eax: 0000001F:
* Ebx: 002A6B18: 41076770 00000000 0000000C 00000000 00F7935C 00000004
* Ecx: 00000001:
* Edx: 00000002:
* Eip: 7C8285EC: 24A48DC3 00000000 0024648D 0824548D 55C32ECD A48DEC8B
* Ebp: 0731FB88: 002A6B70 41074AEE 0000094C FFFFFFFF 00000001 05E8D688
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 0731FB18: 7C827D0B 77E61D1E 0000094C 00000001 00000000 77E61C96
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 7C8285EC Module(ntdll+000285EC) (KiFastSystemCallRet+00000000)
* 41074AEE Module(ums+00004AEE) (UmsThreadScheduler::Switch+0000004E Line 490+0000000A)
* 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D)
* 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000)
* 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000)
* 00401261 Module(sqlservr+00001261)
* 0042341D Module(sqlservr+0002341D)
* 0087F0C2 Module(sqlservr+0047F0C2) (GetIMallocForMsxml+0008A542)
* 0087F5D3 Module(sqlservr+0047F5D3) (GetIMallocForMsxml+0008AA53)
* 008814E2 Module(sqlservr+004814E2) (GetIMallocForMsxml+0008C962)
* 0087B18B Module(sqlservr+0047B18B) (GetIMallocForMsxml+0008660B)
* 005B820A Module(sqlservr+001B820A) (SQLExit+00050713)
* 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F)
* 0041D396 Module(sqlservr+0001D396)
* 0042B550 Module(sqlservr+0002B550)
* 0041D396 Module(sqlservr+0001D396)
* 0087B9BB Module(sqlservr+0047B9BB) (GetIMallocForMsxml+00086E3B)
* 0087E509 Module(sqlservr+0047E509) (GetIMallocForMsxml+00089989)
* 0055C692 Module(sqlservr+0015C692)
* 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000)
* 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007)
* 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA)
* 77E64829 Module(kernel32+00024829) (GetModuleHandleA+000000DF)
* -------------------------------------------------------------------------------
2009-06-14 12:00:39.08 spid54 Stack Signature for the dump is 0x99180370
Ha, even worse ... the dev environment too. No other instances in this environment except for those which are for our intranet. The dev environment has it worse as I currently can not connect to it (time out expired) and I'm seeing this over and over:
2009-06-15 08:43:34.93 server Error: 17883, Severity: 1, State: 0
2009-06-15 08:43:34.93 server Process 87:0 (d7c) UMS Context 0x0569EF00 appears to be non-yielding on Scheduler 1.
I remember seeing this years ago at a previous job and I had to obtain a hotfix to resolve it. Doing some searching now ...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
文武双全的松鼠 · 省委书记梁保华为我校唐仲英血液学研究中心揭牌 2 月前 |
不拘小节的菠萝 · 如何在Python中获取List中字符串值内的特定字符串_如何在python中创建list内的list_查找位于List Python中特定字符串之间的字符串 - 腾讯云开发者社区 - 腾讯云 3 月前 |
爱热闹的熊猫 · “珍爱和平,共筑中国梦”南京参观活动 3 月前 |