On Nov 7, 2007 8:26 PM, David Geller <[EMAIL PROTECTED]> wrote: > Mike Orr wrote: > > Are you using SQLAlchemy's ORM, SQL builder, or both? > > > BOTH
Are you using Session.execute() for your non-ORM queries? Anything else can cause the session cache to get out of sync with the database. Are you doing any non-transactional queries like "ALTER TABLE"? Those will commit a transaction without telling the ORM. > > 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... Are you getting log messages? If not, you may have to set level=DEBUG in the sqlalchemy logger or root logger. -- 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 -~----------~----~----~----~------~----~------~--~---
