| Subject | Re: [firebird-support] Corrupt database question |
|---|---|
| Author | Ann Harrison |
| Post date | 2003-11-18T19:08:47Z |
Milan Babuskov wrote:
(expected 7, found 5) are much nicer than the alternative (expected 5,
found 7). Indexes can be ignored and recreated. A data page that's
lost is gone.
Page errors are ordinarily pages that have not been completely allocated and pages that have not been completely released. In either case, the page is not available for reuse, but it doesn't contain any valid data. Record errors are often orphaned back versions which occur on valid pages. They're also benign.
A doubly allocated page is not benign, and that's what the "wrong page type" error indicates.
Regards,
Ann
>Perhaps output of (failed) gbak might help:Page type 7 is an index page. Page type 5 is a data page. Errors like
>
>gbak: writing data for table RUC
>gbak: ERROR: database file appears corrupt ()
>gbak: ERROR: wrong page type
>gbak: ERROR: page 163478 is of wrong type (expected 7, found 5)
>gbak: ERROR: gds_$start_request failed
>gbak: Exiting before completion due to errors
>
(expected 7, found 5) are much nicer than the alternative (expected 5,
found 7). Indexes can be ignored and recreated. A data page that's
lost is gone.
>It was strange to me to have so many page errors, and only one recorderror.
Page errors are ordinarily pages that have not been completely allocated and pages that have not been completely released. In either case, the page is not available for reuse, but it doesn't contain any valid data. Record errors are often orphaned back versions which occur on valid pages. They're also benign.
A doubly allocated page is not benign, and that's what the "wrong page type" error indicates.
Regards,
Ann