Hi everyone. I'm doing performance test on my webb application (cherrypy 2.2, SQLObject 0.7 stable and Mysql 5.0.18) with apache benchmark and I notice that sometimes when all threads doing simultaneously query I get:
Exception _mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now") in <bound method Cursor.__del__ of <MySQLdb.cursors.Cursor object at 0xafe79c4c>> ignored I start digging on problem and I find that there was a post in this case earlier: http://thread.gmane.org/gmane.comp.python.sqlobject/1320 but I didn't found any final solution. Can someone tell me what is going wrong and how connection pooling is working under SQLObject. For me it's looks like that one thread trying to delete cursor and the other at the same time try to use it. I don't know how to deal with that. I run test with 10 concurrency request but my application works on 5 thread, so I don't know how is it managed, and how to improve that. Any help will be appreciated. Gregor ---------------------------------------------------- Sharon Stone w filmie "Nagi Instynkt 2" w kinach od 29 marca! http://klik.wp.pl/?adr=http%3A%2F%2Fadv.reklama.wp.pl%2Fas%2Fnagi_instynkt.html&sid=712 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
