Subject Re: [firebird-support] Re: Firebird problems
Author Cassiano Peixoto
Thank you for your help. Do you know if is possible to change security2.fdb
location in the run time?


On Tue, Nov 13, 2012 at 2:00 PM, mariuz <mariuz@...-dev.ro>wrote:

> **
>
>
>
>
> --- 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
>
>
>


[Non-text portions of this message have been removed]