HI, I am not sure what causes this issue..
I am running Web2py with Postgresql, I am getting this exception in thread while running a scheduler. and I get InterfaceError("Connection is closed") .
I am wondering if Postgresql has timeout setting or scheduler timeout? (I made sure that timeout is long enough to handle all the jobs)
Any help would be appreciated. Thank you and please see the log below.
ERROR:web2py.scheduler.example#6580:Error retrieving status
Exception in thread Thread-1:
Traceback (most recent call last):
File "/usr/lib/python2.7/threading.py", line 810, in __bootstrap_inner
self.run()
File "/home/www-data/web2py/gluon/scheduler.py", line 442, in run
self.send_heartbeat(counter)
File "/home/www-data/web2py/gluon/scheduler.py", line 1041, in send_heartbeat
db.rollback()
File "/home/www-data/web2py/gluon/packages/dal/pydal/base.py", line 937, in rollback
self._adapter.rollback()
File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1332, in rollback
return self.connection.rollback()
File "/home/www-data/web2py/gluon/contrib/pg8000/core.py", line 1429, in rollback
self.execute(self._cursor, "rollback", None)
File "/home/www-data/web2py/gluon/contrib/pg8000/core.py", line 1622, in execute
raise InterfaceError("connection is closed")
InterfaceError: connection is closed
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/shell.py", line 271, in run
exec(python_code, _env)
File "<string>", line 1, in <module>
File "/home/www-data/web2py/gluon/scheduler.py", line 730, in loop
self.wrapped_report_task(task, self.async(task))
File "/home/www-data/web2py/gluon/scheduler.py", line 879, in wrapped_report_task
db.rollback()
File "/home/www-data/web2py/gluon/packages/dal/pydal/base.py", line 937, in rollback
self._adapter.rollback()
File "/home/www-data/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1332, in rollback
return self.connection.rollback()
File "/home/www-data/web2py/gluon/contrib/pg8000/core.py", line 1429, in rollback
self.execute(self._cursor, "rollback", None)
File "/home/www-data/web2py/gluon/contrib/pg8000/core.py", line 1622, in execute
raise InterfaceError("connection is closed")
InterfaceError: connection is closed