|Subject||Re: [firebird-support] Corrupted database|
It is a typical corruption usually caused by Firebird abnormal termination due to power outage.
You can fix it with IBSurgeon FirstAID more details at www.ib-aid.com
16 июня 2015 г. 6:50 пользователь "Nagy Szilveszter nagy_szilveszter@... [firebird-support]" <firstname.lastname@example.org> написал:
Hello,one of my firebird databases got corrupt in the last couple of days. It's a pretty big one the FDB file is 8 GB.The error I observed in the applications logfiles. It happens when the users try to run a specific SP. The error message is:# -902 # database file appears corrupt (/data/firebird/vec.fdb) wrong page type page 112600 is of wrong type (expected 5, found 7) At procedure ''SCOR_CANDIDAT'' line: 38, col: 3The 38th line of this SP is an UPDATE command on a huge table.I tried to fetch that table and it shows the same error at line 115904. (I have 125556 records in the table...at least this is what i calculated from ID value of corrupted line subtracted from generator value)I tried to backup the database to see what happens. The same output comes from gbak:gbak: ERROR:database file appears corrupt (/data/firebird/vec.fdb)gbak: ERROR: wrong page typegbak: ERROR: page 112600 is of wrong type (expected 5, found 7)gbak: ERROR:gds_$receive failedgbak:Exiting before completion due to errorsThe FireBird Server version is: firebird-superclassic-184.108.40.206539.0-1.el6.x86_64Running on a 64bit CentOS Linux.Can anyone help me repair it?Thank you,Szilveszter
Posted by: Nagy Szilveszter <nagy_szilveszter@...>