The GitHub Actions job "Tests (AMD)" on 
airflow.git/fix-db-clean-dag-version-fk-pinned-66177 has failed.
Run started by GitHub user ephraimbuddy (triggered by ephraimbuddy).

Head commit for run:
5a530213f4f7811bde0257b5aabc003e39f753bd / Ephraim Anierobi 
<[email protected]>
Skip FK-referenced dag_version rows during db clean

airflow db clean on the dag_version table selected old, non-latest
versions for deletion regardless of whether they were still referenced.
Because task_instance.dag_version_id is ON DELETE RESTRICT, deleting a
version still referenced by a task instance fails the foreign key, so
the command could not prune dag_version at all for any DAG with history.

Add a generic skip_if_referenced option to the cleanup table config that
excludes rows still referenced by a given (table, fk_column) via a
correlated NOT EXISTS, and apply it to dag_version for
task_instance.dag_version_id. Cleanup now prunes only orphaned older
versions and makes progress as task instances age out and are cleaned.

related: #66177

Report URL: https://github.com/apache/airflow/actions/runs/27282868798

With regards,
GitHub Actions via GitBox


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to