Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Set jobstore_retry_interval #254

Open
Aidaho12 opened this issue Feb 14, 2025 · 0 comments
Open

Set jobstore_retry_interval #254

Aidaho12 opened this issue Feb 14, 2025 · 0 comments

Comments

@Aidaho12
Copy link

Aidaho12 commented Feb 14, 2025

Hello,

Is there way to set jobstore_retry_interval? I've found you that apscheduler thred stops working if there is any problem with job store.

And I would like to have the ability to reload thred without restart all flask process.

I get this error:

Feb 13 01:24:14 server scheduler[1443826]: Exception in thread APScheduler:
Feb 13 01:24:14 server scheduler[1443826]: Traceback (most recent call last):
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1144, in _commit_impl
Feb 13 01:24:14 server scheduler[1443826]:     self.engine.dialect.do_commit(self.connection)
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line 702, in do_commit
Feb 13 01:24:14 server scheduler[1443826]:     dbapi_connection.commit()
Feb 13 01:24:14 server scheduler[1443826]: sqlite3.OperationalError: disk I/O error
Feb 13 01:24:14 server scheduler[1443826]: The above exception was the direct cause of the following exception:
Feb 13 01:24:14 server scheduler[1443826]: Traceback (most recent call last):
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
Feb 13 01:24:14 server scheduler[1443826]:     self.run()
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/lib/python3.10/threading.py", line 953, in run
Feb 13 01:24:14 server scheduler[1443826]:     self._target(*self._args, **self._kwargs)
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/apscheduler/schedulers/blocking.py", line 30, in _main_loop
Feb 13 01:24:14 server scheduler[1443826]:     wait_seconds = self._process_jobs()
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/apscheduler/schedulers/base.py", line 1229, in _process_jobs
Feb 13 01:24:14 server scheduler[1443826]:     jobstore.update_job(job)
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/apscheduler/jobstores/sqlalchemy.py", line 138, in update_job
Feb 13 01:24:14 server scheduler[1443826]:     with self.engine.begin() as connection:
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/lib/python3.10/contextlib.py", line 142, in __exit__
Feb 13 01:24:14 server scheduler[1443826]:     next(self.gen)
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 3243, in begin
Feb 13 01:24:14 server scheduler[1443826]:     with conn.begin():
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/util.py", line 147, in __exit__
Feb 13 01:24:14 server scheduler[1443826]:     with util.safe_reraise():
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
Feb 13 01:24:14 server scheduler[1443826]:     raise exc_value.with_traceback(exc_tb)
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/util.py", line 145, in __exit__
Feb 13 01:24:14 server scheduler[1443826]:     self.commit()
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2631, in commit
Feb 13 01:24:14 server scheduler[1443826]:     self._do_commit()
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2736, in _do_commit
Feb 13 01:24:14 server scheduler[1443826]:     self._connection_commit_impl()
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2707, in _connection_commit_impl
Feb 13 01:24:14 server scheduler[1443826]:     self.connection._commit_impl()
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1146, in _commit_impl
Feb 13 01:24:14 server scheduler[1443826]:     self._handle_dbapi_exception(e, None, None, None, None)
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
Feb 13 01:24:14 server scheduler[1443826]:     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1144, in _commit_impl
Feb 13 01:24:14 server scheduler[1443826]:     self.engine.dialect.do_commit(self.connection)
Feb 13 01:24:14 server scheduler[1443826]:   File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line 702, in do_commit
Feb 13 01:24:14 server scheduler[1443826]:     dbapi_connection.commit()
Feb 13 01:24:14 server scheduler[1443826]: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) disk I/O error
Feb 13 01:24:14 server scheduler[1443826]: (Background on this error at: https://sqlalche.me/e/20/e3q8)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant