Re: SQL 2000 Assertion recbase.cpp:1378

From: Erland Sommarskog (sommar_at_algonet.se)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 23:05:21 +0000 (UTC)

Ben Newcomb (anonymous@discussions.microsoft.com) writes:
> 1.
> Using 'dbghelp.dll' version '4.0.5'
> *Dump thread - spid = 98, PSS = 0x5bafb1a8, EC = 0x62d12098
> 2.
> Stack Signature for the dump is 0x5CAE5242
> 3.
> SQL Server Assertion: File: <recbase.cpp>, line=1378
> Failed Assertion = 'm_offBeginVar < m_SizeRec'.
> 4.
> Error: 3624, Severity: 20, State: 1.
>
> Then we started getting this assertion instead of the
> first one:
>
> SQL Server Assertion: File:
><p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
> Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=
> MAXDATAROW'.
>
> We ran DBCC CHECKDB shortly after and it return with 0
> errors.

I found a KB article which included a recbase:1378. However, the article
claimed that the issue had been fixed in SP3. I did not find anything
on record.inl. But I should add that I only search Knowledge Base in
MSDN, so the most recent articles are not there.

You might consider opening a case with Microsoft. Since this is a bug
in SQL Server, you should be refunded for any initial expenses. 

-- 
Erland Sommarskog, SQL Server MVP, sommar@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages

  • Re: create index error
    ... error log for details." ... You need to search your errorlog to find which assertion was fired. ... Microsoft SQL Server Storage Engine ...
    (microsoft.public.sqlserver.server)
  • Received assert dialog from what I thought was a runtime SQL Server Client library
    ... While using the SQL Server Client libraries for accessing a SQL Server 2000 database, I received the following two assertions: ... I don't know why I am receiving assertion dialogs from what I believe is a SQL Server Client runtime library. ... The version of the DB-Library and all network libraries is 8.0.194. ...
    (microsoft.public.sqlserver.clients)
  • An array of errors and the fix...
    ... I am posting this in the hope that Google will spider the post and others ... SQL Server 2000 I started to bring over the SQL Server ... Eventually I discovered using the help of MemTest86+ ... Assertion = 'm_offBeginVar < m_SizeRec'. ...
    (microsoft.public.sqlserver.server)
  • SQL Server SP3: Failed to apply
    ... SQL Server SP3 to a clustered SQL Server 2000 on a ... with two nodes though either administrator or SQL server ...
    (microsoft.public.sqlserver.security)
  • Re: ERROR ON DEBUGGING A STORED PROCEDURE
    ... I think you are on SQL Server SP3 Patch. ... This will update all the client tools to the latest ... "ANDREAMALA" wrote in message ...
    (microsoft.public.sqlserver.programming)