Hi!
On Thu, Oct 31, 2013 at 10:40:07AM +0100, "sophana78 ." <sophan...@gmail.com>
wrote:
> 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?
Yes, I think mysqlconnection.py is a better place to handle
MySQL-specific problems.
Oleg.
--
Oleg Broytman http://phdru.name/ p...@phdru.name
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
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
