Hi , I am getting EOFError while querying a table . The select contains String fields, integer fields , a BLOB and a TEXT filed. The error happens consistently. This is happening in a customer envt. Anybody has any idea on what could be the issue?
Thanks in advance stack trace is given below ------------------------------------ Traceback (most recent call last): File "./xxxxxx/src/xxxxxx/web/xxxxxx/xxxxxx/controllers/ ControllerImpl.py", line 286, in get_tasks File "./xxxxxx/src/xxxxxx/web/xxxxxx/xxxxxx/viewModel/Userinfo.py", line 1602, in get_tasks File "/home/xxxxxx/xxxxxx/tg2env/lib/python2.6/site-packages/ SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/orm/query.py", line 1267, in all return list(self) File "/home/xxxxxx/xxxxxx/tg2env/lib/python2.6/site-packages/ SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/orm/query.py", line 1425, in instances for row in fetch] File "/home/xxxxxx/xxxxxx/tg2env/lib/python2.6/site-packages/ SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/orm/query.py", line 1424, in <genexpr> rows = [rowtuple(proc(context, row) for proc in process) File "/home/xxxxxx/xxxxxx/tg2env/lib/python2.6/site-packages/ SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/orm/query.py", line 2156, in proc return row[column] File "/home/xxxxxx/xxxxxx/tg2env/lib/python2.6/site-packages/ SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/engine/base.py", line 1348, in __getitem__ return self.__parent._get_col(self.__row, key) File "/home/xxxxxx/xxxxxx/tg2env/lib/python2.6/site-packages/ SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/engine/base.py", line 1620, in _get_col return processor(row[index]) File "/home/xxxxxx/xxxxxx/tg2env/lib/python2.6/site-packages/ SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/types.py", line 284, in process return self.process_result_value(impl_processor(value), dialect) File "/home/xxxxxx/xxxxxx/tg2env/lib/python2.6/site-packages/ SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/types.py", line 778, in process_result_value return loads(str(value)) EOFError query is as follows ---------------------------- tasks=DBSession.query(Task.task_id, Task.name, Task.user_name, Task.entity_name, Task.cancellable, \ TaskResult.timestamp, TaskResult.endtime, TaskResult.status, TaskResult.results, \ Task.entity_type, Task.short_desc).\ join(TaskResult).\ filter(and_(Task.repeating == True,TaskResult.visible == True)).\ filter(Task.submitted_on >= ago).\ order_by(TaskResult.timestamp.desc()).limit(limit).all() Thanks -- 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.