so because its a query that is a SELECT and then MySQLdb is not returning a description, I'm suspecting you might be loading a very large BLOB or a very large result set on a particular query. I'd look into logging what you are sending to the database, and particularly using the debugger or similar at that point if the error is reproducible in a development environment, to see what was passed.
On Mar 31, 2011, at 11:32 AM, Harish Tejwani wrote: > Michael suggested to repost this. > ---- > > We are running on a fairly beefy Linux machine.... and SQLAlchemny > 0.6.5 > > We have started getting getting Out of Memory errors like below (MySQL > runs on same machine). > > Any ideas or suggestion why this could be happening and how to go > about identifying root cause of this > > > Out of memory (Needed 18653760 bytes) > Traceback (most recent call last): > File "/home/topsight/code/topsight-multicore.py", line 36, in > <module> > rules[rule].execute() > File "/home/topsight/code/objects.py", line 1259, in execute > runresult.flag(self.id, update_flagtime=self.update_flagtime) > File "/home/topsight/code/objects.py", line 669, in flag > for e in self.all(): > File "/opt/python26/lib/python2.6/site-packages/SQLAlchemy-0.6.5- > py2.6.egg/sqlalchemy/orm/query.py", line 1576, in all > return list(self) > File "/opt/python26/lib/python2.6/site-packages/SQLAlchemy-0.6.5- > py2.6.egg/sqlalchemy/orm/query.py", line 1790, in instances > fetch = cursor.fetchall() > File "/opt/python26/lib/python2.6/site-packages/SQLAlchemy-0.6.5- > py2.6.egg/sqlalchemy/engine/base.py", line 2490, in fetchall > l = self.process_rows(self._fetchall_impl()) > File "/opt/python26/lib/python2.6/site-packages/SQLAlchemy-0.6.5- > py2.6.egg/sqlalchemy/engine/base.py", line 2459, in _fetchall_impl > self._non_result() > File "/opt/python26/lib/python2.6/site-packages/SQLAlchemy-0.6.5- > py2.6.egg/sqlalchemy/engine/base.py", line 2464, 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. > > -- > 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. > -- 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.
