Gal40n04ek commented on issue #35914:
URL: https://github.com/apache/airflow/issues/35914#issuecomment-1849644007
Hello! I'm trying to run `airflow db downgrade==2.5.1` after upgrading the
image to 2.7.3 (as a step of possible rollback in case smth goes wrong) and get
similar Error of crashing Scheduler:
```
[2023-12-11T08:48:06.678+0000] {scheduler_job_runner.py:861} ERROR -
Exception when executing SchedulerJob._run_scheduler_loop
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line
736, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedColumn: column slot_pool.include_deferred does not
exist
LINE 1: SELECT slot_pool.pool, slot_pool.slots, slot_pool.include_de...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/usr/local/lib/python3.8/site-packages/airflow/jobs/scheduler_job_runner.py",
line 844, in _execute
self._run_scheduler_loop()
File
"/usr/local/lib/python3.8/site-packages/airflow/jobs/scheduler_job_runner.py",
line 976, in _run_scheduler_loop
num_queued_tis = self._do_scheduling(session)
File
"/usr/local/lib/python3.8/site-packages/airflow/jobs/scheduler_job_runner.py",
line 1089, in _do_scheduling
num_queued_tis =
self._critical_section_enqueue_task_instances(session=session)
File
"/usr/local/lib/python3.8/site-packages/airflow/jobs/scheduler_job_runner.py",
line 667, in _critical_section_enqueue_task_instances
queued_tis = self._executable_task_instances_to_queued(max_tis,
session=session)
File
"/usr/local/lib/python3.8/site-packages/airflow/jobs/scheduler_job_runner.py",
line 320, in _executable_task_instances_to_queued
pools = Pool.slots_stats(lock_rows=True, session=session)
File "/usr/local/lib/python3.8/site-packages/airflow/utils/session.py",
line 76, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.8/site-packages/airflow/models/pool.py", line
175, in slots_stats
pool_rows = session.execute(query)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/session.py",
line 1717, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1710, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py",
line 334, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1577, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1953, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 2134, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py",
line 211, in raise_
raise exception
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line
736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column
slot_pool.include_deferred does not exist
LINE 1: SELECT slot_pool.pool, slot_pool.slots, slot_pool.include_de...
^
[SQL: SELECT slot_pool.pool, slot_pool.slots, slot_pool.include_deferred
FROM slot_pool FOR UPDATE NOWAIT]
(Background on this error at: https://sqlalche.me/e/14/f405)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]