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