Data lost after computer crash Firebird 2.5

[nas ben]

I have upgraded my Delphi 7 application to use Delphi 10.3 community edition and using FireDac components instead of IBExpress, also the database upgraded from Firsbird 1.5 to Firsbird 2.5, everything seems to be working fine and I have few customers upgraded to our new version, 2 of my customers had intermittent problem where the system freezes and they can't do anything so they have to hard restart the computer, but the biggest problem is that all data which they have entered on that day all lost!! in my code I use transactions and I commit changes when the transaction succeed.
I use the memory leak which comes with Delphi (ReportMemoryLeaksOnShutdown := DebugHook <> 0) and I have eliminated most of the leaks.

I control the transaction in this way

fdTransaction.StartTransaction 

try 

   .... 

   ... 

   .. 

   fdTransaction.Commit; 

except 

   fdTransaction.Rollback; 

   raise; 

end;

Any help would be appreciated.

[Dimitry Sibiryakov]

13.08.2021 11:14, nas ben wrote:
> the biggest problem is that all data which they have entered on that day all lost!!

Forced Writes setting of the databases is...?
Extension of the database file is...?
Version of operation system is...?

--
WBR, SD.

[nas ben]

I checked the Force Writes from IBEXpert and it is set.

it's a firebird file so the extension is .fdb

we have it on both windows 7 and 10.

[Dimitry Sibiryakov]

13.08.2021 14:43, nas ben wrote:
> we have it on both windows 7 and 10.

Any record about automatic system restore point rollback in Windows Events?

--
WBR, SD.

[nas ben]

Also I have upgraded to firebird 2.5.9, the one I was using is 2.5.0, i will see if this will help

[Karol Bieniaszewski]

Do you setup here transaction to the dataset (FDQuery1.Transaction:= fdTransaction )?

 

e.g.

 

fdTransaction.StartTransaction 

try 

   FDQuery1.Transaction:= fdTransaction;

   ... 

   .. 

   fdTransaction.Commit; 

except 

   fdTransaction.Rollback; 

   raise; 

end;

 

All your data go throught default FDConnection transaction and when rolled back you lost all data.

 

Regards,

Karol Bieniaszewski

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/1db9f165-fc09-42e8-91f9-ff0910f1ce6en%40googlegroups.com.