Friday, August 18, 2006

Repair issue

Yesterday we got broken database from some popular (in tight range) commercial system. It is built on InterBase 4.1, and still being sold by developers for wide range of shops. But, sometimes in these shops server power failure happens. In this case damage was increased by old InterBase 4 bug when data in header page is being shiffled. Hopefully, information was not broken, just mixed.
Repair process was a bit tricky, and took about 3 hours. First, database needed to be repaired to work with Firebird 1.5. Second, it was repaired again. And then, it was moved back to InterBase 4 format.
Everything went fine, except 7 records in one table were completely lost. Anyway, it was a small data loss, so database now works fine.

No comments: