|
From: sophana78 . <sop...@gm...> - 2013-10-31 10:51:35
|
I've just noticed that I have the same problem. But my application is multithreaded, and I use MySQL-python (1.2.4) SQLObject (1.4.1) The error occurs when executing a transaction. Does anyone knows how to reset the connection? On Wed, Apr 24, 2013 at 10:09 AM, Oleg Broytman <ph...@ph...> wrote: > Hi! > > On Wed, Apr 24, 2013 at 08:51:57AM +0100, "Maciej (Matchek) Blizi??ski" < > ma...@op...> wrote: > > 2013/4/16 Oleg Broytman <ph...@ph...> > > > On Tue, Apr 16, 2013 at 10:52:29AM +0100, "Maciej (Matchek) > Blizi??ski" <ma...@op...> wrote: > > > > File > "/opt/csw/lib/python/site-packages/sqlobject/mysql/mysqlconnection.py", > > > > line 71, in makeConnection > > > > conn.ping(True) # Attempt to reconnect. This setting is > persistent. > > > > ProgrammingError: (2014, "Commands out of sync; you can't run this > command now") > > > > > > "Commands out of sync"means the application calls functions in the > > > wrong order: > > > https://dev.mysql.com/doc/refman/5.1/en/commands-out-of-sync.html > > > Is the app multithreaded? Could it be the app tries to reuse the > same > > > transaction in different threads? > > > > That was my suspicion too, but it's an wsgi application which doesn't > > use threads. I experimented by reducing the number of wsgi application > > copies / threads in Apache config to 1. It didn't help, so it's > > probably not that. > > > > I've got an update: I noticed that MySQLdb[1] has a new version (1.2.4) > > so I upgraded it and the problem seems to have gone away. Maybe it was > > some interplay between SqlObject and the MySQL driver for Python, or > > just simply the db driver had a problem. > > I'm glad it's fixed. Good luck! > > Oleg. > -- > Oleg Broytman http://phdru.name/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > > ------------------------------------------------------------------------------ > Try New Relic Now & We'll Send You this Cool Shirt > New Relic is the only SaaS-based application performance monitoring service > that delivers powerful full stack analytics. Optimize and monitor your > browser, app, & servers with just a few lines of code. Try New Relic > and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > |
