none
attempt to fetch logical page (4:16277272) in database 5 failed . it belongs to allocation unit 720586415830784 to 72058643040436224 RRS feed

  • Question

  • One of our application was not responding and we restarted the server, since then our search feature is not working on the application and we are seeing the following error messages in our sql server logs

    attempt to fetch logical page (4:16277272) in database 5 failed . it belongs to allocation unit 720586415830784 to 72058643040436224

    i tried all the links and restore is not an option please need help.

    Thanks

    <form action="https://www.google.com/search" class="tsf nj" data-submitfalse="q" id="tsf" method="GET" name="f" role="search" style="background:none;width:1109px;">
    <input aria-autocomplete="both" aria-haspopup="false" aria-label="Search" autocapitalize="off" autocomplete="off" autocorrect="off" class="gLFyf gsfi" data-ved="0ahUKEwjvqpH_-bLmAhVDHqwKHSdWB3YQ39UDCAk" jsaction="paste:puy29d" maxlength="2048" name="q" role="combobox" spellcheck="false" style="font-size:16px;line-height:34px;font-family:arial, sans-serif;background-color:transparent;border-width:initial;border-style:none;margin:-37px 0px 0px;padding-padding-bottom:0px;color:rgba(0, 0, 0, 0.87);overflow-wrap:break-word;outline:none;display:flex;flex:1 1 100%;-webkit-tap-highlight-color:transparent;height:34px !important;" title="Search" type="text" value="attempt to fetch logical page (4:16277272) in database 5 failed . it belongs to allocation unit 720586415830784 to 72058643040436224" />
    <svg focusable="false" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path d="M19 6.41L17.59 5 12 10.59 6.41 5 5 6.41 10.59 12 5 17.59 6.41 19 12 13.41 17.59 19 19 17.59 13.41 12z"></path></svg>
    <button aria-label="Google Search" class="Tg7LZd" data-ved="0ahUKEwjvqpH_-bLmAhVDHqwKHSdWB3YQ4dUDCAs" jsname="Tg7LZd" style="border-radius:0px 8px 0px 0px;height:44px;width:44px;background-image:initial;background-background-size:initial;background-repeat:initial;background-attachment:initial;background-origin:initial;background-clip:initial;border-width:initial;border-style:none;border-color:initial;cursor:pointer;flex:0 0 auto;padding:0px 13px 0px 0px;" type="submit">
    <svg focusable="false" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path d="M15.5 14h-.79l-.28-.27A6.471 6.471 0 0 0 16 9.5 6.5 6.5 0 1 0 9.5 16c1.61 0 3.09-.59 4.23-1.57l.27.28v.79l5 4.99L20.49 19l-4.99-5zm-6 0C7.01 14 5 11.99 5 9.5S7.01 5 9.5 5 14 7.01 14 9.5 11.99 14 9.5 14z"></path></svg>
    </button>
    • attempt to fetch logical page in database failed
    • dbcc page
    • dbcc checkdb
    • dbcc checktable
    • repair_allow_data_loss
    • dbcc checkdb repair
    • dbcc ind
    • tde dbcc page
    </form>
    <form action="https://www.google.com/search" class="tsf nj" data-submitfalse="q" id="tsf" method="GET" name="f" role="search" style="background:none;width:1109px;">
    <input aria-autocomplete="both" aria-haspopup="false" aria-label="Search" autocapitalize="off" autocomplete="off" autocorrect="off" class="gLFyf gsfi" data-ved="0ahUKEwjvqpH_-bLmAhVDHqwKHSdWB3YQ39UDCAk" jsaction="paste:puy29d" maxlength="2048" name="q" role="combobox" spellcheck="false" style="font-size:16px;line-height:34px;font-family:arial, sans-serif;background-color:transparent;border-width:initial;border-style:none;margin:-37px 0px 0px;padding-padding-bottom:0px;color:rgba(0, 0, 0, 0.87);overflow-wrap:break-word;outline:none;display:flex;flex:1 1 100%;-webkit-tap-highlight-color:transparent;height:34px !important;" title="Search" type="text" value="attempt to fetch logical page (4:16277272) in database 5 failed . it belongs to allocation unit 720586415830784 to 72058643040436224" />
    <svg focusable="false" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path d="M19 6.41L17.59 5 12 10.59 6.41 5 5 6.41 10.59 12 5 17.59 6.41 19 12 13.41 17.59 19 19 17.59 13.41 12z"></path></svg>
    <button aria-label="Google Search" class="Tg7LZd" data-ved="0ahUKEwjvqpH_-bLmAhVDHqwKHSdWB3YQ4dUDCAs" jsname="Tg7LZd" style="border-radius:0px 8px 0px 0px;height:44px;width:44px;background-image:initial;background-background-size:initial;background-repeat:initial;background-attachment:initial;background-origin:initial;background-clip:initial;border-width:initial;border-style:none;border-color:initial;cursor:pointer;flex:0 0 auto;padding:0px 13px 0px 0px;" type="submit">
    <svg focusable="false" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path d="M15.5 14h-.79l-.28-.27A6.471 6.471 0 0 0 16 9.5 6.5 6.5 0 1 0 9.5 16c1.61 0 3.09-.59 4.23-1.57l.27.28v.79l5 4.99L20.49 19l-4.99-5zm-6 0C7.01 14 5 11.99 5 9.5S7.01 5 9.5 5 14 7.01 14 9.5 11.99 14 9.5 14z"></path></svg>
    </button>
    • attempt to fetch logical page in database failed
    • dbcc page
    • dbcc checkdb
    • dbcc checktable
    • repair_allow_data_loss
    • dbcc checkdb repair
    • dbcc ind
    • tde dbcc page
    </form>
    Friday, December 13, 2019 4:45 PM

All replies

  • Please follow below steps may helps .

    >> Ran the DBCC CheckDB against database Id 5.

    >> From above results identify the page numbers which all are corrupted .

    >> Identify those pages belongs to which table using DBCC PAGE ( DBCCPAGE allows us to investigate what’s stored on disk on those specific pages.)

    >> Once you Identify the table, Generate the script for that table with schema alone.

    >> Create afresh table from above generated schema.

    >> export the data from corrupted table to newly created table using BCP commands.

    >> Create indexes on newly create table if required.

    >> Drop the corrupted table. and use the newly created table.


    Please click "Mark as Answer" if it solved your issue and/or "Vote as helpful" if it helped. This can be beneficial to other community members reading this thread.

    Friday, December 13, 2019 5:20 PM
  • Your database file is corrupt.  This is almost always a result of external file corruption.   I have not seen a problem in SQL Server corrupting disk files since SQL 2005 SP3.  The first thing to do is make sure your disk is working correctly.

    Your data file is in an invalid state and likely you have lost data.  What did you have lost depends on the amount of corruption.  If the page is a non-clustered index page, you may be able to rebuild the index and fix the issue.  However, it is much more likely your data is corrupt.  Your best bet is to restore (even though you said this is not an option).


    Friday, December 13, 2019 5:54 PM
    Answerer
  • Thanks Suman and Tom will try each of the method and will post here.
    Friday, December 13, 2019 8:50 PM