473,320 Members | 2,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DBCC and Failed Assertion Errors - HELP!

Hey all -

We are running SQL 2000 with ALL available service packs, etc.
applied. We just built a brand new database server, which has dual
2Ghz XEONs, 2GB memory, and the following disk configuration:

RAID 1 array (2 disks) Operating System Windows Server 2003
RAID 1 array (2 disks) Database Logs
RAID 10 array (4 disks) Database Data

Disks are SATA, with a 3Ware hardware RAID controller. The machine
SCREAMS.

We run 5 databases on this machine. 2 of these are fairly large (by
our standards, anyway). The second largest database (and the busiest
and most important) is consistently generating consistency errors that
bring many important queries down. These are almost ALWAYS in the
form of index corruption on one single table. The corruption does not
normally occur on other tables, although it DOES happen once in a
while - rarely - on one of the other tables), nor does it EVER occur
on any other databases on the server.

The corruption seems to happen right in the neighborhood of midnight
ALMOST every day, give or take a few minutes, but does not seem
directly associated with any of our MANY scheduled database cleanup
tasks (believe me, we've tried desperately to find an association
using SQL profiler). At midnight, our database traffic is fairly low,
so it does not seem associated with a high traffic level.

We are using the FULL recovery model, with log backups every 15
minutes, and full backups daily at 12:15am. However, the corruption
happens consistently BEFORE 12:15, like between 11:50pm and 12:10am.
The most frustrating thing is, the database can go WEEKS without any
corruption at all, and then it'll go 4 or 5 days in a row with this
strange corruption stuff.

************************************************** ***********************
Typical query errors when the corruption exists include:
************************************************** ***********************

SQL Server Assertion: File:
<p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
Server: Msg 3624, Level 20, State 1, Line 7
Location: recbase.cpp:1374
Expression: m_nVars > 0
Connection Broken

************************************************** ***********************

Most of the responses to this type of issue (failed assertions) on the
newgroups appear to point to hardware failures. However, this is
brand new hardware, AND, it seems to us that if this was a hardware
issue, other databases, tables, and indexes would be affected
randomly. Isn't that a valid assumption (that if it was hardware,
particularly the RAID controller, the corruption would not be in such
a predictable place)? What if we moved the physical database files to
another location on the disk? Would/could that help?

If anyone could offer some suggestions as to what may be causing this
corruption, we would be eternally grateful. It is getting to be a
real pain in the A*** to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS
every day or two (it always seems to solve the problem without data
loss, but still...).

Again, thanks in advance for your response.
Sincerely,
Morgan Leppink
ml******@hotmail.com
Jul 20 '05 #1
4 6390
Hi Morgan,

Have you actually checked the event logs and run hardware diagnostics on
your IO system to see if there are hardware problems?

If so and there's no clues there, you should call Product Support to help
you diagnose the problem.

Regards.

--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

"Morgan Leppink" <ml******@hotmail.com> wrote in message
news:80*************************@posting.google.co m...
Hey all -

We are running SQL 2000 with ALL available service packs, etc.
applied. We just built a brand new database server, which has dual
2Ghz XEONs, 2GB memory, and the following disk configuration:

RAID 1 array (2 disks) Operating System Windows Server 2003
RAID 1 array (2 disks) Database Logs
RAID 10 array (4 disks) Database Data

Disks are SATA, with a 3Ware hardware RAID controller. The machine
SCREAMS.

We run 5 databases on this machine. 2 of these are fairly large (by
our standards, anyway). The second largest database (and the busiest
and most important) is consistently generating consistency errors that
bring many important queries down. These are almost ALWAYS in the
form of index corruption on one single table. The corruption does not
normally occur on other tables, although it DOES happen once in a
while - rarely - on one of the other tables), nor does it EVER occur
on any other databases on the server.

