Subject Re: [firebird-support] FB3.0.2 : Lost one record (update on power off ?)
Author Marcos Doni
I suggest you to check and test following:

- be extremely sure no client is deleting the record
- hard drive corruption with apropriate software like SeaTools
- hard drive cache enabled
- try install latest Firebird 3.0.3 doing a backup restore

On Mon, Mar 19, 2018, 14:17 eric.gueguiniat@... [firebird-support] <> wrote:


We have a strange thing on a firebird 3.0.2 database
One only Machine on Windows (Microsoft Windows Embedded Standard)

We lost a record in a database

Circumstances :
Power off of the computer in activity
After restart our program doesn't work ( Qt Program )
No problem on validation
Backup and restore ok without problem
and we find that a main record in a table is not exist anymore
We reinject from a previous backup and it's start again

We are sure that the record was in database just before power off
( This record is essential to program and we have some dependant record just before power off )

We don't have :
delete code to this table in the program
no delete code in stored procedure to this table
nor in source program and not in the database stored proc

the only operation is that we update a field very often on this record
So maybe this record just was in update when computer was power off

No messages in firebird.log  

We never have such thing with previous releases of firebird (2.5, 2.1, 1.5)

Usually, the db was corrupted in such situation and we know that a problem was occured 

Is somebody have heard something about such problem with FB3 ?

Thank you.