Subject Re: [firebird-support] Re: Transaction hung when (n) users execute the same procedure at the same time
Author Thomas Steinmaurer
>> If I look at the log at this time before firebird is restarted, the log>appears to be ok. When I restart firebird, the log shows the>inconsistency database corruption error. If I look at the transactions>with FSQL, it indeed shows many transaction out there where it only>showed the end users log in transaction to begin with.
>
> The log also said something about to many save points.

Might be the result of calling commit/rollback retaining too often. Any
chance that you are doing a commit/rollback yourself or by using some
kind of auto commit mode in your application?

How does gstat -h look like?


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!