Subject Re: [IBO] Too many savepoints ...
Author Thomas Steinmaurer
Hi,

> I had a problem with FB 1.5.3, that crashed, when inserting 50
> records.
>
> Using TIBOQuery:
>
> StartTransaction;
> ... Inserting, InsertTriggers ...
> CommitTransaction;
>
> then FB hanged with 100% CPU performance.
> After shutting down the service, the logfile telled:
> "internal gds software consistency check
> (Too many savepoints (287))"

It might be related to using "soft commits" aka "commit retaining" over
a long period of time without using "hard commits" (simply "commit")
from time to time.




--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com