| Subject | FB3.0.2 : Lost one record (update on power off ?) | 
|---|---|
| Author | |
| Post date | 2018-03-19T14:00:03Z | 
Hello,
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.