Hi All, I get 'Mysql server has gone away' and 'failed to reconnect' errors, that's why I think that my app holds connections and never releases them.
But the irony is that I'm issuing rollbacks or commits at the end of every request (rollbacks on any exception, commit if everything is ok) and seeing ROLLBACK and COMMIT messages in the log. The only possible root cause that I know is that I'm using the following approach: when working with ORM I use session.add, session.query etc, allowing session to manage connections. But when I need direct access to tables i use session.connection().execute..., so I suspect that this one gives me brand new connection from the pool that I should release explicit, am I right? Is there any way to watch connections that request uses to understand where am I doing it wrong? Thanks in advance, Alex --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
