On 24-5-2019 20:43, Matthias Hanft [email protected] [firebird-support] wrote: > Hi, > > I have a Firebird server 3.0.2.32703.0-r2 on a 32-bit Linux machine > (kernel 4.14.83).
Why aren't you using 3.0.4? A lot of bugs have been fixed since 3.0.2. > 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? The security database is a normal Firebird database. You can check and (attempt to) repair it with gfix just like any other Firebird database. Make sure to keep a copy of the security database as backup. -- Mark Rotteveel
