Hello Alexey

Thanks for useful links

Every time this error occurs we perform backup and restore - it also resets
transaction counters because sweep interval is set to 0.


Regards
Bogdan


-----Original Message-----
From: Alexey Kovjazin [mailto:kovjazinan@...]
Sent: Friday, February 27, 2004 11:15 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Database appears corrupt


Hello, Bogdan!

>We are planning to upgrade to Firebird-1.0.3.972 soon
>still i would like to know why such things continue to happen

As I can see, you have the single error - index is corrupted and one of its
b-tree pages is confused.

Did you perform the gfix/gbak operations to repair your database every time
you see such error?

To know more about corruptions, see these links
Diagnosing and Repairing InterBase Database Corruption
http://ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.PAGES;NAME='ibp_db_co
rr'

Known Causes of Corruption in InterBase Databases
http://delphi.weblogs.com/stories/storyReader$232

Recovery guide "How to recover InterBase/Firebird database"
http://www.ibsurgeon.com/guide.html

Also you can check your database with IBFirstAID Diagnostician for physical
errors.

Sincerely yours,
Alexey Kovjazin
www.ib-aid.com




Yahoo! Groups Links