Subject RE: [firebird-support] Illegal seek error
Author Leyne, Sean
Jiri,

> OK. Today the database was again in errors, totally corrupted
> (Database file appears corrupt. Wrong page type. Page NNN is of
> wrongtype (expected X, found Y)). The gfix was unable to fix it. :( I
> have no time to play with it, just restore as fast as possible.
>
> Other databases were running fine.
>
> The database is pretty small <50MB, <5 transactions per second. FW are
on.

Although seek errors are the results of programs performing IO
operations on invalid disk positions, the fact that you are getting the
errors is due to the database corruption.

I would start to suspect that the problem lies with the disk
drive/subsystem!

The only time I have seen database corruptions, in 20+ years (15 with
IB/FB), has been the result of:

- Server Abends (abrupt shutdowns), even with Forced Writes = ON

- Disk drive/controller failure


Sean