Subject | Re: [firebird-support] Re: Transaction hung when (n) users execute the same procedure at the same time |
---|---|
Author | Thomas Steinmaurer |
Post date | 2011-05-23T18:17:54Z |
>> 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.Might be the result of calling commit/rollback retaining too often. Any
>
> The log also said something about to many save points.
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!