WARNING:apscheduler.scheduler:Error getting due jobs from job store 'sqlalchemy': columns argument to select() must be a Python list or other iterable

[AleksSpace]

I am trying to configure the scheduler so that it saves tasks to the DB.

`jobstores = {
'sqlalchemy': SQLAlchemyJobStore(url=SQLALCHEMY_DATABASE_URI),
}
executors = {
'default': {'type': 'threadpool', 'max_workers': 20},
'processpool': ProcessPoolExecutor(max_workers=10)
}
job_defaults = {
'coalesce': True,
'max_instances': 30
}

scheduler = BackgroundScheduler()
scheduler.configure(
jobstores=jobstores,
executors=executors,
job_defaults=job_defaults
)
`
but when I start, I get an error:
WARNING:apscheduler.scheduler:Error getting due jobs from job store 'sqlalchemy': columns argument to select() must be a Python list or other iterable.
please help me make everything work!

[agronholm]

APScheduler 3.x has not been adapted for use with SQLAlchemy 2. You should be able to get it working with 1.4.x. APScheduler 4 (still in alpha) does work with SQLAlchemy 2.

[AleksSpace]

a Flask-based application

[agronholm]

You could go farther back, to sqlalchemy 1.3. That at least should work.

[agronholm]

Why are the dependencies in that application not pinned? This is the exact kind of problem that occurs when not pinning dependencies to known good versions.

[AleksSpace]

sorry, I made a mistake, I have SQLAlchemy versions==1.3.20. and the error is still the same

[agronholm]

So which version of APScheduler did you try this with? I checked the latest 3.x release and I did in fact adapt it to use SQLAlchemy 1.4.x; it's even required in the dependencies for the sqlalchemy extra.

[AleksSpace]

I tried to install:
pip install git+https://github.com/agronholm/apscheduler.git
But there was an error:
ERROR: Command errored out with exit status 1:
command: 'd:\dev\job\test_pandas\venv\scripts\python.exe' 'd:\dev\job\test_pandas\venv\lib\site-packages\pip' install --ignore-installed --no-user --prefix 'C:\Users\Zaiki\AppData\Local\Temp\pip-build-env-jz15xfe1\overlay' --no-warn-script-location --no-binary :none: --only-binary :none:
-i https://pypi.org/simple -- 'setuptools >= 64' 'setuptools_scm >= 6.4'

[agronholm]

Was there no error message whatsoever?

[AleksSpace]

Sorry, I didn't see your message.

[AleksSpace]

Please tell me, does APScheduler 4 work stably with python version 3.11?

[agronholm]

It's still in alpha, so stability is not even implied. That said, it was tested from the start against Python 3.11. The only issues I can think of that could arise in some rare situations relate to AnyIO and task uncancellation which is a specific quirk of Python 3.11.

[AleksSpace]

So now the most stable version is 3.10.1? And it works well with python 3.11?

[agronholm]

I can only say that it gets automatically tested against Python 3.11 and passes. I haven't actually used it myself in a long time.