make sure the Session is closed when not in use. Make a new session when its
time to talk to the database again. This is in the notes for pool_recycle -
it works upon checkout from the pool.
On Jan 23, 2011, at 2:40 PM, emcconne wrote:
> I'm new to SQLAlchemy and don't understand how I can maintain my
> connections to Postgres over long periods of time... (or reestablish
> them automatically). I am getting this error after my web application
> sits idle for long periods of time. I am using scopedSession() and
> and creating the engine like so...
>
> engine = create_engine(connstring, echo=echo, pool_recycle=20000,
> poolclass=QueuePool, pool_size=5)
>
> This is the error after timing out...
>
> results =
> scopedSession().query(ExceptionPageRequest).filter(ExceptionPageRequest.owned_by_id
> == fg_id ).filter(ExceptionPageRequest.status == None).all()
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/orm/query.py", line 1576, in all
> return list(self)
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/orm/query.py", line 1688, in __iter__
> return self._execute_and_instances(context)
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/orm/query.py", line 1693, in _execute_and_instances
> mapper=self._mapper_zero_or_none())
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/orm/session.py", line 729, in execute
> clause, params or {})
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/engine/base.py", line 1191, in execute
> params)
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/engine/base.py", line 1271, in _execute_clauseelement
> return self.__execute_context(context)
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/engine/base.py", line 1302, in __execute_context
> context.parameters[0], context=context)
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/engine/base.py", line 1401, in _cursor_execute
> context)
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/engine/base.py", line 1394, in _cursor_execute
> context)
> File "/Library/Python/2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/
> sqlalchemy/engine/default.py", line 299, in do_execute
> cursor.execute(statement, parameters)
> sqlalchemy.exc.OperationalError: (OperationalError) could not receive
> data from server: Operation timed out
>
> Thanks ahead of time :)
>
> --
> 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.
>
--
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.
