The GitHub Actions job "Tests" on airflow.git/sqlite2-10-to-3-upgrade has
failed.
Run started by GitHub user ashb (triggered by ashb).
Head commit for run:
85bf5524f5c7e72a956f0e5fe8f55362c68a1909 / Ash Berlin-Taylor <a...@apache.org>
Fix DB migrations from 2.10.5 to 3.0.0 for SQlite
Through some means I haven't been able to uncover, the FKs we end up with
when upgrading a DB from 2.10.5 are duplicated:
```
CONSTRAINT ds_dsa_alias_id FOREIGN KEY(alias_id) REFERENCES
dataset_alias (id) ON DELETE CASCADE,
CONSTRAINT ds_dsa_dataset_id FOREIGN KEY(dataset_id) REFERENCES dataset
(id) ON DELETE CASCADE,
CONSTRAINT dataset_alias_dataset_alias_id_fkey FOREIGN KEY(alias_id)
REFERENCES dataset_alias (id) ON DELETE CASCADE,
CONSTRAINT dataset_alias_dataset_dataset_id_fkey FOREIGN
KEY(dataset_id) REFERENCES dataset (id) ON DELETE CASCADE
```
SQLite doesn't even officially have `DROP CONSTRAINT`, let alone an `IF
EXISTS` modifier on it, but with a little bit of work we can make it work with
the tools Alembic gives us.
Report URL: https://github.com/apache/airflow/actions/runs/14480057455
With regards,
GitHub Actions via GitBox
---------------------------------------------------------------------
To unsubscribe, e-mail: jobs-unsubscr...@airflow.apache.org
For additional commands, e-mail: jobs-h...@airflow.apache.org
