ashb commented on pull request #20975: URL: https://github.com/apache/airflow/pull/20975#issuecomment-1031482456
I'd call this fast enough: ``` airflow ❯ time AIRFLOW__CORE__SQL_ALCHEMY_CONN=postgresql:///airflow-xcom-migration 'airflow' db upgrade /home/ash/code/airflow/airflow/airflow/__main__.py:40 UserWarning: Python v3.10 is not official supported on this version of Airflow. Please be careful. For details, see: http://apache-airflow-docs.s3-website.eu-central-1.amazonaws.com/docs/apache-airflow/latest/installation/prerequisites.html DB: postgresql:///airflow-xcom-migration /home/ash/.virtualenvs/airflow/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/base.py:3571 SAWarning: Predicate of partial index idx_dag_run_queued_dags ignored during reflection /home/ash/.virtualenvs/airflow/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/base.py:3571 SAWarning: Predicate of partial index idx_dag_run_running_dags ignored during reflection [2022-02-07 13:38:38,811] 495269 MainProcess {{airflow.utils.db db.py:1021}} INFO - Creating tables INFO [alembic.runtime.migration] Context impl PostgresqlImpl. INFO [alembic.runtime.migration] Will assume transactional DDL. INFO [alembic.runtime.migration] Running upgrade e655c0453f75 -> c306b5b5ae4a, Switch XCom table to use ``run_id``. Upgrades done AIRFLOW__CORE__SQL_ALCHEMY_CONN=postgresql:///airflow-xcom-migration 'airflow 2.04s user 0.21s system 2% cpu 1:16.37 total airflow ❯ psql postgresql:///airflow-xcom-migration -c 'select count(*) from _airflow_moved__2_2__xcom;' count -------- 182921 (1 row) airflow ❯ psql postgresql:///airflow-xcom-migration -c 'select count(*) from xcom;' count --------- 9602070 (1 row) ``` -- 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]
