Hi Is there a way that, i can validate the values in BLOB column (the binary data) maps to a valid pickle string.
if I dump the data from the row to a file, will it be of any use? select results into dumpfile '/tmp/blob_data.txt' from task_results where task_id=1; is there any utility that i can make use of? Thanks in advance On Jul 5, 6:30 pm, rajasekhar911 <rajasekhar...@gmail.com> wrote: > 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 theEOFErrorimplies > > the binary data being loaded is not a valid pickle string. > > > On Jul 4, 2011, at 3:09 AM, rajasekhar911 wrote: > > > > Hi , > > > > I am gettingEOFErrorwhile 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.
