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)
|
