On 20-3-2018 16:58, [email protected] [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 -- Mark Rotteveel
