Subject Database corruption on virtual machine
Author Paul Tessman
System configuration:
- FirebirdCS-1.5.4.4910-0.i686 (Classic Server)
- RHEL5 (Linux 2.6.18-53.1.14.el5xen #1 SMP ... x86_64)
- database server and database file running within a VM, on a software
RAIDed ext3 filesystem directly on the (Xen-based) VM host
- database file (just one) sitting at 1.6 GB now (after a gfix and
backup/restore; 1.7 GB before that)

Accessed via:
- Borland C++Builder 5 and IBX

I received the following error:
EIBInterBaseError with message:
'database file appears corrupt () wrong page type page 419181 is of
wrong type(expected 7, found 5)'

I shut down the server and issued a gfix -mend, which fixed the
following:
record level errors: 2
index page errors: 49
database page errors: 807
Then I did a backup/restore.

Nothing abnormal occurred today; this production server was operating as
it always has for the past few years. FB server was not stopped; VM was
not stopped, suspended, rebooted; no copying of database file while in
operation; no gbak/gfix run against the database prior to the error;
etc.

Any ideas what could have caused this?

----------------------
Paul Tessman