Re: [Zope] Autoconnect with ZMySQLDA 2.0.9

2006-01-17 Thread Dieter Maurer
Dennis Allison wrote at 2006-1-16 17:37 -0800: ... What's the recommend approach to re-establish the connection? You reopen the connection (usually the db object has all necessary information) and then raise an exception derived from ZODB.POSException.ConflictError (in order to let your request

Re: [Zope] Autoconnect with ZMySQLDA 2.0.9

2006-01-17 Thread Dennis Allison
After some investigation, this appears to be a mysql bug or brain-dead semantics for mysql_ping. See http://lists.mysql.com/mysql/190441 and http://bugs.mysql.com/bug.php?id=14057 http://bugs.mysql.com/bug.php?id=2845 Dieter Mauer suggests the right thing is to catch the exception and then

[Zope] Autoconnect with ZMySQLDA 2.0.9

2006-01-16 Thread Dennis Allison
I have been seeing occasional release unlocked lock errors from a storage error in a two-phase commit which really comes from a Lost connection to MySQL server during query. Apparently this arises from a failure of self.db.ping() to find a connected database as the transaction is opened. It