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 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.