Subject | Security database corrupt? Can't really believe |
---|---|
Author | Matthias Hanft |
Post date | 2019-05-24T18:43:37Z |
Hi,
I have a Firebird server 3.0.2.32703.0-r2 on a 32-bit Linux machine
(kernel 4.14.83).
Every once in a while, an INSERT command fails. At that time, the
firebird.log contains the message
Authentication error
database file appears corrupt (/etc/firebird/security3.fdb)
wrong page type
page 22 is of wrong type (expected pointer, found index root)
(sometimes it's page 16 instead of 22)
Immediately after that error, everything runs fine again (even
subsequent INSERTs, and every other thing).
The databases on that server are highly used, and the error occurs
averaged only once per month:
Sep 27, 2018
Nov 9, 2018
Dec 26, 2018
Jan 10, 2019
Mar 20, 2019
Apr 12, 2019
Apr 17, 2019
May 24, 2019
Since that's not very often, and everything is OK after that,
I didn't care much about it - should I?
Is there a "check-and-repair-security-database" tool?
Thanks,
-Matt
I have a Firebird server 3.0.2.32703.0-r2 on a 32-bit Linux machine
(kernel 4.14.83).
Every once in a while, an INSERT command fails. At that time, the
firebird.log contains the message
Authentication error
database file appears corrupt (/etc/firebird/security3.fdb)
wrong page type
page 22 is of wrong type (expected pointer, found index root)
(sometimes it's page 16 instead of 22)
Immediately after that error, everything runs fine again (even
subsequent INSERTs, and every other thing).
The databases on that server are highly used, and the error occurs
averaged only once per month:
Sep 27, 2018
Nov 9, 2018
Dec 26, 2018
Jan 10, 2019
Mar 20, 2019
Apr 12, 2019
Apr 17, 2019
May 24, 2019
Since that's not very often, and everything is OK after that,
I didn't care much about it - should I?
Is there a "check-and-repair-security-database" tool?
Thanks,
-Matt