Subject | Corruption of firebird db |
---|---|
Author | jstahl80 |
Post date | 2006-03-28T06:52:31Z |
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
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