|
Home > Archive > microsoft.public.sqlserver.server > August 2002 > SQL 2000 SP2 (hotfixed) - query causes exception bug DBCC CHECKTABLE/CHECKDB show clean
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2000 SP2 (hotfixed) - query causes exception bug DBCC CHECKTABLE/CHECKDB show clean
|
|
| Mark A. Nadig 2002-08-14, 4:23 pm |
| A customer sent in a backup reporting of a problem. After restoring I
was able to narrow the problem down to a single record out of 50K. The
following query causes an exception (also following). DBCC CHECKDB and
DBCC CHECKTABLE ('bmtrecm') both report 0 errors. All searches on
KB/newgroups seem to indicate this is due to corruption. However, I'm
concerned DBCC doesn't detect it. If I simply drop all indexes and
even the PK constraint so there's 0 indexes, query still fails, so
it's not a bad index. If I alter the table via EM ( so that it scripts
CREATE TABLE ... EXEC INSERT ... DROP TABLE), the data appears fixed,
query works.
SELECT *
FROM bmtrecm
WHERE (BMTRECM_ID = 5722)
ORDER BY BMTRECM_ID DESC
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 56, PSS = 0x1ab811f0, EC = 0x1ab81500
*Stack Dump being sent to d:\MSSQL\log\SQL00001.dmp
*
******************************
******************************
*******************
*
* BEGIN STACK DUMP:
* 08/14/02 14:58:57 spid 56
*
*
*
* Input Buffer 144 bytes -
* SELECT * FROM bmtrecm WHERE (BMTRECM_ID < 5800) ORDER BY BMTRECM_ID
DESC
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B19FFF 0071a000
* ntdll 77F80000 77FFAFFF 0007b000
* KERNEL32 77E80000 77F34FFF 000b5000
* ADVAPI32 77DB0000 77E0BFFF 0005c000
* RPCRT4 77D40000 77DACFFF 0006d000
* USER32 77E10000 77E73FFF 00064000
* GDI32 77F40000 77F7BFFF 0003c000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78045FFF 00046000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 75170000 751BEFFF 0004f000
* SECUR32 77BE0000 77BEEFFF 0000f000
* NETRAP 751C0000 751C5FFF 00006000
* SAMLIB 75150000 7515FFFF 00010000
* WS2_32 75030000 75042FFF 00013000
* WS2HELP 75020000 75027FFF 00008000
* WLDAP32 77950000 77979FFF 0002a000
* DNSAPI 77980000 779A3FFF 00024000
* WSOCK32 75050000 75057FFF 00008000
* wmi 76110000 76113FFF 00004000
* ole32 77A50000 77B39FFF 000ea000
* XOLEHLP 65450000 65457FFF 00008000
* MSDTCPRX 699E0000 69A91FFF 000b2000
* MTXCLU 6A7A0000 6A7AFFFF 00010000
* VERSION 77820000 77826FFF 00007000
* LZ32 759B0000 759B5FFF 00006000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 77C10000 77C6DFFF 0005e000
* rnr20 785C0000 785CBFFF 0000c000
* iphlpapi 77340000 77352FFF 00013000
* ICMP 77520000 77524FFF 00005000
* MPRAPI 77320000 77336FFF 00017000
* OLEAUT32 779B0000 77A4AFFF 0009b000
* ACTIVEDS 773B0000 773DDFFF 0002e000
* ADSLDPC 77380000 773A1FFF 00022000
* RTUTILS 77830000 7783DFFF 0000e000
* SETUPAPI 77880000 7790CFFF 0008d000
* RASAPI32 774E0000 77511FFF 00032000
* rasman 774C0000 774D0FFF 00011000
* TAPI32 77530000 77551FFF 00022000
* COMCTL32 71780000 71809FFF 0008a000
* SHLWAPI 70BD0000 70C33FFF 00064000
* DHCPCSVC 77360000 77378FFF 00019000
* CLBCATQ 775A0000 77624FFF 00085000
* winrnr 777E0000 777E7FFF 00008000
* rasadhlp 777F0000 777F4FFF 00005000
* SSNETLIB 42CF0000 42D04FFF 00015000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 75500000 75503FFF 00004000
* msafd 74FD0000 74FEEFFF 0001f000
* wshtcpip 75010000 75016FFF 00007000
* SSmsLPCn 42CD0000 42CD6FFF 00007000
* ntdsapi 77BF0000 77C00FFF 00011000
* rsabase 7CA00000 7CA21FFF 00022000
* CRYPT32 77440000 774B4FFF 00075000
* MSASN1 77430000 7743FFFF 00010000
* msv1_0 782D0000 782EDFFF 0001e000
* SQLFTQRY 41020000 41051FFF 00032000
* sqloledb 75370000 753DDFFF 0006e000
* MSDART 3BCF0000 3BD0EFFF 0001f000
* comdlg32 76B30000 76B6DFFF 0003e000
* SHELL32 782F0000 7852EFFF 0023f000
* MSDATL3 3BD20000 3BD34FFF 00015000
* oledb32 3C040000 3C0A4FFF 00065000
* OLEDB32R 3C0B0000 3C0BFFFF 00010000
* xpsqlbot 42F00000 42F05FFF 00006000
* xpstar 410F0000 41135FFF 00046000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 42C40000 42C56FFF 00017000
* ODBC32 3C280000 3C2B0FFF 00031000
* odbcbcp 3C2C0000 3C2C5FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 41090000 410BCFFF 0002d000
* WINSPOOL 77800000 7781CFFF 0001d000
* SHFOLDER 71A20000 71A27FFF 00008000
* odbcint 3C410000 3C425FFF 00016000
* NDDEAPI 769A0000 769A6FFF 00007000
* SQLSVC 43970000 43975FFF 00006000
* xpstar 439E0000 439E8FFF 00009000
* dbghelp 72A00000 72A2CFFF 0002d000
*
* Edi: 1AB81500: 1AB811F0 1AB89550 1AB890B8 1AB8150C
1AB8150C 1AB8C030
* Esi: 1AB811F0: 00000038 00000000 00F6D0FE 00009268
00000000 00000000
* Eax: 00000000:
* Ebx: 00000670:
* Ecx: 3BCEE038: 00000000 0001003F 00000000 00000000
00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0086CD4C: 4D830088 75FFFFFC 0875FF0C E8E04D8B
0000002D 64F04D8B
* Ebp: 3BCEE01C: 3BCEE940 0086E778 1AB811F0 3BCEEAA4
3BCEED19 78025744
* SegCs: 0000001B:
* EFlags: 00010246: 004C0000 00420049 0043003D 005C003A
00720050 0067006F
* Esp: 3BCEDFF0: 1AB81500 1AB811F0 00000670 3BCEE038
1AB81000 3BCEDFF0
* SegSs: 00000023:
*
******************************
******************************
*******************
*
-------------------------------------------------------------------------------
* Short Stack Dump
* 0086CD4C Module(sqlservr+0046CD4C)
(CStackDump::GetContextAndDump
+0000002E)
* 0086E778 Module(sqlservr+0046E778) (stackTrace+0000021D)
* 00923F7F Module(sqlservr+00523F7F) (utassert_fail+000002E3)
* 00863D39 Module(sqlservr+00463D39) (XdesRMBase::MakeActive+000000
1C)
* 0041602E Module(sqlservr+0001602E) (SDES::BeginUpdate+0000003C)
* 00530411 Module(sqlservr+00130411)
(BlobManager::ForceBeginUpdate
+00000069)
* 00530EF4 Module(sqlservr+00130EF4)
(BlobManager::GetTextPtr+00000
0B8)
* 007E94BF Module(sqlservr+003E94BF)
(LockBytesSS::GetTextPtr+00000
01A)
* 006B4D98 Module(sqlservr+002B4D98)
(TSendRowClass<3,0>::TSendLOB+000000DC)
* 006B29EB Module(sqlservr+002B29EB) (CValOdsRow::SetDataX+0000021B
)
* 0041A2A4 Module(sqlservr+0001A2A4) (SetDataWithPop+0000001C)
* 0041CB90 Module(sqlservr+0001CB90) (CEs::GeneralEval+00000088)
* 00419314 Module(sqlservr+00019314)
(CStmtQuery::ErsqExecuteQuery+
000003D7)
* 00432F55 Module(sqlservr+00032F55)
(CStmtSelect::XretExecute+0000
0229)
* 0040F403 Module(sqlservr+0000F403)
(CMsqlExecContext::ExecuteStmt
s+000002D9)
* 0040EA95 Module(sqlservr+0000EA95)
(CMsqlExecContext::Execute+000
001B6)
* 00410159 Module(sqlservr+00010159) (CSQLSource::Execute+00000331)
* 0053EDBE Module(sqlservr+0013EDBE)
(CStmtPrepQuery::XretExecute+0
0000200)
* 0040F403 Module(sqlservr+0000F403)
(CMsqlExecContext::ExecuteStmt
s+000002D9)
* 0040EA95 Module(sqlservr+0000EA95)
(CMsqlExecContext::Execute+000
001B6)
* 00410159 Module(sqlservr+00010159) (CSQLSource::Execute+00000331)
* 0053C498 Module(sqlservr+0013C498) (language_exec+000003E1)
* 00411099 Module(sqlservr+00011099) (process_commands+000000EC)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
* 77E96523 Module(KERNEL32+00016523) (TlsSetValue+00000115)
* -------------
followed by:
SQL Server Assertion: File: < S:\sql\ntdbms\storeng\include\
xdesimp.h>,
line=255
Failed Assertion = '0'.
followed by;
Error: 3624, Severity: 20, State: 1.
/\/\/
| |
| Andrew J. Kelly 2002-08-14, 6:23 pm |
| Mark,
You should report this to MS PSS. Any time your getting a stack dump and
don't know exactly why it is a good idea to let them sort it out. It sure
sounds like a bug and they will refund your money if it is.
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
"Mark A. Nadig" <mnadig@wind2_spamsuffix.com> wrote in message
news:i7hllu0l9hmpusjsh8tdclhn9
fcslsj34v@4ax.com...
> A customer sent in a backup reporting of a problem. After restoring I
> was able to narrow the problem down to a single record out of 50K. The
> following query causes an exception (also following). DBCC CHECKDB and
> DBCC CHECKTABLE ('bmtrecm') both report 0 errors. All searches on
> KB/newgroups seem to indicate this is due to corruption. However, I'm
> concerned DBCC doesn't detect it. If I simply drop all indexes and
> even the PK constraint so there's 0 indexes, query still fails, so
> it's not a bad index. If I alter the table via EM ( so that it scripts
> CREATE TABLE ... EXEC INSERT ... DROP TABLE), the data appears fixed,
> query works.
>
> SELECT *
> FROM bmtrecm
> WHERE (BMTRECM_ID = 5722)
> ORDER BY BMTRECM_ID DESC
>
> Using 'dbghelp.dll' version '4.0.5'
> *Dump thread - spid = 56, PSS = 0x1ab811f0, EC = 0x1ab81500
> *Stack Dump being sent to d:\MSSQL\log\SQL00001.dmp
> *
>
******************************
******************************
****************
***
> *
> * BEGIN STACK DUMP:
> * 08/14/02 14:58:57 spid 56
> *
> *
> *
> * Input Buffer 144 bytes -
> * SELECT * FROM bmtrecm WHERE (BMTRECM_ID < 5800) ORDER BY BMTRECM_ID
> DESC
> *
> *
> * MODULE BASE END SIZE
> * sqlservr 00400000 00B19FFF 0071a000
> * ntdll 77F80000 77FFAFFF 0007b000
> * KERNEL32 77E80000 77F34FFF 000b5000
> * ADVAPI32 77DB0000 77E0BFFF 0005c000
> * RPCRT4 77D40000 77DACFFF 0006d000
> * USER32 77E10000 77E73FFF 00064000
> * GDI32 77F40000 77F7BFFF 0003c000
> * OPENDS60 41060000 41065FFF 00006000
> * MSVCRT 78000000 78045FFF 00046000
> * UMS 41070000 4107CFFF 0000d000
> * SQLSORT 42AE0000 42B6FFFF 00090000
> * MSVCIRT 780A0000 780B1FFF 00012000
> * sqlevn70 41080000 41086FFF 00007000
> * NETAPI32 75170000 751BEFFF 0004f000
> * SECUR32 77BE0000 77BEEFFF 0000f000
> * NETRAP 751C0000 751C5FFF 00006000
> * SAMLIB 75150000 7515FFFF 00010000
> * WS2_32 75030000 75042FFF 00013000
> * WS2HELP 75020000 75027FFF 00008000
> * WLDAP32 77950000 77979FFF 0002a000
> * DNSAPI 77980000 779A3FFF 00024000
> * WSOCK32 75050000 75057FFF 00008000
> * wmi 76110000 76113FFF 00004000
> * ole32 77A50000 77B39FFF 000ea000
> * XOLEHLP 65450000 65457FFF 00008000
> * MSDTCPRX 699E0000 69A91FFF 000b2000
> * MTXCLU 6A7A0000 6A7AFFFF 00010000
> * VERSION 77820000 77826FFF 00007000
> * LZ32 759B0000 759B5FFF 00006000
> * CLUSAPI 73930000 7393FFFF 00010000
> * RESUTILS 689D0000 689DCFFF 0000d000
> * USERENV 77C10000 77C6DFFF 0005e000
> * rnr20 785C0000 785CBFFF 0000c000
> * iphlpapi 77340000 77352FFF 00013000
> * ICMP 77520000 77524FFF 00005000
> * MPRAPI 77320000 77336FFF 00017000
> * OLEAUT32 779B0000 77A4AFFF 0009b000
> * ACTIVEDS 773B0000 773DDFFF 0002e000
> * ADSLDPC 77380000 773A1FFF 00022000
> * RTUTILS 77830000 7783DFFF 0000e000
> * SETUPAPI 77880000 7790CFFF 0008d000
> * RASAPI32 774E0000 77511FFF 00032000
> * rasman 774C0000 774D0FFF 00011000
> * TAPI32 77530000 77551FFF 00022000
> * COMCTL32 71780000 71809FFF 0008a000
> * SHLWAPI 70BD0000 70C33FFF 00064000
> * DHCPCSVC 77360000 77378FFF 00019000
> * CLBCATQ 775A0000 77624FFF 00085000
> * winrnr 777E0000 777E7FFF 00008000
> * rasadhlp 777F0000 777F4FFF 00005000
> * SSNETLIB 42CF0000 42D04FFF 00015000
> * SSNMPN70 410D0000 410D5FFF 00006000
> * security 75500000 75503FFF 00004000
> * msafd 74FD0000 74FEEFFF 0001f000
> * wshtcpip 75010000 75016FFF 00007000
> * SSmsLPCn 42CD0000 42CD6FFF 00007000
> * ntdsapi 77BF0000 77C00FFF 00011000
> * rsabase 7CA00000 7CA21FFF 00022000
> * CRYPT32 77440000 774B4FFF 00075000
> * MSASN1 77430000 7743FFFF 00010000
> * msv1_0 782D0000 782EDFFF 0001e000
> * SQLFTQRY 41020000 41051FFF 00032000
> * sqloledb 75370000 753DDFFF 0006e000
> * MSDART 3BCF0000 3BD0EFFF 0001f000
> * comdlg32 76B30000 76B6DFFF 0003e000
> * SHELL32 782F0000 7852EFFF 0023f000
> * MSDATL3 3BD20000 3BD34FFF 00015000
> * oledb32 3C040000 3C0A4FFF 00065000
> * OLEDB32R 3C0B0000 3C0BFFFF 00010000
> * xpsqlbot 42F00000 42F05FFF 00006000
> * xpstar 410F0000 41135FFF 00046000
> * SQLRESLD 42AC0000 42AC6FFF 00007000
> * SQLSVC 42C40000 42C56FFF 00017000
> * ODBC32 3C280000 3C2B0FFF 00031000
> * odbcbcp 3C2C0000 3C2C5FFF 00006000
> * W95SCM 41140000 4114BFFF 0000c000
> * SQLUNIRL 41090000 410BCFFF 0002d000
> * WINSPOOL 77800000 7781CFFF 0001d000
> * SHFOLDER 71A20000 71A27FFF 00008000
> * odbcint 3C410000 3C425FFF 00016000
> * NDDEAPI 769A0000 769A6FFF 00007000
> * SQLSVC 43970000 43975FFF 00006000
> * xpstar 439E0000 439E8FFF 00009000
> * dbghelp 72A00000 72A2CFFF 0002d000
> *
> * Edi: 1AB81500: 1AB811F0 1AB89550 1AB890B8 1AB8150C
> 1AB8150C 1AB8C030
> * Esi: 1AB811F0: 00000038 00000000 00F6D0FE 00009268
> 00000000 00000000
> * Eax: 00000000:
> * Ebx: 00000670:
> * Ecx: 3BCEE038: 00000000 0001003F 00000000 00000000
> 00000000 00000000
> * Edx: FFFFFFFF:
> * Eip: 0086CD4C: 4D830088 75FFFFFC 0875FF0C E8E04D8B
> 0000002D 64F04D8B
> * Ebp: 3BCEE01C: 3BCEE940 0086E778 1AB811F0 3BCEEAA4
> 3BCEED19 78025744
> * SegCs: 0000001B:
> * EFlags: 00010246: 004C0000 00420049 0043003D 005C003A
> 00720050 0067006F
> * Esp: 3BCEDFF0: 1AB81500 1AB811F0 00000670 3BCEE038
> 1AB81000 3BCEDFF0
> * SegSs: 00000023:
> *
>
******************************
******************************
****************
***
> *
> --------------------------------------------------------------------------
-----
> * Short Stack Dump
> * 0086CD4C Module(sqlservr+0046CD4C)
> (CStackDump::GetContextAndDump
+0000002E)
> * 0086E778 Module(sqlservr+0046E778) (stackTrace+0000021D)
> * 00923F7F Module(sqlservr+00523F7F) (utassert_fail+000002E3)
> * 00863D39 Module(sqlservr+00463D39) (XdesRMBase::MakeActive+000000
1C)
> * 0041602E Module(sqlservr+0001602E) (SDES::BeginUpdate+0000003C)
> * 00530411 Module(sqlservr+00130411)
> (BlobManager::ForceBeginUpdate
+00000069)
> * 00530EF4 Module(sqlservr+00130EF4)
> (BlobManager::GetTextPtr+00000
0B8)
> * 007E94BF Module(sqlservr+003E94BF)
> (LockBytesSS::GetTextPtr+00000
01A)
> * 006B4D98 Module(sqlservr+002B4D98)
> (TSendRowClass<3,0>::TSendLOB+000000DC)
> * 006B29EB Module(sqlservr+002B29EB) (CValOdsRow::SetDataX+0000021B
)
> * 0041A2A4 Module(sqlservr+0001A2A4) (SetDataWithPop+0000001C)
> * 0041CB90 Module(sqlservr+0001CB90) (CEs::GeneralEval+00000088)
> * 00419314 Module(sqlservr+00019314)
> (CStmtQuery::ErsqExecuteQuery+
000003D7)
> * 00432F55 Module(sqlservr+00032F55)
> (CStmtSelect::XretExecute+0000
0229)
> * 0040F403 Module(sqlservr+0000F403)
> (CMsqlExecContext::ExecuteStmt
s+000002D9)
> * 0040EA95 Module(sqlservr+0000EA95)
> (CMsqlExecContext::Execute+000
001B6)
> * 00410159 Module(sqlservr+00010159) (CSQLSource::Execute+00000331)
> * 0053EDBE Module(sqlservr+0013EDBE)
> (CStmtPrepQuery::XretExecute+0
0000200)
> * 0040F403 Module(sqlservr+0000F403)
> (CMsqlExecContext::ExecuteStmt
s+000002D9)
> * 0040EA95 Module(sqlservr+0000EA95)
> (CMsqlExecContext::Execute+000
001B6)
> * 00410159 Module(sqlservr+00010159) (CSQLSource::Execute+00000331)
> * 0053C498 Module(sqlservr+0013C498) (language_exec+000003E1)
> * 00411099 Module(sqlservr+00011099) (process_commands+000000EC)
> * 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
> * 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
> * 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
> * 77E96523 Module(KERNEL32+00016523) (TlsSetValue+00000115)
> * -------------
>
> followed by:
>
> SQL Server Assertion: File: < S:\sql\ntdbms\storeng\include\
xdesimp.h>,
> line=255
> Failed Assertion = '0'.
>
> followed by;
>
> Error: 3624, Severity: 20, State: 1.
> /\/\/
|
|
|
|
|