Some time in the past I could leave my app running overnight and come
back in the morning and everything worked fine. More recently that
stopped working (around SVN r1840 maybe?). Now I get a "connection
not open" error. Here's the trace:
...
File ".../sqlalchemy/attributes.py", line 32, in __get__
return self.get(obj)
File ".../sqlalchemy/attributes.py", line 175, in get
value = callable_()
File ".../sqlalchemy/orm/properties.py", line 417, in lazyload
return self.mapper.using(session).get(ident)
File ".../sqlalchemy/orm/query.py", line 44, in get
return self._get(key, ident, **kwargs)
File ".../sqlalchemy/orm/query.py", line 297, in _get
return self._select_statement(statement, params=params,
populate_existing=reload)[0]
File ".../sqlalchemy/orm/query.py", line 305, in _select_statement
return self.instances(statement, params=params, **kwargs)
File ".../sqlalchemy/orm/query.py", line 267, in instances
result = self.session.execute(self.mapper, clauseelement,
params=params)
File ".../sqlalchemy/orm/session.py", line 114, in execute
return self.connection(mapper, close_with_result=True).execute
(clause, params, **kwargs)
File ".../sqlalchemy/engine/base.py", line 246, in execute
return Connection.executors[type(object).__mro__[-2]](self,
object, *multiparams, **params)
File ".../sqlalchemy/engine/base.py", line 270, in
execute_clauseelement
return self.execute_compiled(elem.compile(engine=self.__engine,
parameters=param), *multiparams, **params)
File ".../sqlalchemy/engine/base.py", line 288, in execute_compiled
return ResultProxy(self.__engine, self, cursor, context,
typemap=compiled.typemap)
OperationalError: connection not open
I noticed that some work has been done on the connection pool
recently, so maybe that has something to do with it. Let me know if I
can help to find the problem.
~ Daniel
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
