Subject | Re: [firebird-support] FB3.0.2 : Lost one record (update on power off ?) |
---|---|
Author | Marcos Doni |
Post date | 2018-03-19T17:32:31Z |
On Mon, Mar 19, 2018, 14:17 eric.gueguiniat@... [firebird-support] <firebird-support@yahoogroups.com> wrote: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.