Post reply

logical consistency-based I/O error: incorrect checksum

  • September 14, 2012 at 5:04 am

    #267765

    Hi,

    Recently got the following alert

    DESCRIPTION:SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x03c8720b; actual: 0x887d3f27). It occurred during a read of page (1:73824) in database ID 2 at offset 0x000000240c0000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.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.

    Ran DBCC CHECKDB on all databases, no problems reported.

    According to my colleagues no hardware issues are apparent on the server.

    I'm unsure as to what I need to do next (very much a part time, 'accidental' dba)

    Any advice appreciated.

    Thanks

  • September 14, 2012 at 5:13 am

    #1537735

    Did you run checkDB on TempDB?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • September 14, 2012 at 5:15 am

    #1537737

    I did. No errors.

  • September 14, 2012 at 6:12 am

    #1537761

    Probably because the temp table that had the error was dropped before you could run checkDB.

    Still, indicates that there's something not right about the IO subsystem. Check logs, check drivers, etc.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • September 14, 2012 at 6:39 am

    #1537775

    Thanks for your help.

    I'll see what I can find.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply