Friday, March 30, 2012

One for the MVP's

Has anyone seen this kind of error.
I have a datawarehouse that I have to load and optomize
each morning before everyone gets in. The last few days
the load has failed due to not being able to update the
statistics on the tables. THey error out and here is what
I ma getting in the log. I have researched and our
networking group had a tech come in and upgrade the
controllers on the cluster where the db resides this
weekend. I believe what I am getting is a controller that
has trouble writing or disks that are not able to talk
well with the controller. DBCC checkDB shows that the
system has errors. Last night I ran a repair_fast on the
database in question but now it is accross all databases.
what do you think and have you had this before? thanks in
advance.
SQL Server Assertion: File: <recbase.cpp>, line=1374
Failed Assertion = 'm_nVars > 0'.If I were you, Id be calling PSS. It could be a bug, a corrupt database..
Whatever being the case, your best bet is getting PSS involved at this time.
Hope you have some good backups..
"Scott Dexter" <anonymous@.discussions.microsoft.com> wrote in message
news:01f901c3c59e$e8204740$a401280a@.phx.gbl...
> Has anyone seen this kind of error.
> I have a datawarehouse that I have to load and optomize
> each morning before everyone gets in. The last few days
> the load has failed due to not being able to update the
> statistics on the tables. THey error out and here is what
> I ma getting in the log. I have researched and our
> networking group had a tech come in and upgrade the
> controllers on the cluster where the db resides this
> weekend. I believe what I am getting is a controller that
> has trouble writing or disks that are not able to talk
> well with the controller. DBCC checkDB shows that the
> system has errors. Last night I ran a repair_fast on the
> database in question but now it is accross all databases.
> what do you think and have you had this before? thanks in
> advance.
>
> SQL Server Assertion: File: <recbase.cpp>, line=1374
> Failed Assertion = 'm_nVars > 0'.|||Doessound like hardware corruption. As Hassan states you can contact MS PSS
if you want to be sure andthey can walk thru the issues with you.
--
Andrew J. Kelly SQL MVP
"Scott Dexter" <anonymous@.discussions.microsoft.com> wrote in message
news:01f901c3c59e$e8204740$a401280a@.phx.gbl...
> Has anyone seen this kind of error.
> I have a datawarehouse that I have to load and optomize
> each morning before everyone gets in. The last few days
> the load has failed due to not being able to update the
> statistics on the tables. THey error out and here is what
> I ma getting in the log. I have researched and our
> networking group had a tech come in and upgrade the
> controllers on the cluster where the db resides this
> weekend. I believe what I am getting is a controller that
> has trouble writing or disks that are not able to talk
> well with the controller. DBCC checkDB shows that the
> system has errors. Last night I ran a repair_fast on the
> database in question but now it is accross all databases.
> what do you think and have you had this before? thanks in
> advance.
>
> SQL Server Assertion: File: <recbase.cpp>, line=1374
> Failed Assertion = 'm_nVars > 0'.sql

No comments:

Post a Comment