The corruption seems to happen right in the neighborhood of midnight
ALMOST every day, give or take a few minutes, but does not seem
directly associated with any of our MANY scheduled database cleanup
tasks (believe me, we've tried desperately to find an association
using SQL profiler). At midnight, our database traffic is fairly low,
so it does not seem associated with a high traffic level.

We are using the FULL recovery model, with log backups every 15
minutes, and full backups daily at 12:15am. However, the corruption
happens consistently BEFORE 12:15, like between 11:50pm and 12:10am.
The most frustrating thing is, the database can go WEEKS without any
corruption at all, and then it'll go 4 or 5 days in a row with this
strange corruption stuff.

************************************************** ***********************
Typical query errors when the corruption exists include:
************************************************** ***********************

SQL Server Assertion: File:
<p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
Server: Msg 3624, Level 20, State 1, Line 7
Location: recbase.cpp:1374
Expression: m_nVars > 0
Connection Broken

************************************************** ***********************

Most of the responses to this type of issue (failed assertions) on the
newgroups appear to point to hardware failures. However, this is
brand new hardware, AND, it seems to us that if this was a hardware
issue, other databases, tables, and indexes would be affected
randomly. Isn't that a valid assumption (that if it was hardware,
particularly the RAID controller, the corruption would not be in such
a predictable place)? What if we moved the physical database files to
another location on the disk? Would/could that help?

If anyone could offer some suggestions as to what may be causing this
corruption, we would be eternally grateful. It is getting to be a
real pain in the A*** to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS
every day or two (it always seems to solve the problem without data
loss, but still...).

Again, thanks in advance for your response.
Sincerely,
Morgan Leppink
ml******@hotmail.com

Jul 20 '05 #2
Paul -

The only information in the event logs is the text of the failed
assertion error itself. I have never seen any OS-reported problems
with the hardware.

I hate to seem stupid, but can you be more specific about what you
mean when you say "hardware diagnostics?" Are you talking about the
simple Windows CheckDisk utility or something more advanced? This is
the first time I've used a hardware RAID controller - is Windows even
capable of checking the hardware-controlled disk array, or do I need
to use a utility provided by the RAID controller manufacturer?

Or would you suggest some sort of third-party utility for "burning in"
the hardware? Would you suspect disk drives, memory, or what? Could
it be ANY of the hradware, or just specific things?

One last question: What's the most effective method for contacting
product support if I need to do so?

Thanks,

Morgan Leppink
"Paul S Randal [MS]" <pr*****@online.microsoft.com> wrote in message news:<40********@news.microsoft.com>...
Hi Morgan,

Have you actually checked the event logs and run hardware diagnostics on
your IO system to see if there are hardware problems?

If so and there's no clues there, you should call Product Support to help
you diagnose the problem.

Regards.

--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

"Morgan Leppink" <ml******@hotmail.com> wrote in message
news:80*************************@posting.google.co m...
Hey all -

We are running SQL 2000 with ALL available service packs, etc.
applied. We just built a brand new database server, which has dual
2Ghz XEONs, 2GB memory, and the following disk configuration:

RAID 1 array (2 disks) Operating System Windows Server 2003
RAID 1 array (2 disks) Database Logs
RAID 10 array (4 disks) Database Data

Disks are SATA, with a 3Ware hardware RAID controller. The machine
SCREAMS.

We run 5 databases on this machine. 2 of these are fairly large (by
our standards, anyway). The second largest database (and the busiest
and most important) is consistently generating consistency errors that
bring many important queries down. These are almost ALWAYS in the
form of index corruption on one single table. The corruption does not
normally occur on other tables, although it DOES happen once in a
while - rarely - on one of the other tables), nor does it EVER occur
on any other databases on the server.

The corruption seems to happen right in the neighborhood of midnight
ALMOST every day, give or take a few minutes, but does not seem
directly associated with any of our MANY scheduled database cleanup
tasks (believe me, we've tried desperately to find an association
using SQL profiler). At midnight, our database traffic is fairly low,
so it does not seem associated with a high traffic level.

