Subject Re: [firebird-support] Corruption of firebird db
Author Bogusław Brandys
jstahl80 wrote:
> I have had 3 times now database corruption of an FB1.5 database
> after these happenings:
>
> 1. The disk containing the DB is running low on free space.
> 2. It seems to me, that as a result of this, the machine runs out of
> RAM. Note however, that the swap file is on a different disk.
> 3. After a normal shutdown of the machine, the database file is
> corrupt having page pointers pointing behind the EOF.
>
> Is such corruption known problem?
>
> Here is an excerpt of the firebird log. There are no write errors
> for the db file.
>
> HALOHAN5 Sat Mar 25 19:23:24 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3151 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:24 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3235 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:31 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3148 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:31 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3148 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:36 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3148 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:36 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3148 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:36 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3148 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:41 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3123 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:42 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3123 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:42 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 2947 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:42 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 2947 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:47 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 2971 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:47 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 2971 page buffers of 4096 requested
>
> HALOHAN5 Sat Mar 25 19:23:49 2006
> INET/inet_error: read errno = 10054
>
> HALOHAN5 Sat Mar 25 19:23:49 2006
> INET/inet_error: read errno = 10054
>
> HALOHAN5 Sat Mar 25 19:23:49 2006
> INET/inet_error: read errno = 10054
>
> HALOHAN5 Sat Mar 25 19:23:59 2006
> Database: F:\P2_DB\FIREBIRD\DBA6190.FDB
> Allocated 3581 page buffers of 4096 requested
>
>

And ? What is database corruption symptoms ? What gfix says ?


Regards
Boguslaw