Subject | Database corruption issues |
---|---|
Author | Robert martin |
Post date | 2010-10-14T20:27:08Z |
Hi
We have a client in Australia (we are in New Zealand) who has a large
chain of stores. They are periodically getting data base corruption
messages. They are invariably something along the lines of...
database file appears corrupt()
wrong page type
page nnnn is of wrong type (expect 7, found 5)
gds_$receive failed.
Most (almost all) of the errors happen at their head office but they
also occasionally appear at their shops as well. It shows up in 3
different databases, some running in FB 2.0 others in 2.1. The
applications accessing these databases are also all different, so I
don't think it is being caused by the application. The databases at HO
run on two different computers. They do have power issues (spikes etc)
but all machines are (apparently) behind ups devices (with filters).
Usually I can fix the issue with Gfix followed by backup and restore.
Often (may be always) I have to disable garbage collection (-g) when
doing the backup for it to successfully complete.
Any suggestion as to what actions to take would be appreciated.
Thanks
Rob
We have a client in Australia (we are in New Zealand) who has a large
chain of stores. They are periodically getting data base corruption
messages. They are invariably something along the lines of...
database file appears corrupt()
wrong page type
page nnnn is of wrong type (expect 7, found 5)
gds_$receive failed.
Most (almost all) of the errors happen at their head office but they
also occasionally appear at their shops as well. It shows up in 3
different databases, some running in FB 2.0 others in 2.1. The
applications accessing these databases are also all different, so I
don't think it is being caused by the application. The databases at HO
run on two different computers. They do have power issues (spikes etc)
but all machines are (apparently) behind ups devices (with filters).
Usually I can fix the issue with Gfix followed by backup and restore.
Often (may be always) I have to disable garbage collection (-g) when
doing the backup for it to successfully complete.
Any suggestion as to what actions to take would be appreciated.
Thanks
Rob