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 [email protected] [firebird-support] < [email protected]> 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. > > > > > > > > >
