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 <p...@phdru.name> wrote:
> Hi!
>
> On Wed, Apr 24, 2013 at 08:51:57AM +0100, "Maciej (Matchek) Blizi??ski" <
> mac...@opencsw.org> wrote:
> > 2013/4/16 Oleg Broytman <p...@phdru.name>
> > > On Tue, Apr 16, 2013 at 10:52:29AM +0100, "Maciej (Matchek)
> Blizi??ski" <mac...@opencsw.org> 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/ p...@phdru.name
> 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
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