We are using the FULL recovery model, with log backups every 15
minutes, and full backups daily at 12:15am. However, the corruption
happens consistently BEFORE 12:15, like between 11:50pm and 12:10am.
The most frustrating thing is, the database can go WEEKS without any
corruption at all, and then it'll go 4 or 5 days in a row with this
strange corruption stuff.

************************************************** ***********************
Typical query errors when the corruption exists include:
************************************************** ***********************

SQL Server Assertion: File:
<p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
Server: Msg 3624, Level 20, State 1, Line 7
Location: recbase.cpp:1374
Expression: m_nVars > 0
Connection Broken

************************************************** ***********************

Most of the responses to this type of issue (failed assertions) on the
newgroups appear to point to hardware failures. However, this is
brand new hardware, AND, it seems to us that if this was a hardware
issue, other databases, tables, and indexes would be affected
randomly. Isn't that a valid assumption (that if it was hardware,
particularly the RAID controller, the corruption would not be in such
a predictable place)? What if we moved the physical database files to
another location on the disk? Would/could that help?

If anyone could offer some suggestions as to what may be causing this
corruption, we would be eternally grateful. It is getting to be a
real pain in the A*** to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS
every day or two (it always seems to solve the problem without data
loss, but still...).

Again, thanks in advance for your response.
Sincerely,
Morgan Leppink
ml******@hotmail.com

Jul 20 '05 #3
I am running a 3ware SATA Raid card also and have been getting consistency
errors randomly also. I have to run repair_allow_data_loss to fix. I wish
I knew the cause. No drive errors. Microsoft can not pin point either. All
they can tell me is that it is most likely hardware related and to move my
database to another server.

Jul 20 '05 #4

"druss" <de**@corp.dslextreme.com> wrote in message
news:6c******************************@localhost.ta lkaboutdatabases.com...
I am running a 3ware SATA Raid card also and have been getting consistency
errors randomly also. I have to run repair_allow_data_loss to fix. I wish
I knew the cause. No drive errors. Microsoft can not pin point either. All
they can tell me is that it is most likely hardware related and to move my
database to another server.
I would suggest they're probably right in this case.


Jul 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: David Schwartz | last post by:
We are having quite a time since moving a large database to a new server (actually built new server, renamed as old to make seamless for users, etc.) Import 104 million row database (5 column)...
1
by: Kapt. Boogschutter | last post by:
Does anyone know Why I'm getting this Error??? Debug Assertion Failed! File: daocore.cpp Line: 42 My code: CDaoDatabase dao; dao.Create("filename");
2
by: Arti Potnis | last post by:
Hi, I have an application with a function "myfunction" that opens a file and writes to it using fprintf. This application runs on a unix (sun solaris 5.8) system. I connect to this application...
7
by: inkexit | last post by:
I'm getting assertion errors when I try to import or export a file using this code. Please help. I don't even know what an assertion error is. #include <iostream> #include <iomanip> #include...
0
by: CjB | last post by:
Good Morning, I am trying to get PHP+Oracle to work on Solaris 8. I have installed Apache with the following: ./configure --enable-module=so When I start apache it works fine. I think build...
5
by: Scarab | last post by:
Hi, When I use dbcc shrinkfile to shrink LOG file, following error occurs: DBCC SHRINKFILE(2) ---------------------------------------------------------------------------- ----------- Cannot...
4
by: Mullai | last post by:
Hi , My program gives an error message like this Debug Assertion Failed! program:................ File: wincore.cpp Line: 958 Please can anyone help me out in this issue. I have to solve...
2
by: bab | last post by:
I ran "dbcc checkdb(MCMSdb) with no_infomsgs" and I get the following: Server: Msg 8946, Level 16, State 12, Line 2 Table error: Allocation page (1:274992) has invalid PFS_PAGE page header values....
1
by: themadme | last post by:
im running code thats using threads, everytime i get this debug assertion failed box poping up. It involves with my stl vector. its saying that vector iterators incompatible. the vector...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.