Monday, March 12, 2012

Failed Assertion?

When going through my logs this morning I found this curious error. Anybody
know what I've got going here? Currently running SQL 2000 sp3a.
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0063.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:37 spid 55
*
*
*
* Input Buffer 48 bytes -
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00000037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A84A840: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A84A824: 0A84B044 0087C41F BCA77230 0A84B1A8 0A84B417 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A84A7F8: BCA77558 00000000 BCA77230 0A84A840 BCA77000 0A84A7F8
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 00404829 Module(sqlservr+00004829)
(XdesRMReadOnly::~XdesRMReadOnly+00000075)
* 0040479D Module(sqlservr+0000479D) (ReadOnlyXactImp::Rollback+0000009B)
* 00404490 Module(sqlservr+00004490) (AutoReadOnlyXact::Rollback+0000000E)
* 00404551 Module(sqlservr+00004551) (CSysScan::VRelease+00000069)
* 0045D0B0 Module(sqlservr+0005D0B0) (CObject::FResolveName+0000052D)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:43.50 spid55 Stack Signature for the dump is 0xC84ECD88
2004-12-06 06:50:43.61 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
2004-12-06 06:50:43.61 spid55 Error: 3624, Severity: 20, State: 1.
2004-12-06 06:50:43.66 spid55 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0064.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:43 spid 55
*
*
*
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00060037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A848F8C: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A848F70: 0A849790 0087C41F BCA77230 0A8498F4 0A849B63 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A848F44: BCA77558 00000000 BCA77230 0A848F8C BCA77000 0A848F44
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 004437D8 Module(sqlservr+000437D8) (dec_dbopen+0000000D)
* 0044377F Module(sqlservr+0004377F) (closedb+00000069)
* 004438BD Module(sqlservr+000438BD) (CAutoDb::SafeClose+00000027)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:45.08 spid55 Stack Signature for the dump is 0xC2291C8B
2004-12-06 06:50:45.10 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
"Mike Johnson" <mj@.microsoft.com> wrote in message
news:upbtGP62EHA.1400@.TK2MSFTNGP11.phx.gbl...
> When going through my logs this morning I found this curious error.
Anybody
> know what I've got going here? Currently running SQL 2000 sp3a.
Sounds liek you've hit a bug. An assertion shouldn't show up in production
code.
Contact MS Server support.

No comments:

Post a Comment