theres a new option "pool_recycle" which will cause a connection to be automatically closed and reopened after a given number of seconds, you might want to try that.
is there some known way to reproduce this condition ? On Sep 13, 2006, at 3:54 PM, Karl Guertin wrote: > I'm using SA to talk to a MySQL database, but the database has a > tendency to drop my connection while the queries are running. > > SQLError: (OperationalError) (2013, 'Lost connection to MySQL server > during query') 'SELECT sum(bgp_churn.count) \nFROM bgp_churn \nWHERE > bgp_churn.tstamp > %s AND bgp_churn.type = %s \n LIMIT 1' > [1158084083.0, 'U'] > > This isn't a particularly big deal for my application, I'm caching the > results and can just retry a minute or two later. Unfortunately, this > IS a big deal to SQLAlchemy. Frequently, but not always, it gets into > a state where every query after this results in a 'Commands out of > sync' message. > > SQLError: (ProgrammingError) (2014, "Commands out of sync; you can't > run this command now") 'SELECT bgp_churn.asn, sum(bgp_churn.count) AS > count \nFROM bgp_churn \nWHERE bgp_churn.tstamp > %s AND > bgp_churn.type = %s GROUP BY bgp_churn.asn ORDER BY count DESC \n > LIMIT 4' [1158089885.0, 'U' > > Here's the MySQL manual page on this error: > > http://dev.mysql.com/doc/refman/4.1/en/commands-out-of-sync.html > > The strange thing is that this does not occur consistently. It seems > to occur less frequently when echo is on but that might be a placebo > on my part. > > > In any event, I'd appreciate suggestions on how to clean up after > losing a connection. I figure that if I can kill the entire pool and > reconnect to the database, I'll be fine. I just can't figure out how > to do that through the SQLAlchemy API. > > I've been poking at this error for a few weeks trying to come up with > a reduced test case but I can't get it to occur in anything but my > full TurboGears application (the intermittency doesn't help). Any > advice would be appreciated. > > ---------------------------------------------------------------------- > --- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your > job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel? > cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
