Hi,

I think 'pool_recycle' is not working. My configuration is:

MySql wait_timeout=10
pool_size=10
pool_recycle=5
max_overflow=2

I do one select first, and sleep 15 seconds waiting for connection
timeout, at last do other one select.
It raised Exception 'MySQL server has gone away'.

And I remove pool_recycle to test again.
Error is same.

Finally, I add session.close() after first select, it is working
without exception.

In other words, pool_recycle do NOT help 'MySQL server has gone away'.
Just need to close connection and use connection pool.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to