SQL Server detected a logical consistency-based I/O error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Data Corruption (SS2K8 / SS2K8 R2) » SQL Server detected a logical...

SQL Server detected a logical consistency-based I/O error

Rate Topic

Display Mode

Topic Options

Author

Message

krishnaprasad14

Posted Wednesday, January 02, 2013 4:04 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 118, Visits: 555

--Error Number 824
DESCRIPTION: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:845407; actual 1:607839). It occurred during a read of page (1:845407) in database ID 46 at offset 0x0000019ccbe000 in file ‘xx.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

--If run this , I am getting below specified error message
DBCC CHECKDB ('DBname') WITH NO_INFOMSGS, ALL_ERRORMSGS

--Error message:
Msg 8946, Level 16, State 12, Line 1
Table error: Allocation page (1:145584) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Msg 8998, Level 16, State 2, Line 1
Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 6 pages from (1:145584) to (1:153671). See other errors for cause.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page (1:145584). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 62916617 and -4.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page (1:145584). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 62916617 and -4.

Can you suggest me to resolve this please….

Can you please let me know if you need any other details….

Thank you in Advance…..
Krishna

Post #1401754

GilaMonster

Posted Wednesday, January 02, 2013 5:11 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:21 AM
Points: 37,734, Visits: 30,002

Please post the full and complete, unedited output of that command (you've left out at least one line, possibly more)

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1401787

krishnaprasad14

Posted Wednesday, January 02, 2013 5:26 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 118, Visits: 555

You are right. Thank you. I miss two lines ..Here is the complete error message...Please let me know if you need any other details........

Msg 8946, Level 16, State 12, Line 1
Table error: Allocation page (1:145584) has invalid PFS_PAGE page header values. Type is 0. Check type, alloc unit ID and page ID on the page.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Msg 8998, Level 16, State 2, Line 1
Page errors on the GAM, SGAM, or PFS pages prevent allocation integrity checks in database ID 46 pages from (1:145584) to (1:153671). See other errors for cause.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page ID (1:145584) contains an incorrect page ID in its page header. The PageId in the page header = (1:70728).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594050707456 (type Unknown), page ID (1:145584) contains an incorrect page ID in its page header. The PageId in the page header = (1:70728).
CHECKDB found 2 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 2 allocation errors and 1 consistency errors in database 'WSS_Content_HeartyLivesV2'.

Thank you,
Krishna

Post #1401791

krishnaprasad14

Posted Wednesday, January 02, 2013 5:26 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 118, Visits: 555

Post #1401792

GilaMonster

Posted Wednesday, January 02, 2013 6:27 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:21 AM
Points: 37,734, Visits: 30,002

Restore from a clean backup, that's not repairable in any way.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1401809

krishnaprasad14

Posted Thursday, January 03, 2013 3:29 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 118, Visits: 555

Hi Gail Shaw,

I did restore from healthy backup and it's fine now...Thank you

--Krishna

Post #1402269

prettsons

Posted Thursday, January 10, 2013 10:11 PM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 99, Visits: 1,036

Please check this article: http://support.microsoft.com/kb/2015756

SQL Database Recovery Expert Smile

Post #1405755

krishnaprasad14

Posted Friday, January 11, 2013 3:03 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 118, Visits: 555

Thank you very much ...

--Krishna

Post #1405850

« Prev Topic | Next Topic »

Permissions