Taragolis commented on PR #29616: URL: https://github.com/apache/airflow/pull/29616#issuecomment-1437988917
Something new 😮 ```console airflow-scheduler_1 | airflow-scheduler_1 | BACKEND=redis airflow-scheduler_1 | DB_HOST=redis airflow-scheduler_1 | DB_PORT=6379 airflow-scheduler_1 | airflow-scheduler_1 | /home/airflow/.local/lib/python3.7/site-packages/airflow/models/base.py:49 MovedIn20Warning: Deprecated API features detected! These feature(s) are not compatible with SQLAlchemy 2.0. To prevent incompatible upgrades prior to updating applications, ensure requirements files are pinned to "sqlalchemy<2.0". Set environment variable SQLALCHEMY_WARN_20=1 to show all deprecation warnings. Set environment variable SQLALCHEMY_SILENCE_UBER_WARNING=1 to silence this message. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9) airflow-scheduler_1 | ____________ _____________ airflow-scheduler_1 | ____ |__( )_________ __/__ /________ __ airflow-scheduler_1 | ____ /| |_ /__ ___/_ /_ __ /_ __ \_ | /| / / airflow-scheduler_1 | ___ ___ | / _ / _ __/ _ / / /_/ /_ |/ |/ / airflow-scheduler_1 | _/_/ |_/_/ /_/ /_/ /_/ \____/____/|__/ airflow-scheduler_1 | [2023-02-21T07:28:42.954+0000] {executor_loader.py:114} INFO - Loaded executor: CeleryExecutor airflow-scheduler_1 | [2023-02-21T07:28:43.045+0000] {scheduler_job.py:724} INFO - Starting the scheduler airflow-scheduler_1 | [2023-02-21T07:28:43.054+0000] {scheduler_job.py:731} INFO - Processing each file at most -1 times airflow-scheduler_1 | [2023-02-21T07:28:43.061+0000] {manager.py:164} INFO - Launched DagFileProcessorManager with pid: 32 airflow-scheduler_1 | [2023-02-21T07:28:43.071+0000] {scheduler_job.py:1437} INFO - Resetting orphaned tasks for active dag runs airflow-scheduler_1 | [2023-02-21T07:28:43.080+0000] {settings.py:61} INFO - Configured default timezone Timezone('UTC') airflow-scheduler_1 | [2023-02-21T07:28:46.099+0000] {scheduler_job.py:788} ERROR - Exception when executing SchedulerJob._run_scheduler_loop airflow-scheduler_1 | Traceback (most recent call last): airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/airflow/jobs/scheduler_job.py", line 771, in _execute airflow-scheduler_1 | self._run_scheduler_loop() airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/airflow/jobs/scheduler_job.py", line 899, in _run_scheduler_loop airflow-scheduler_1 | num_queued_tis = self._do_scheduling(session) airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/airflow/jobs/scheduler_job.py", line 1006, in _do_scheduling airflow-scheduler_1 | num_queued_tis = self._critical_section_enqueue_task_instances(session=session) airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/airflow/jobs/scheduler_job.py", line 589, in _critical_section_enqueue_task_instances airflow-scheduler_1 | queued_tis = self._executable_task_instances_to_queued(max_tis, session=session) airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/airflow/jobs/scheduler_job.py", line 280, in _executable_task_instances_to_queued airflow-scheduler_1 | pools = Pool.slots_stats(lock_rows=True, session=session) airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/airflow/utils/session.py", line 73, in wrapper airflow-scheduler_1 | return func(*args, **kwargs) airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/airflow/models/pool.py", line 174, in slots_stats airflow-scheduler_1 | .group_by(TaskInstance.pool, TaskInstance.state) airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2773, in all airflow-scheduler_1 | return self._iter().all() airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/sqlalchemy/engine/result.py", line 1129, in all airflow-scheduler_1 | return self._allrows() airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/sqlalchemy/engine/result.py", line 401, in _allrows airflow-scheduler_1 | rows = self._fetchall_impl() airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/sqlalchemy/engine/result.py", line 1813, in _fetchall_impl airflow-scheduler_1 | return list(self.iterator) airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/sqlalchemy/orm/loading.py", line 147, in chunks airflow-scheduler_1 | fetch = cursor._raw_all_rows() airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/sqlalchemy/engine/result.py", line 393, in _raw_all_rows airflow-scheduler_1 | return [make_row(row) for row in rows] airflow-scheduler_1 | File "/home/airflow/.local/lib/python3.7/site-packages/sqlalchemy/engine/result.py", line 393, in <listcomp> airflow-scheduler_1 | return [make_row(row) for row in rows] airflow-scheduler_1 | RuntimeError: number of values in row (1) differ from number of column processors (3) airflow-scheduler_1 | [2023-02-21T07:28:47.137+0000] {process_utils.py:133} INFO - Sending Signals.SIGTERM to group 32. PIDs of all processes in the group: [44, 45, 32] airflow-scheduler_1 | [2023-02-21T07:28:47.138+0000] {process_utils.py:84} INFO - Sending the signal Signals.SIGTERM to group 32 airflow-scheduler_1 | [2023-02-21T07:28:49.462+0000] {process_utils.py:79} INFO - Process psutil.Process(pid=44, status='terminated', started='07:28:45') (44) terminated with exit code None airflow-scheduler_1 | [2023-02-21T07:28:49.471+0000] {process_utils.py:256} INFO - Waiting up to 5 seconds for processes to exit... airflow-scheduler_1 | [2023-02-21T07:28:49.482+0000] {process_utils.py:256} INFO - Waiting up to 5 seconds for processes to exit... airflow-scheduler_1 | [2023-02-21T07:28:49.494+0000] {process_utils.py:79} INFO - Process psutil.Process(pid=45, status='terminated', started='07:28:46') (45) terminated with exit code None airflow-scheduler_1 | [2023-02-21T07:28:49.500+0000] {process_utils.py:79} INFO - Process psutil.Process(pid=32, status='terminated', exitcode=0, started='07:28:42') (32) terminated with exit code 0 airflow-scheduler_1 | [2023-02-21T07:28:49.500+0000] {scheduler_job.py:[800](https://github.com/apache/airflow/actions/runs/4229748945/jobs/7347366817#step:5:802)} INFO - Exited execute loop ``` -- 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: commits-unsubscr...@airflow.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org