Hi,
My web application has a controller that spawns multiple threads using
a thread pool. Each of them has its own session (I store it in thread
local). Occasionally (1 out of 100 or more) I get really strange
errors that really look like corrupted queries.
My guess is that it may be due to my thread pooling and the fact that
a session may be reused for multiple jobs.
I know this is a pretty open question but any hint would help.
Thanks,
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/attributes.py", line
168, in __get__
return self.impl.get(instance_state(instance),dict_)
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/attributes.py",
line 420, in get
value = self.callable_(state, passive)
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/strategies.py",
line 497, in _load_for_state
for pk in prop_mapper.primary_key
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/mapper.py", line
1503, in _get_state_attr_by_column
return state.manager[prop.key].impl.get(state, dict_,
passive=passive)
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/attributes.py",
line 418, in get
value = callable_(passive)
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/state.py", line
275, in __call__
self.manager.deferred_scalar_loader(self, toload)
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/mapper.py", line
1542, in _load_scalar_attributes
refresh_state=state)
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/query.py", line
2071, in _load_on_ident
return q.one()
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/query.py", line
1744, in one
ret = list(self)
File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/query.py", line
1787, in __iter__
return self._execute_and_instances(context)
File "/usr/lib/pymodules/python2.6/sqlalchemy/ext/
horizontal_shard.py", line 57, in _execute_and_instances
partial.extend(iter_for_shard(shard_id))
File "/usr/lib/pymodules/python2.6/sqlalchemy/ext/
horizontal_shard.py", line 49, in iter_for_shard
self._params)
File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line
1358, in execute
params)
File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line
1491, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line
1599, in _execute_context
context)
File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line
1592, in _execute_context
context)
File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/default.py",
line 325, in do_execute
cursor.execute(statement, parameters)
ProgrammingError: (ProgrammingError) syntax error at end of input
LINE 1: SELECT
^
'SELECT ' {}
--
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.
