Skip to Content
author's profile photo Former Member
Former Member

SQL error - Corrupted datapage

Hello all!

I have a problem with a MaxDB 7.6.00.35 database running on 32bit Windows Server 2003 SP2.

The datebase can't go "online", but can only go to the "admin" state. Is there anything I can do to fix the corrupted datapages so that I don't need to restore my backup (it's old..)

This is the error messages I get:

-24988 SQL error [db_online -f] -9022,System error: BD Corrupted datapage

ERR

-24988,ERR_SQL: SQL error

-9022,System error: BD Corrupted datapage

3,Database state: OFFLINE

6,Internal errorcode, Errorcode 9163 "corrupted_datapage"

20026,PAM::GetPage: Data page is not assigned.

6,bd13GetNode, Errorcode 9163 "corrupted_datapage"

20066,HistDir: registered files 50, max used are 50

2009-01-28 12:41:10 --- Starting GMT 2009-01-28 11:41:10 7.6.00 Build 035-123-139-084

2009-01-28 12:41:48 0x1C8 ERR 20032 IOMan Wrong data page on data volume 9 blockno 15339

2009-01-28 12:41:48 0x1C8 ERR 20033 IOMan + Wrong data page - Requested pageno 74441 (perm) read pageno 7778263

2009-01-28 12:41:50 0x1C8 ERR 20032 IOMan Wrong data page on data volume 9 blockno 15339

2009-01-28 12:41:50 0x1C8 ERR 20033 IOMan + Wrong data page - Requested pageno 74441 (perm) read pageno 7778263

2009-01-28 12:41:52 0x1C8 ERR 20032 IOMan Wrong data page on data volume 9 blockno 15339

2009-01-28 12:41:52 0x1C8 ERR 20033 IOMan + Wrong data page - Requested pageno 74441 (perm) read pageno 7778263

2009-01-28 12:41:54 0x1C8 ERR 20010 Data Corrupted data page 74441 belongs to root 74441 which is of filetype 'History'

2009-01-28 12:41:54 0x1C8 ERR 51080 SYSERROR -9022 BD Corrupted datapage

2009-01-28 12:41:54 0x1C8 ERR 3 Admin Database state: OFFLINE

2009-01-28 12:41:54 0x1C8 ERR 6 KernelCo + Internal errorcode, Errorcode 9163 "corrupted_datapage"

2009-01-28 12:41:54 0x1C8 ERR 20026 Data + PAM::GetPage: Data page is not assigned.

2009-01-28 12:41:54 0x1C8 ERR 6 KernelCo + bd13GetNode, Errorcode 9163 "corrupted_datapage"

2009-01-28 12:41:54 0x1C8 ERR 20066 Log + HistDir: registered files 50, max used are 50

2009-01-28 12:41:54 0x1C8 ERR 20017 Admin + RestartFilesystem failed with 'System error: BD Corrupted datapage'

2009-01-28 12:41:54 0xB0 ERR 7 Messages Begin of dump of registered messages

2009-01-28 12:41:54 0xB0 ERR 10 Messages abort dump of registered messages

2009-01-28 12:41:54 0xB0 ERR 8 Messages End of the message list registry dump

2009-01-28 12:41:58 ___ Stopping GMT 2009-01-28 11:41:58 7.6.00 Build 035-123-139-084

--

Best regards,

Peter Bak

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 28, 2009 at 01:37 PM

    > -24988 SQL error [db_online -f] -9022,System error: BD Corrupted datapage

    Your database has corrupt pages --> destroyed! I hope you have a backup.

    What happened prior to that problem?

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello!

      Well, I restored my old backup, but the system haven't been used for a long time, so there was only a few things missing in the backup.

      I belive that the error occured after the SAN where the database is located shut down due to a power failuere, and didn't mange to write it's cache to the disks.

      Thanks for the answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.