Hi folks,
I posted a while ago about this problem and now came back to it again.
I am running a webapp, using TG1.0.8 with SQLAlchemy 0.4.8 on python2.5
After some hours of idle time, the first attempt to use the app results
in the Operational Error 'MySQL server has gone away'. After hitting
the reload button, the problem is gone, but it sucks a little ;)
I have created two bare TG Projects one with SQLAlchemy the other with
Alchemy+Elixir. I get the error both times.
Does anybody have an idea?
Thanks in advance,
Nicolas
2009-01-06 19:39:24,083 cherrypy.msg INFO HTTP: Traceback (most recent
call last):
File
"/usr/lib/python2.5/site-packages/CherryPy-2.3.0-py2.5.egg/cherrypy/_cphttptools.py",
line 119, in _run
applyFilters('before_main')
File
"/usr/lib/python2.5/site-packages/CherryPy-2.3.0-py2.5.egg/cherrypy/filters/__init__.py",
line 151, in applyFilters
method()
File
"/usr/lib/python2.5/site-packages/TurboGears-1.0.7-py2.5.egg/turbogears/visit/api.py",
line 233, in before_main
visit = _manager.new_visit_with_key(visit_key)
File
"/usr/lib/python2.5/site-packages/TurboGears-1.0.7-py2.5.egg/turbogears/visit/savisit.py",
line 47, in new_visit_with_key
session.flush()
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/orm/scoping.py",
line 98, in do
return getattr(self.registry(), name)(*args, **kwargs)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/orm/session.py",
line 789, in flush
self.uow.flush(self, objects)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/orm/unitofwork.py",
line 237, in flush
flush_context.execute()
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/orm/unitofwork.py",
line 449, in execute
UOWExecutor().execute(self, tasks)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/orm/unitofwork.py",
line 934, in execute
self.execute_save_steps(trans, task)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/orm/unitofwork.py",
line 949, in execute_save_steps
self.save_objects(trans, task)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/orm/unitofwork.py",
line 940, in save_objects
task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/orm/mapper.py",
line 1161, in _save_obj
c = connection.execute(statement.values(value_params), params)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/engine/base.py",
line 844, in execute
return Connection.executors[c](self, object, multiparams, params)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/engine/base.py",
line 895, in execute_clauseelement return
self._execute_compiled(elem.compile(dialect=self.dialect,
column_keys=keys, inline=len(params) > 1), distilled_params=params)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/engine/base.py",
line 907, in _execute_compiled
self.__execute_raw(context)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/engine/base.py",
line 916, in __execute_raw
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/engine/base.py",
line 960, in _cursor_execute self._handle_dbapi_exception(e,
statement, parameters, cursor)
File
"/usr/lib/python2.5/site-packages/SQLAlchemy-0.4.8-py2.5.egg/sqlalchemy/engine/base.py",
line 942, in _handle_dbapi_exception raise
exceptions.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
OperationalError: (OperationalError) (2006, 'MySQL server has gone
away') u'INSERT INTO visit (visit_key, created, expiry) VALUES (%s, %s,
%s)' ['9867505564ef9ad10d5bb03f200e789471b413c5',
datetime.datetime(2009, 1, 6, 19, 39, 24, 78107),
datetime.datetime(2009, 1, 6, 19, 59, 24, 78107)]
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
