There was an issue but should be fixed now. https://github.com/web2py/web2py/issues/1999
Il giorno lun 19 giu 2023 alle ore 20:57 Lisandro < rostagnolisan...@gmail.com> ha scritto: > I've recently upgraded to web2py Version > 2.24.1-stable+timestamp.2023.03.23.05.07.17 > It's running on python 3.9.14, Rocky Linux RHEL9, using PostgreSQL 15.2 > for database. > > Since I did the upgrade, the scheduler fails from time to time with this > traceback: > > ERROR:web2py.scheduler.main#1531711: error storing result > Traceback (most recent call last): > File "/var/www/medios/gluon/scheduler.py", line 1077, in > wrapped_report_task > self.report_task(task, task_report) > File "/var/www/medios/gluon/scheduler.py", line 1101, in report_task > db(sr.id == task.run_id).update( > File "/var/www/medios/gluon/packages/dal/pydal/objects.py", line 2789, > in update > ret = db._adapter.update(table, self.query, row.op_values()) > File "/var/www/medios/gluon/packages/dal/pydal/adapters/base.py", line > 586, in update > raise e > File "/var/www/medios/gluon/packages/dal/pydal/adapters/base.py", line > 581, in update > self.execute(sql) > File "/var/www/medios/gluon/packages/dal/pydal/adapters/__init__.py", > line 69, in wrap > return f(*args, **kwargs) > File "/var/www/medios/gluon/packages/dal/pydal/adapters/base.py", line > 468, in execute > rv = self.cursor.execute(command, *args[1:], **kwargs) > psycopg2.OperationalError: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > Traceback (most recent call last): > File "/var/www/medios/gluon/scheduler.py", line 1077, in > wrapped_report_task > self.report_task(task, task_report) > File "/var/www/medios/gluon/scheduler.py", line 1101, in report_task > db(sr.id == task.run_id).update( > File "/var/www/medios/gluon/packages/dal/pydal/objects.py", line 2789, > in update > ret = db._adapter.update(table, self.query, row.op_values()) > File "/var/www/medios/gluon/packages/dal/pydal/adapters/base.py", line > 586, in update > raise e > File "/var/www/medios/gluon/packages/dal/pydal/adapters/base.py", line > 581, in update > self.execute(sql) > File "/var/www/medios/gluon/packages/dal/pydal/adapters/__init__.py", > line 69, in wrap > return f(*args, **kwargs) > File "/var/www/medios/gluon/packages/dal/pydal/adapters/base.py", line > 468, in execute > rv = self.cursor.execute(command, *args[1:], **kwargs) > psycopg2.OperationalError: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > During handling of the above exception, another exception occurred: > Traceback (most recent call last): > File "/var/www/medios/gluon/shell.py", line 321, in run > exec(python_code, _env) > File "<string>", line 1, in <module> > File "/var/www/medios/gluon/scheduler.py", line 949, in loop > self.wrapped_report_task(task, self.execute(task)) > File "/var/www/medios/gluon/scheduler.py", line 1082, in > wrapped_report_task > db.rollback() > File "/var/www/medios/gluon/packages/dal/pydal/base.py", line 825, in > rollback > self._adapter.rollback() > File "/var/www/medios/gluon/packages/dal/pydal/adapters/__init__.py", > line 57, in wrap > return f(*args, **kwargs) > File "/var/www/medios/gluon/packages/dal/pydal/adapters/base.py", line > 1012, in rollback > return self.connection.rollback() > psycopg2.InterfaceError: connection already closed > > > I've checked PostgreSQL logs but there is no error or apparent problem at > the time scheduler fails. The database instance has several databases and > no error log is reported, everything runs smoothly. It's just the scheduler > that reports that error (and after it, it doesn't run anymore). Where else > should I look? > > Any help will be much appreciated. > Warm regards, > Lisandro > > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/9ffdc6f1-8448-4784-a344-7f176545e9d9n%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/9ffdc6f1-8448-4784-a344-7f176545e9d9n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Massimiliano -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CANPTPx%2BtgFzVN61uXEWyz9J3mFz2%3DEcFpgPgnP1F%3DS73gqkfmg%40mail.gmail.com.