my next suspicion is that mysqldb doesnt like when the same connection gets moved to be used in another thread, which will occur when the default connection pool is being used. i was already thinkikng that, but your setting of thread_pool fixing it seems to suggest it even more strongly.
are you folks on the latest MySQLDB ? if we wanted to prepare a test case for this using the basic DBAPI, it would have to involve using a single connection in multiple threads. sqlalchemy *should* at this point have all open cursors explicitly closed before connections are returned to the pool, since ResultProxy will close out its cursor; however i havent tested this strongly. i can perhaps put in more aggressive logic into the pool itself to make this happen, since we are tracking the individual cursors as well. On Sep 15, 2006, at 12:07 PM, Sébastien LELONG wrote: > Hello there, > > I have the same problem with these "Commands out of sync; you can't > run this > command now", using SA 0.2.4 (SA 0.2.8 not tested yet, but appears > to have > the same behavior) with CherryPy 2.2.1 and MySQL 5.0.22 (and also > MySQLdb > 1.2.1_p2...) > >> [...] reduced test case but I can't get it to occur in anything >> but my >> full TurboGears application > This is the same for me. Without explaining why, when I set CherryPy > server.thread_pool = 0, the problem disappears... > >> do people have this problem working with MySQLDB directly ? im sorta >> running out of options here. > I tried MySQLdb directly, which works nice for me, as expected > according to > what described before. > > > Hope it helps. > > > Cheers, > > > Seb. > -- > Sébastien LELONG > > > On Thursday 14 September 2006 19:44, Karl Guertin wrote: >> On 9/14/06, Michael Bayer <[EMAIL PROTECTED]> wrote: >>> do people have this problem working with MySQLDB directly ? im >>> sorta >>> running out of options here. >> >> I haven't been able to find any. I'll continue trying to track down >> the source of the problem and pull this thread up again if/when I >> find >> the answer. Thanks for your help. >> >> --------------------------------------------------------------------- >> ---- >> 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 > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
