On Nov 7, 2007 2:37 PM, David Geller <[EMAIL PROTECTED]> wrote: > > Hi, > > Running a pylons app under heavy load by several simultaneous users have > yielded the following error (several times): > > 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 0x8c9bcac>> ignored
It sounds like shared sessions or connections are stomping on each other. Did you put model.Session.remove() or model.Session.close() in your base controller's .__call__ or .__after__ method? Omitting it would cause something like this, though I haven't seen an exception in this situation, just stale data leaking into a later request. Are you using SQLAlchemy's ORM, SQL builder, or both? Have you turned on SQL logging and connection pool logging? What are the last couple queries executed before this happens? -- Mike Orr <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
