a similar case was seen recently and it's a MySQLdb bug. closed here: http://www.sqlalchemy.org/trac/ticket/2536
here's the mySQLdb issue, hasn't been commented on by the developers yet: http://sourceforge.net/tracker/?func=detail&aid=3546166&group_id=22307&atid=374932 On Aug 17, 2012, at 4:03 AM, Chris Withers wrote: > Hi All, > > Has anyone else seen this using SQLAlchemy with MySQL? > I believe something else has the table the model is mapped to locked, but > this error doesn't make a lot of sense. Is this something that's been fixed > in a later version? > > for request in session.query(SomeModel).with_lockmode('update').all(): > File > "/var/buildout-eggs/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/orm/query.py", line > 1579, in all > return list(self) > File > "/var/buildout-eggs/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/orm/query.py", line > 1791, in instances > fetch = cursor.fetchall() > File > "/var/buildout-eggs/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/base.py", > line 2498, in fetchall > l = self.process_rows(self._fetchall_impl()) > File > "/var/buildout-eggs/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/base.py", > line 2467, in _fetchall_impl > self._non_result() > File > "/var/buildout-eggs/SQLAlchemy-0.6.6-py2.6.egg/sqlalchemy/engine/base.py", > line 2472, in _non_result > "This result object does not return rows. " > sqlalchemy.exc.ResourceClosedError: This result object does not return rows. > It has been closed automatically. > > cheers, > > Chris > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
