<class 'sqlobject.dberrors.ProgrammingError'>: Commands out of sync; you can't run this command now

Hi

Every few weeks, my web server, which uses sqlobjects, gets stuck with this
error:
<class 'sqlobject.dberrors.ProgrammingError'>: Commands out of sync; you
can't run this command now

It sometime recovers after a few hundred transactions, sometime, it doesn't
and remains stuck in this state.

It seems that all connections in the pool are "bad".

Do you know a way of reseting these connections? conn.commit()?
conn.ping()? kill the connection (how)?

After looking at the code, I'm thinking about the following patch:
in dbconnection.py, in _runWithConnection, I would like to catch this
error. If it happens, I would reset the connection, then retry.

Or should I do this in mysqlconnection.py, in _executeRetry?

Is there a way to know what was the previous transaction that causes this
problem on the connection?

Thanks for your help.

------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss