April 17th, 2013, 04:20 AM
Firebird database gets corrupted on each server reboot
We have noticed that the last two times we have rebooted our server, our main Firebird database seems to become corrupted/damaged in some way.
We are careful to ensure that all users are logged out, then we stop the firebird service. Then shutdown and reboot the system.
After rebooting, the database is available and we can connect to it. However one table seems to be only partially accessible. Its always the same table, and the beginning of the table is accessible but not the end.
Our setup is;
Firebird 2.5 Superserver
Windowx XP SP3
Database size is around 1.2GB in a single file, page size is 8K, forced writes are on, automatic sweep is off. We schedule a sweep daily at midnight.
Why would firebird currupt the database after a server restart?