[web2py] Scheduler error: Exception in thread Thread-1 and connection is closed

[kenny c]

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

-- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.