The GitHub Actions job "Tests" on airflow.git/fix/db-clean-dag-version-fK-61390 
has failed.
Run started by GitHub user Arunodoy18 (triggered by Arunodoy18).

Head commit for run:
fa51ede637e5472218e65991fa816f78ee489054 / Arunodoy18 <[email protected]>
Fix cross-dialect compatibility in dag_version cleanup query

Replace UNION subquery with multiple NOT IN conditions for better
cross-dialect compatibility. The UNION approach was failing in CI
across MySQL, Postgres, SQLite, and low dependency environments.

Issue: SQLAlchemy's handling of UNION within NOT IN subqueries is
inconsistent across dialects and versions.

Solution: Use two separate NOT IN conditions (one for task_instance,
one for dag_run) following the pattern used in scheduler_job_runner.py
for _remove_unreferenced_triggers.

This pattern is proven to work across all Airflow-supported databases
and SQLAlchemy versions.

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

With regards,
GitHub Actions via GitBox


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

Reply via email to