No, there's nothing in there for now - just wanted to catch the right place.
Is there a straight-forward way to reconnect? As mentioned, it's dropping out with no activity other than the scheduler heartbeat running and once it drops out, it stays dropped out so the whole app is effectively unworkable at the moment. Thanks in advance Ian On Tuesday, February 3, 2015 at 6:27:04 AM UTC+11, Massimo Di Pierro wrote: > > Did you put any dal query in a try... except? I am recently seeing people > do this a lot and it very wrong. > > On Monday, 2 February 2015 05:09:47 UTC-6, Ian Ryder wrote: >> >> Hi, I've got a showstopper running scheduler on pythonanywhere - every >> few hours it drops out with: >> >> Traceback (most recent call last): File "/web2py/gluon/shell.py", >> line 272, in run exec(python_code, _env) File "<string>", line 1, in >> <module> File "/web2py/gluon/scheduler.py", >> line 719, in loop self.wrapped_report_task(task, self.async(task)) File >> "/web2py/gluon/scheduler.py", >> line 868, in wrapped_report_task db.rollback() File >> "/web2py/gluon/dal.py", >> line 8555, in rollback self._adapter.rollback() File >> "/web2py/gluon/dal.py", >> line 1922, in rollback return self.connection.rollback() >> OperationalError: (2006, 'MySQL server has gone away') >> >> I can trap the error scheduler.py but I'm not sure how to reinitiate the >> connection - this error only seems to come from this process and it will >> happen even if it's not being used. Everything else seems to work fine. >> >> Any help on how to handle and reconnect gracefully appreciated. >> >> Thanks >> Ian >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
