Subject | Re: [firebird-support] Database page errors |
---|---|
Author | Fabiano Bonin |
Post date | 2007-09-26T21:07:22Z |
> > Also, my users are using this database all day and nobody notedYes. I'm sure of it. I double checked it.
> > 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 ?
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.