Re: SQL 2000 Assertion recbase.cpp:1378

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 18:34:12 -0500

I agree with Erland. PSS sounds like the right thing to do:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS 

-- 
Andrew J. Kelly
SQL Server MVP
"Erland Sommarskog" <sommar@algonet.se> wrote in message
news:Xns9495A56F37FYazorman@127.0.0.1...
> 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

  • CmdExec job problem
    ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.programming)
  • Re: Error: 16954, Severity: 10, State: 1 and Timeout problem
    ... On this DB are runing lot of threads from different applications. ... Probably, other aplication are locking resources, so the first one need ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Systematically determine DRI problem(s)
    ... "the original designer probably meant to link them via customer_ID" ... Erland Sommarskog wrote: ... >> of effort to find data problem for the given situation, ... > Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Grant access to applications only
    ... but to deny a direct user login e.g. via management studio. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Applying tranaction log to old data file
    ... "Erland Sommarskog" wrote in message ... Should I restore old backup, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)