Hi Mike - answers below. Thanks!
David Mike Orr wrote: > 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. > model.Session.remove() is in the "finally" of the __call__() > Are you using SQLAlchemy's ORM, SQL builder, or both? > BOTH > Have you turned on SQL logging and connection pool logging? What are > the last couple queries executed before this happens? > I tried this - but wouldn't you know it, with logging the error doesn't appear! If I turn off the logging, the error *does* appear (occasionally). So I am not sure what to do at this point... --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
