Subject Re: [firebird-support] FB3.0.2 : Lost one record (update on power off ?)
Author Mark Rotteveel
On 20-3-2018 16:58, eric.gueguiniat@... [firebird-support] wrote:
> I have the database before backup/restore
> I have an error with gfix on validating
> Summary of validation errors
> Number of index page errors: 3
> Number of database page warnings: 1
> IBE: Validation completed.
> So, after backup/restore the record is still lost, but now I know that
> the dabase was corrupted ...

Is the record visible when you do a full table scan (a select without a
where clause)? The index page error indicates problems with an index,
and this in turn may cause - as an example - "select * from sometable
where id = 1" to return no records while "select * from sometable" (or
"select * from sometable where id+0 = 1") will return the record.

In that case dropping and recreating the index, or backing up and
restoring the database should fix the problem.


Mark Rotteveel