From: lmf <lm...@yg...> - 2004-12-03 07:02:16
|
We use firebird 1.52 RC4 as our enterise database system, there are four or five database file in our Win2000 NTFS file volume, the corrupt database is D:\DATA\SSERP.GDB and the size of the database is 4345612 KB. There are more than 600 table in the database, if include other objects like views, store procedures, triggers, and indexes, there are more than 900 objects in the database. Several days ago, the database corrupted, and all client cannot access databases in the Win2000 machine. Three days before yesterday we tried almost we could tried and at last we used Firebird 2.0 and succeed in mending, backuping and restoring the database. But the database only runned two days, yesterday it could not work again, and at the night we dropped one big table, then we could backup and restore the database with Firebird 1.52 RC4, and mend, backup, restore the database with the big table with Firebird 2.0, at last we merged the big table into the database. Today the database corrupted again!!! And it cannot connect it gain( mabye it says that the database file is used by other user). We feel very shameful at our clients. I dont know what is limit of the firebird database system, who can give me some explanation. The followings is today's firdbird.log Database: D:\DATA\SSERP.GDB database file appears corrupt () wrong page type page 1056022 is of wrong type (expected 7, found 5) internal gds software consistency check (error during savepoint backout (290), file: exe.cpp line: 2807) |