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]

Reply via email to