Subject | Table getting corrupted on server reboot |
---|---|
Author | mes.rahul |
Post date | 2009-09-11T09:55:25Z |
Hello.
I am running Firebird 2.0.4.13130 on a WinXP machine in Super Server mode. I am running an application on the PC which needs to collect data on a 24 x 7 basis and store it in a Firebird database.
The application works fine until the PC is rebooted. When this is done, one particular table is getting corrupted. This table has a fixed number of rows. A row is updated with fresh data every second in this table. To restore functionality, I have to either drop and recreate the table or do a DB backup-restore.
Can someone please tell me why this could be happening or how I can prevent this corruption?
Thanks,
Rahul
I am running Firebird 2.0.4.13130 on a WinXP machine in Super Server mode. I am running an application on the PC which needs to collect data on a 24 x 7 basis and store it in a Firebird database.
The application works fine until the PC is rebooted. When this is done, one particular table is getting corrupted. This table has a fixed number of rows. A row is updated with fresh data every second in this table. To restore functionality, I have to either drop and recreate the table or do a DB backup-restore.
Can someone please tell me why this could be happening or how I can prevent this corruption?
Thanks,
Rahul