[sqlalchemy] 'MySQL server has gone away' on closing connection

2014-03-27 Thread Tim Tisdall
Today I found the following traceback in my logs: 2014-03-27 13:55:59,876 ERROR [sqlalchemy.pool.QueuePool _close_connection b'uWSGIWorker2Core14'] Exception closing connection oursql.Connection object at 0x7fecfdf6a140 Traceback (most recent call last): File

Re: [sqlalchemy] 'MySQL server has gone away' on closing connection

2014-03-27 Thread Michael Bayer
On Mar 27, 2014, at 10:03 AM, Tim Tisdall tisd...@gmail.com wrote: Today I found the following traceback in my logs: 2014-03-27 13:55:59,876 ERROR [sqlalchemy.pool.QueuePool _close_connection b'uWSGIWorker2Core14'] Exception closing connection oursql.Connection object at 0x7fecfdf6a140

Re: [sqlalchemy] 'MySQL server has gone away' on closing connection

2014-03-27 Thread Tim Tisdall
Ah, yeah, that seems like a reasonable way of handling it. I just don't get why I'm getting those exceptions, though, as I have it set to recycle pool connections every 4 hrs where the mysql setting is to expire connections after 8hrs. As far as I understand it, I shouldn't be getting messages

Re: [sqlalchemy] 'MySQL server has gone away' on closing connection

2014-03-27 Thread Michael Bayer
what this looks like is that the connection is closed by the server due to the MySQL timeout, then SQLAlchemy's pool, when accessed, goes to recycle those connections, and does a close() on the existing one. Since they've been closed server side, the close() method raises. The pool