Subject Re: Firebird problems
Author mariuz
--- In firebird-support@yahoogroups.com, Cassiano Peixoto <peixotocassiano@...> wrote:
>
> Hello,
>
> I'm using firebird 2.5 running on FreeBSD 9.0 (amd64) with multiple
> instancies (each client has his own process). During the day i can see the
> follow errors in firebird.log:
>
> db1.xxx.com Mon Nov 12 09:06:39 2012
> INET/inet_error: read errno = 54
>
> db1.xxx.com Mon Nov 12 09:56:01 2012
> Database: /var/db/firebird/security2.fdb
> internal Firebird consistency check (cannot find tip page (165), file:
> tra.cpp line: 2448)
>
> db1.xxx.com Mon Nov 12 09:56:01 2012
> Error in isc_start_transaction() API call when working with security
> database
> internal Firebird consistency check (cannot find tip page (165), file:
> tra.cpp line: 2448)
>
> db1.xxx.com Mon Nov 12 09:56:12 2012
> Error in isc_start_transaction() API call when working with security
> database
> internal Firebird consistency check (can't continue after bugcheck)
>
> What it means? my clients are losing connection with the server?

It means that security2.fdb is corrupt , you need to backup it and then restore it in /tmp then stop server
replace security.fdb with the one from restore
http://ibexpert.net/ibe/index.php?n=Doc.Backup#UserDBSecurity