Hi,
I have a Python application (using Zope 3 framework) which is
connected to an Oracle database throught SQLAlchemy.
Everything is OK except for one thing : each week, the Oracle server
is shutted down for a full cold backup and afterwards, opened
SQLAlchemy connections are broken and can't be
This is a classic use case for pool_recycle=some number of seconds , which
will prevent old connections in the pool from being used. It does of course
assume that connections remain checked into the pool when not being used (i.e.
no Sessions hanging open, etc).
Yes, that's what I thought...
I actually use a pool_recycle parameter of 3600 to recycle active
connections every hour, but the problem remains the same as before
(with default value of -1).
So I'm a bit stuck :-(
Regards,
Thierry
2010/12/20 Michael Bayer mike...@zzzcomputing.com:
This is a