January 15, 2013 at 10:06 am
Our weekly integrity check job on one of our servers has now failed two weeks in a row. In both cases, the only database known to be generating an error is the 'master' db.
If I run the DBCC CHECKDB('master') command manually, I get the same results. The log shows no errors, and that the DB is A-OK. The output to the console of the command indicates the same. However, instead of the final line about errors reported by DBCC (as you see here, when I run the command against msdb):
CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I get Msg 0:
CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Naturally, as it appears the results that should be discarded are the ones that say the DB is fine, I'm in a bit of a quandary.
The database has not been restarted since I first saw the error; I'll be requesting one today.
The databases on the server all seem to be behaving normally.
Our external DBA team has recommended updating the server (SQL 2008, SP2, version 10.00.4279) to SP2 cumulative update 7, as that is supposed to fix a situation where you get this message running DBCC CHECKDB on a DB/table with a spatial index. While I don't mind updating (I'd actually have them go to SP3, CU3), this looks like a "hail Mary" play to me.
So:
1. Is it likely that I actually have a corrupt DB?
2. Noting that we'd install the CU on two other servers that have no symptoms before we'd get to the production box that does - does it seem at all likely that SP2CU7 (or SP3CU3) will actually fix the problem?
3. Is there something else I should be looking at/checking on?
Thanks in advance for your advice.
R David Francis
January 16, 2013 at 2:54 am
What is the full output from DBCC CHECKDB .... ALL_ERRORMSGS, NO_INFOMSGS
January 16, 2013 at 4:11 am
Curious if SQL had problems writing to the error log. Can you cycle the error log and try again?
EXEC sp_cycle_errorlog
Joie Andrew
"Since 1982"
January 16, 2013 at 4:33 am
CHECKDB on master also runs CHECKDB on the resource database, not sure if the errors are coming from that rather than master.
I get errors from running CHECKDB on a restored copy of master attached as a user db on another server, but that's error 8906.
January 18, 2013 at 3:53 pm
The full and complete output of [font="Courier New"]DBCC CHECKDB('master') WITH all_errormsgs, no_infomsgs[/font] is, excitingly enough:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
R David Francis
January 18, 2013 at 3:56 pm
Our regular job recycled the error log last night; the output in the previous message was generated 5 minutes ago.
The SQL Server log just shows this:
[font="Courier New"]DBCC CHECKDB (master) WITH all_errormsgs, no_infomsgs executed by Us\DFrancis found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 4 seconds. Internal database snapshot has split point LSN = 00000989:000000d8:0002 and first LSN = 00000989:000000d0:0001.[/font]
[edited to improve formatting]
R David Francis
January 21, 2013 at 1:45 am
This was removed by the editor as SPAM
January 21, 2013 at 1:45 am
This was removed by the editor as SPAM
January 23, 2013 at 10:01 am
I'm pretty sure that I've already got any fix from SQL 2005 SP2 CU6 (released on 2008-02-18) in my SQL 2008 SP2 (released 2010-09-24). Thanks anyway...
R David Francis
January 23, 2013 at 10:11 am
So, an update. We did get the server restarted over the weekend. In fact, we also got a disk drive replaced and the OS rebuilt. One supposes that sort of thing could have an impact on this. Following all this, our weekly Integrity Check job completed without errors, and explicitly running DBCC CHECKDB('master') runs as expected, and doesn't tell me to throw out my results.
Hopefully, that resolves my issue. Thanks all for your assistance!
R David Francis
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply