On 24-5-2019 20:43, Matthias Hanft mh@... [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