[sqlalchemy] Re: InvalidRequestError: Can't reconnect until invalid transaction is rolled back error during SELECT query

2013-08-20 Thread Jim Carroll
I'm having the same issue with a Pyramid web app. Did anyone find a solution? I've tried Flup and Waitress as the containers for the pyramid app, and I've tried Lighttpd and Nginx in front... no difference. My latest exceptions look like: Could not convert return value of the view callable

[sqlalchemy] Convert non-instrumented to instrumented just in time?

2008-04-09 Thread Jim Carroll
Hi, I'm just mucking around with Pyro to see if I can use my entity objects on both sides, even though only one side knows anything about SQLAlchemy. So my server is the instrumented side, and it does the actual database access. On my client, I create my objects, and try to call

[sqlalchemy] Blasted ForeignKey exceptions

2008-04-02 Thread Jim Carroll
MySQL 5.0.38 with InnoDB tables / SQL Alchemy 0.4.4 / Python 2.5.1 Hi, I'm really impressed with SQL Alchemy in general, but now that I'm trying to use it for a large-ish project, I'm getting stuck more often than I'd like. The problem is that when I try to create a record that has foreign