Hello Brice,
The cited message "-24988 sql error -9026 System error: BD Bad datapage"
is different
from yours "[-9028]: System error: BD Bad file"
^^^^^^^ ^^^^^^^^
so you have a different problem. In your case it's more probably that
one of your indexes is corrupt.
This could be solved in deleting and re-creating indexes.
Perhaps this select helps to find any hint.
Select tablename,indexname,filestate from files where type = 'INDEX' and
filestate <> 'OK'
Kind regards
Uwe
>-----Original Message-----
>From: Ruth, Brice [mailto:[EMAIL PROTECTED]
>Sent: Thursday, March 10, 2005 3:42 PM
>To: Hahn, Uwe; Christof Lehmann; [email protected]
>Subject: RE: Error -24988 sql error -9026 System error: BD Bad datapage
>
>Good morning!
>
>I have run into this problem today as well. A SQL statement
>"DELETE FROM
><table>" resulted in '[-9028]: System error: BD Bad file'. Now, I have
>to admit, I am not as familiar with MaxDB/SAP DB as I am with
>some other
>systems. When I read the instructions below, "You should build a second
>system ...", does this mean I need to re-install MaxDB, or
>just create a
>new instance within my current installation of MaxDB?
You should read the manual concerning backup and restore concepts and
how to check the database system.
You can use your software installation and create a new database
instance out of a complete backup from your current database.
>
>Also, the comment "Your select's do not seam to access this
>page but one
>day they will and then the database will stop." - please clarify. If a
>select tries to access a bad page, will that query fail and return an
>error, or will the entire database instance go down?
The records of a table are stored in (8KB) pages. If a page is detected
is corrupt
>
>Thanks for the excellent product and timely support!
>
>Respectfully,
>Brice Ruth
>
>-----Original Message-----
>From: Hahn, Uwe [mailto:[EMAIL PROTECTED]
>Sent: Thursday, January 13, 2005 10:25 AM
>To: Christof Lehmann; [email protected]
>Subject: RE: Error -24988 sql error -9026 System error: BD Bad datapage
>
>Hello Christoph,
>
>BAD PAGE means that you have corrupted data pages in the system.
>Your select's do not seam to access this page but one day they will and
>then the database will stop.
>
>You should build a second system with an older data backup of your
>original database.
>This second system you should check with "CHECK DATA EXTENDED".
>If no errors occur you can use this older data backup again plus your
>log backups from the original system and build up a shadow system.
>If errors occur you can use the next older complete data backup.
>If you do not have an older correct data backup you have to determine
>the table to which the bad page belongs. You can do this with
>CHECK DATA
>and SEL FROM ROOTS.
>
>Kind regards
>Uwe
>
>
>>-----Original Message-----
>>From: Christof Lehmann [mailto:[EMAIL PROTECTED]
>>Sent: Thursday, January 13, 2005 5:03 PM
>>To: [email protected]
>>Subject: Error -24988 sql error -9026 System error: BD Bad datapage
>>
>>
>>Hello,
>>
>>When I backup the database (incremental or complete), I
>always get the
>>error message
>>-24988 sql error -9026 System error: BD Bad datapage
>>
>>I can stop and start the database. User can connect to the
>database and
>
>>do sql statements (insert,delete,update and select).
>>
>>What do the message mean?
>>What should I do?
>>How can I get a complete backup?
>>Can I repare the database?
>>
>>Thanks for answers
>>
>>
>>Christof Lehmann
>>
>>_______________________________________________________________
>>_________
>>
>>eXPertmedia GmbH
>>
>>
>>Chopinstr. 4
>>0341 960 50 93
>>04103 Leipzig
>>0341 960 50 92
>>
>>
>>
>>
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
