1 Reply Latest reply: Dec 23, 2013 10:23 PM by Winter Zhang RSS

    db_verify fails with bad prev_pgno 0 on overflow page

    785925
    785925 Dec 23, 2013 8:09 PM

      Hello, I have a btree db file that fails with db_verify with the error :

       

      db_verify: BDB0682 Page 193168: bad prev_pgno 0 on overflow page (should be 193167)

      db_verify: BDB0683 Page 193168: overflow item incomplete

       

      db version : 5.3.21

       

      Any clue on what can result in corruption of that sort ?

       

      Thank you

      • 445 Views
      • Tags:
        • 1. Re: db_verify fails with bad prev_pgno 0 on overflow page
          Winter Zhang
          Winter Zhang Dec 23, 2013 10:23 PM (in response to 785925)

          Hi,

           

          Can you tell us how you access the database, and if there is anything unusual happening when you are accessing the database ?

           

          This issue can be caused by the following cases(not a complete list):

          * Concurrent acessses via multi-threads/multi-processes without opening the environment with DB_INIT_LOCK and DB_INIT_TXN, causing the data corrupted.

          * Application quits abnormallly, which means the application quits without a call to DB_ENV->close

          * The environment is a private environment, so the db_verify and your application use different caches.

           

          Regards,

          Winter, Oracle Berkeley DB