On 6/29/15 2:33 PM, Andy Crain wrote:
But these seem heavy handed and wrong. What I’d like to do is just
discard this stale connection (in my session and in the pool) and get
a fresh one, but I can’t determine how to.
at the bottom of that section, the important part is about invalidation:
http://docs.sqlalchemy.org/en/rel_1_0/core/pooling.html#more-on-invalidation
specifically invalidate():
http://docs.sqlalchemy.org/en/rel_1_0/core/connections.html?highlight=invalidate#sqlalchemy.engine.Connection.invalidate
from session:
session.connection().invalidate()
however, you've now killed off your transaction, and you will lose
whatever isn't committed on it. If you don't need the transaction to
last this long, then you shouldn't have a connection checked out - the
Session only has a connection checked out when you are in a
transaction. So I think the original assertion "due to some unavoidable
long-running code" doesn't really make any sense, especially if you are
using an ORM Session. If this isn't impacting you because you are on
MyISAM and are essentially using autocommit, then just set your Session
to use autocommit:
http://docs.sqlalchemy.org/en/rel_1_0/orm/session_transaction.html#autocommit-mode;
no more stale connections.
Thanks for any help.
Andy
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.