Hi Etoile, I hope this was the problem, I know there is a similar problem with the PostGres db module since when I encounter this problem I did test them and I found the same problem.
Julien -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Etoile Dièse Sent: July 22, 2005 3:07 AM To: [email protected] Cc: David Sugar Subject: [Bayonne-devel] Mysql module problem Hello, In the version 1 of Bayonne, when a SQL request is long, or blocked for example because the table is locked by another request, if the user hangs up, no more mysql request can be done and every trunk doing it remains blocked. The reason is that the mysql module object is unique and protected by an internal mutex. The mutex is positionned before the operations and when the request is suddenly interrupted by the hangup, the mutex stays in a blocked state. We modified the file mysql.cpp for using a private mysql connection handler for every trunk that needs it. I will post the patch against the 1.2.14 version as soon as we have tested it (this week-end). -- Etoile Dièse _______________________________________________ Bayonne-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bayonne-devel _______________________________________________ Bayonne-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bayonne-devel
