Subject Re: [firebird-support] Re: Firebird Database Corruption to Hellen
Author Helen Borrie
At 01:45 PM 5/10/2004 +0000, you wrote:


>Hi, Helen!
>
>Thanks for your help, but with the instructins you sent me, gbak
>doesn't work, it says "end of file..".. something like that. Sorry,
>but the information is returned in Portuguese, my native language,
>as "Final de arquivo alcançado"
>
>Running IBFirstAid Diagnostician, it returns a lot of lines like
>these ones:
>
>05/10/2004 10:36:57 ERROR: Error on pointer page #839: wrong data
>page link over the end of file 4411
>05/10/2004 10:36:57 ERROR: Error on pointer page #839: wrong data
>page link over the end of file 4412
>05/10/2004 10:36:57 ERROR: Error on pointer page #839: wrong data
>page link over the end of file 4413
>
>As I can see, I need to buy IBFirstAid Ambulance to go on..

Hmm, no, I don't think so. It appears you ran out of disk space during a
write; or that you had forced writes off and lost power to the
server. Really, it's an unknown as to what impact the lost links would
have. This is not a happy condition.

What *exact* versions of everything are you using? (server, client, OS, CPU
settings)?


>I can see the pages which are wrong, how do I correct them?

You couldn't correct them. The best you could hope for is to get rid of
pointer page #839, which is pointing to three non-existent pages. But I
have serious fears about the state of your hard disk. It looks like a
problem for Ann Harrison.

>Please, help me.. I need this database working. What do you suggest?
>This database is very small.. a gbk in a zip are just a couple of MB.

If the database is small and exhausted disk space is not the issue, then
the pointer page could be pointing to an area of disk that has been
physically damaged, e.g. by a power surge, or by the disk being in a dying
state.

>You can contact me on msn: giovanibettiol@..., if you want
>to.

I'm part of a group that fixes broken databases as a professional service,
but I'm not the one with the ability to reconstruct/retrieve anything that
exhibits "past end of file" messages. Contact Ann (see
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_contact) for this
kind of task.

./heLen