I'm using CherryPy with SQLAlchemy. I've tried this with both
SQLAlchemy's scoped_session thread-local sessions, as well as (also
local-to-thread) sessions I create in my web code manually.

2008-12-16 11:51:14,524 DEBUG cherrypy.error.140068141119376: [16/Dec/
2008:11:51:14] HTTP Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py",
line 1027, in first
    ret = list(self[0:1])
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py",
line 952, in __getitem__
    return list(res)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py",
line 1088, in __iter__
    return self._execute_and_instances(context)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/query.py",
line 1091, in _execute_and_instances
    result = self.session.execute(querycontext.statement,
params=self._params, mapper=self._mapper_zero_or_none(),
_state=self._refresh_state)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/orm/session.py",
line 749, in execute
    return self.__connection(engine, close_with_result=True).execute(
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 806, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 856, in execute_clauseelement
    return self.__execute_context(context)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 878, in __execute_context
    self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 927, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor)
  File "/usr/lib/python2.4/site-packages/sqlalchemy/engine/base.py",
line 909, in _handle_dbapi_exception
    raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
InterfaceError: (InterfaceError) (0, '') u'SELECT login.username AS
login_username, login.password AS login_password, login.`loginId` AS
`login_loginId`, login.salt AS login_salt, login.email AS login_email,
login.status AS login_status, login.message AS login_message,
login.`accountId` AS `login_accountId` \nFROM login \nWHERE
login.`loginId` = %s \n LIMIT 0, 1' [36L]

The first time this query runs, it works fine. Thereafter I get this
error message. Any ideas?

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to