Skip to Content
0
Former Member
Jan 28, 2009 at 01:06 PM

SQL error - Corrupted datapage

138 Views

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