Re: [SQLObject] MySQL: Commands out of sync; you can't run this command now

[Oleg B. <ph...@ph...>]

Hi!

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")

   conn.ping() is intended to reopen the connection after a timeout;
AFAIR the default timeout is 3600 seconds, not a few minutes. There
shouldn't be any problem with ping after a minute or two.

   "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?

> Does it look like a problem with my application, or does it look like
> something that should be handled on the SqlObject side? Or should I
> check for the state of the connection at the start of this function?

   None of that, I'm sure. Unfortunately I cannot help further -- I
seldom use MySQL, I use Postgres for bigger projects and SQLite for
smaller ones, so I have to rely on on other people's feedback.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.