To keep this from happening I just made a little cron job that uses wget to request one of my TG pages once every hour. The page does a simple SELECT. This is enough to keep the DB connection from ever dying. A hack, yes, but it works.
IOError: [Errno 32] Broken pipe
Make sure you have a WARNING level log handler set up in config/log.cfg
[logging]
[[handlers]]
[[[warning_out]]]
class='StreamHandler'
level='WARNING'
args='( sys.stdout,)'
On 10/5/06, pc <[EMAIL PROTECTED]> wrote:
Hi,
After few minutes of inactivity, if I try to request a page, I get an
exception 'MySQL server has gone away'.
I am also trying to deploy the same application in webfaction. Over
there, from time to time I get
Broken pipe exception. Here's the stack trace:
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 226,
in select
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 232,
in select_whereclause
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 305,
in _select_statement
File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 267,
in instances
File "build/bdist.linux-i686/egg/sqlalchemy/orm/session.py", line
114, in execute
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
246, in execute
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
270, in execute_clauseelement
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
286, in execute_compiled
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
282, in proxy
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
316, in _execute_raw
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
504, in log
File "build/bdist.linux-i686/egg/sqlalchemy/util.py", line 100, in
write
IOError: [Errno 32] Broken pipe
It's turbogears 1.0b1 and SQLAlchemy 0.2.8.
Does anyone have any hint?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/turbogears
-~----------~----~----~----~------~----~------~--~---
