loads() implies you're using PickleType even though not indicated here (just a query by itself tells us very little btw) and the EOFError implies the binary data being loaded is not a valid pickle string.
On Jul 4, 2011, at 3:09 AM, rajasekhar911 wrote: > 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. > -- 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.
