We have an application using SQLAlchemy to query an Oracle database.
We started to see errors with the QueuePool running out of
connections, so we upped the number of connections (and overflow).
However, now we're seeing behavior where, when running in mod_wsgi,
the number of Apache processes goes wild, and all the httpd processes
freeze. There are *no* error messages except for the following:
[Wed Mar 23 19:02:01 2011] [error] Exception AttributeError:
AttributeError("'NoneType' object has no attribute 'pop'",) in <bound
method InstanceState._cleanup of <sqlalchemy.orm.state.InstanceState
object at 0x2aaab4448f50>> ignored
I saw Michael's post (http://groups.google.com/group/sqlalchemy/
browse_thread/thread/744b333985f14d50/f9a586bc8a68e4ec?
lnk=gst&q=AttributeERror+_cleanup&fwc=2) about this, indicating its
not an issue _assuming that the Session is cleaned up_ properly. A
good portion of the code uses:
conn = Session.connection()
cursor = conn.connection.cursor()
# Several of the following
cursor.execute("...")
cursor.callproc("...")
There's no explicit closing of the Session or the cursor itself; would
this cause the GC issues we're seeing, and the eventual hanging of
Apache?
Andrew
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en.
