Subject Re: [firebird-support] Database page errors
Author Fabiano Bonin
> > Also, my users are using this database all day and nobody noted
> > anything strange.
>
> Very strange. Are you sure error messages from firebird.log are from
> the same database ? And generated at the same time you run gfix ?

Yes. I'm sure of it. I double checked it.

I'm searching for these table ID's in this database and they are not there:

SQL> select * from rdb$relations where rdb$relation_id = 213;
SQL> select * from rdb$relations where rdb$relation_id = 224;
SQL> select * from rdb$relations where rdb$relation_id = 226;
SQL> select * from rdb$relations where rdb$relation_id = 228;

Recently i droped 4 tables and created 4 views with the same name. Is
it possible that this error is related to this change?

Do you think i am in risk working with this database?
Can i recover it manually, ie: deleting the orphan records/pages somehow?

I ask because i do incremental remote backups and this is a large
database, and when i do a complete backup/restore, the next
incremental backup get the size of the full database, and it's very
hard to tranfer all its data over a link that is not too fast.

Regards,

Fabiano.