| Subject | Re: [firebird-support] FB3.0.2 : Lost one record (update on power off ?) |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2018-03-22T14:43:28Z |
On 20-3-2018 16:58, eric.gueguiniat@... [firebird-support] wrote:
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
> I have the database before backup/restoreIs the record visible when you do a full table scan (a select without a
>
> 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 ...
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