Re: [Zope] Autoconnect with ZMySQLDA 2.0.9
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 be repeated). -- Dieter ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Autoconnect with ZMySQLDA 2.0.9
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 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 be repeated). The problem appear to be present in 4.0.XX and 4.1.XX. Is it still there in MySQL 5.0. And does MySQL-Python and ZMYSQLDA grock MySQL-5.0? -d On Mon, 16 Jan 2006, Dennis Allison wrote: 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 is possible that the connection has really timed out. Looking at the code it appears that ZMySQLDA does not attempt to recreate the connection. Is that correct? What's the recommend approach to re-establish the connection? -d -- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Autoconnect with ZMySQLDA 2.0.9
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 is possible that the connection has really timed out. Looking at the code it appears that ZMySQLDA does not attempt to recreate the connection. Is that correct? What's the recommend approach to re-establish the connection? -d -- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )