Subject | Re: [firebird-support] Database corruption on virtual machine |
---|---|
Author | unordained |
Post date | 2008-10-27T20:41:38Z |
---------- Original Message -----------
From: "Paul Tessman" <pault@...>
I don't, but maybe someone else does?
Has anyone had trouble with keeping their database files clean when running on a
VM, Xen or otherwise? I've been considering this as an option for my clients
too. Any special considerations as far as configuring the pass-through
filesystem, making sure that file locking works correctly, etc.?
-Philip
From: "Paul Tessman" <pault@...>
> System configuration:------- End of Original Message -------
> - 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
I don't, but maybe someone else does?
Has anyone had trouble with keeping their database files clean when running on a
VM, Xen or otherwise? I've been considering this as an option for my clients
too. Any special considerations as far as configuring the pass-through
filesystem, making sure that file locking works correctly, etc.?
-Philip