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 sqlalch...@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.