Hi Michael thanks for the reply. there is a PickleType in the query (the one that i have mentioned as BLOB data type). I have given a test program to the customer and waiting for the response.
thanks again On Jul 4, 8:01 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > 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 sqlalchemy@googlegroups.com. > > To unsubscribe from this group, send email to > > sqlalchemy+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://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 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.