I have the follwing setting and I create engine from config.
sqlalchemy.url : "mysql://sfdev:sf...@localhost:3306/sfdev"
sqlalchemy.pool_recycle : 3600
sqlalchemy.convert_unicode : true
I am getting the following error. Seems like recycle required, but I
have mentioned recycle in the configuration.
Any one guess what is wrong? I use Sqlalchemy 5.6.
[ERROR/MainProcess] Task iris.jobschedulertask[0df86366-
fab8-402d-851a-921bfebcb2e6] raised exception: (OperationalError)
(2006, 'MySQL server has gone away')
Traceback (most recent call last):
File "/home/krish/sf-env/lib/python2.6/site-packages/celery-0.8.2-
py2.6.egg/celery/execute.py", line 261, in execute
result = fun(*args, **kwargs)
File "/home/krish/sf-env/lib/python2.6/site-packages/celery-0.8.2-
py2.6.egg/celery/task/base.py", line 149, in __call__
return self.run(*args, **kwargs)
File "/home/krish/sf/iris/tasks/scheduler.py", line 18, in run
model.Task.scheduled < datetime.now())).all()
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/orm/query.py", line 1267, in all
return list(self)
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/orm/query.py", line 1361, in
__iter__
return self._execute_and_instances(context)
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/orm/query.py", line 1364, in
_execute_and_instances
result = self.session.execute(querycontext.statement,
params=self._params, mapper=self._mapper_zero_or_none())
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/orm/session.py", line 755, in
execute
clause, params or {})
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/engine/base.py", line 824, in
execute
return Connection.executors[c](self, object, multiparams, params)
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/engine/base.py", line 874, in
_execute_clauseelement
return self.__execute_context(context)
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/engine/base.py", line 896, in
__execute_context
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/engine/base.py", line 950, in
_cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor,
context)
File "/home/krish/sf-env/lib/python2.6/site-packages/
SQLAlchemy-0.5.6-py2.6.egg/sqlalchemy/engine/base.py", line 931, in
_handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
OperationalError: (OperationalError) (2006, 'MySQL server has gone
away')
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en.
