This is the real problem :)
I didn't had problem for a week (the app is running 18h a day) and one day
in a transaction it just blocked.
I tried to recreate the scenario with the production db on a dev machine but
it worked.
Then I restarted the firebird server and all went ok afterwards. In the log
there was this message with 'too many savepoints'.
So it's something what reproduces from time to time and I suspect that it is
a problem with connections/transactions.
However the connections are closed after use, and I did verifications using
ProcessXP to observe the behaviour of the fb server and the
active tcp connections.
I just don't have any clue what's wrong or what to test.
So if anybody had message and did solve it, and would share with us the
experience it would be most helpfull.
Thanks.
----- Original Message -----
From: "Jiri Cincura" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET providers"
<firebird-net-provider@lists.sourceforge.net>
Sent: 20 October, 2006 12:23
Subject: Re: [Firebird-net-provider] Commit retaining
> balazs.zoltan wrote:
>> There are 3 diferent applications, and 5 clients using them at the same
>> firebird server.
>> All 3 applications were developed by us, using a common db layer for
>> communicating with the db server.
>
> Well, can you "create" this error on some sample code (to find the bug in
> provider or in your code)?
>
> --
> Jiri {x2} Cincura
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
