Subject Re: [firebird-support] Database page errors
Author Vlad Khorsun
>> > Do you think i am in risk working with this database?
>> Run gfix again. I guess it will not return this errors.
> Bingo!
> [root@server1 firebird]# gfix -v -full tecelagem.fdb.observacao
> [root@server1 firebird]#

Very well ;)

> I started to use SS in this box recently and i'm observing something
> i'm not sure it is expected:
> When i "gfix -shut single -force 0" a database, i still see fbserver
> connected to this database. Is it expected?

Yes. All attachments still active. They just can't do anything except
of disconnect

> If fbserver is making a garbage collection will it stay connected to the
> database after the shutdown?

Can't say for sure. I need to look at sources to get correct answer.

> I took a look at a backup of this database and these relation ID's
> were really of that 4 deleted tables. I will try to reproduce what
> happened in my environment:
> - I shut down the database in single user mode
> - I did run a large set of DDL and DML instructions to upgrade the
> database (here i dropped the tables), using a update application. I
> commit after each instruction.
> - I closed the upgrade application
> - I did run "gfix -v -full" in the database and got the erros

Aha, validation code used in-memory metadata (i.e. not read it from disk
as in usual case of only exclusive attachment) and picked up deleted relations.
I think its a bug in validation code. Can you post simplified example into
tracker, please ?

And you can be sure - all is ok with your database, there was false
errors ;)