SQL Server Performance Forum – Threads Archive

SQL Server Assertion Failed

Hi I found these logs on my SQL2K Logs (sp3a) 1. Using ‘dbghelp.dll’ version ‘4.0.5’ *Dump thread – spid = 81, PSS = 0x5340d1f8, EC = 0x5340d520 *Stack Dump being sent to h

rogram filesmicrosoft sql serverMSSQL$SQLDM2000logSQLDump0008.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 11/04/03 09:34:11 spid 81 * * * * Input Buffer 174 bytes - * UPDATE pjDL_KEY_INS_BPT_08 SET flag =’1′ WHERE alcon =’96257802374′ AND * dty =’G100′ * * * MODULE BASE END SIZE * sqlservr 00400000 00B2CFFF 0072d000 * ntdll 77F80000 77FF9FFF 0007a000 * KERNEL32 77E80000 77F30FFF 000b1000 * ADVAPI32 77DB0000 77E0AFFF 0005b000 * RPCRT4 77D30000 77D9DFFF 0006e000 * USER32 77E10000 77E6EFFF 0005f000 * GDI32 77F40000 77F78FFF 00039000 * OPENDS60 41060000 41065FFF 00006000 * MSVCRT 78000000 78045FFF 00046000 * 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 77C10000 77C6CFFF 0005d000 * NETAPI32 02780000 027CEFFF 0004f000 * Secur32 027D0000 027DEFFF 0000f000 * NETRAP 027E0000 027E5FFF 00006000 * SAMLIB 027F0000 027FFFFF 00010000 * WS2_32 02800000 02812FFF 00013000 * WS2HELP 02820000 02827FFF 00008000 * WLDAP32 02830000 02857FFF 00028000 * DNSAPI 02860000 02883FFF 00024000 * WSOCK32 02890000 02897FFF 00008000 * ole32 02C00000 02CEBFFF 000ec000 * XOLEHLP 02CF0000 02CF7FFF 00008000 * MSDTCPRX 02D00000 02DB2FFF 000b3000 * MTXCLU 02DC0000 02DCFFFF 00010000 * VERSION 02DD0000 02DD6FFF 00007000 * LZ32 02DE0000 02DE5FFF 00006000 * mswsock 02DF0000 02E01FFF 00012000 * msafd 02E50000 02E6CFFF 0001d000 * wshtcpip 02EB0000 02EB6FFF 00007000 * rnr20 02EC0000 02ECBFFF 0000c000 * iphlpapi 02F10000 02F22FFF 00013000 * ICMP 02F30000 02F34FFF 00005000 * MPRAPI 02F40000 02F56FFF 00017000 * OLEAUT32 02F60000 02FFAFFF 0009b000 * ACTIVEDS 03000000 0302DFFF 0002e000 * ADSLDPC 03030000 03051FFF 00022000 * RTUTILS 03060000 0306DFFF 0000e000 * SETUPAPI 03070000 030FCFFF 0008d000 * RASAPI32 03100000 03131FFF 00032000 * RASMAN 03140000 03150FFF 00011000 * TAPI32 03160000 03181FFF 00022000 * COMCTL32 03190000 03218FFF 00089000 * SHLWAPI 03220000 03267FFF 00048000 * DHCPCSVC 03270000 03288FFF 00019000 * winrnr 03730000 03737FFF 00008000 * msv1_0 037C0000 037DDFFF 0001e000 * CRYPT32 037E0000 03855FFF 00076000 * MSASN1 03860000 0386FFFF 00010000 * rasadhlp 03870000 03874FFF 00005000 * SSNETLIB 04060000 04074FFF 00015000 * SSNMPN70 04080000 04085FFF 00006000 * security 043C0000 043C3FFF 00004000 * shell32 043D0000 04613FFF 00244000 * SSmsLPCn 04AA0000 04AA6FFF 00007000 * ntdsapi 04B40000 04B50FFF 00011000 * kerberos 04B70000 04BA2FFF 00033000 * cryptdll 04BB0000 04BBDFFF 0000e000 * rsabase 05310000 05331FFF 00022000 * CLBCATQ 05F00000 05F84FFF 00085000 * sqloledb 05FA0000 06012FFF 00073000 * MSDART 06020000 0603EFFF 0001f000 * comdlg32 06040000 0607CFFF 0003d000 * MSDATL3 06080000 06094FFF 00015000 * oledb32 06420000 06485FFF 00066000 * OLEDB32R 06490000 0649FFFF 00010000 * COMSVCS 064B0000 06618FFF 00169000 * TxfAux 06620000 06682FFF 00063000 * SQLOLEDB 06810000 0681EFFF 0000f000 * DBNETLIB 06820000 0682EFFF 0000f000 * SQLFTQRY 06AE0000 06B11FFF 00032000 * xpsqlbot 06B30000 06B35FFF 00006000 * xpstar 06F40000 06F86FFF 00047000 * SQLRESLD 06F90000 06F96FFF 00007000 * SQLSVC 06FA0000 06FB6FFF 00017000 * ODBC32 06FC0000 06FF0FFF 00031000 * odbcbcp 07000000 07005FFF 00006000 * W95SCM 07010000 0701BFFF 0000c000 * SQLUNIRL 10000000 1002CFFF 0002d000 * WINSPOOL 07020000 0703DFFF 0001e000 * MPR 07040000 0704FFFF 00010000 * SHFOLDER 07050000 07057FFF 00008000 * odbcint 071A0000 071B5FFF 00016000 * NDDEAPI 071C0000 071C6FFF 00007000 * SQLSVC 071D0000 071D5FFF 00006000 * xpstar 071E0000 071E8FFF 00009000 * dbghelp 0C330000 0C3E4FFF 000b5000 * * Edi: 5340D520: 5340D1F8 0B78CA00 0B78C7D0 55AC30D8 0B78D470 55DEE030 * Esi: 00000000: * Eax: 00000000: * Ebx: 5340D1F8: 00000051 00000000 009717C9 00009427 00000000 00000000 * Ecx: 0541A6C4: 00000000 0001003F 00000000 00000000 00000000 00000000 * Edx: FFFFFFFF: * Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B * Ebp: 0541A6A8: 0541AEC8 0087C41F 5340D1F8 0541B02C 0541B28F 78025744 * SegCs: 0000001B: * EFlags: 0001024 6: 00730079 00650074 0033006D 003B0032 003A0043 0057005C * Esp: 0541A67C: 5340D520 00000000 5340D1F8 0541A6C4 5340D000 0541A67C * 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) * 0081187D Module(sqlservr+0041187D) (Scan_rid::GetLogicalRid+00000023) * 00813667 Module(sqlservr+00413667) (RowNotFound+0000001E) * 00809307 Module(sqlservr+00409307) (DeleteSargKeysFromIndex+000000FC) * 00437B92 Module(sqlservr+00037B92) (ncdelete+0000022C) * 0042850F Module(sqlservr+0002850F) (DeleteNonClusteredEntries+0000002C) * 00497B8C Module(sqlservr+00097B8C) (SDES::HeapUpdateRow+000000F1) * 00418297 Module(sqlservr+00018297) (SDES::UpdateRow+00000023) * 0042B2C7 Module(sqlservr+0002B2C7) (RowsetSS:<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />etData+0000042B) * 0040E036 Module(sqlservr+0000E036) (CValRow:<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />etDataX+00000035) * 0040AE83 Module(sqlservr+0000AE83) (SetDataWithPop+0000001C) * 0041C5EA Module(sqlservr+0001C5EA) (CEs::GeneralEval4+00000091) * 004865B9 Module(sqlservr+000865B9) (CQScanUpdate::GetRow+00000107) * 0040DEE3 Module(sqlservr+0000DEE3) (CQueryScan::GetRow+00000014) * 0041D68F Module(sqlservr+0001D68F) (CStmtQuery::ErsqExecuteQuery+00000399) * 0041E09C Module(sqlservr+0001E09C) (CStmtDML:<img src=’/community/emoticons/emotion-12.gif’ alt=’:X’ />retExecuteNormal+000002AE) * 0041DECA Module(sqlservr+0001DECA) (CStmtDML:<img src=’/community/emoticons/emotion-12.gif’ alt=’:X’ />retExecute+0000001C) * 0041B442 Module(sqlservr+0001B442) (CMsqlExecContext::ExecuteStmts+000003B9) * 0041AA88 Module(sqlservr+0001AA8<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> (CMsqlExecContext::Execute+000001B6) * 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357) * 0048BB4C Module(sqlservr+0008BB4C) (CStmtPrepQuery:<img src=’/community/emoticons/emotion-12.gif’ alt=’:X’ />retExecute+00000200) * 0041B442 Module(sqlservr+0001B442) (CMsqlExecContext::ExecuteStmts+000003B9) * 0041AA88 Module(sqlservr+0001AA8<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> (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+0000469<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> (ThreadStartRoutine+0000009<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> * 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE) * 77E8B2D8 Module(KERNEL32+0000B2D<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> (lstrcmpiW+000000B7) * ——————————————————————————- Followed by 2. Stack Signature for the dump is 0x6FD45DAD 3. SQL Server Assertion: File: <scanrid.cpp>, line=321 Failed Assertion = ‘m_len != 0’. 4. Error: 3624, Severity: 20, State: 1. Is there anyone know what did cause this error, and how should i fix this problem thanx in advance best regards,

Looks like an internal SQL Server error. I guess nothing you can do yourself.
Keep this up and call Microsoft support. Frank
http://www.insidesql.de
http://www.familienzirkus.de

Check this similar threadhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2039 for any information that might help. And it helps to convey at what time this assertion failure caused on SQL? HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>