The GitHub Actions job "Tests" on airflow.git has failed.
Run started by GitHub user romsharon98 (triggered by romsharon98).

Head commit for run:
72947cb09854f00d347b7c9cd09eb9ac89c75480 / Wei Lee <[email protected]>
This PR resolves an SQLAlchemy warning in the migration by correctly setting 
the `alias_id` column as part of the primary key in the 
`dag_schedule_dataset_alias_reference` table. Previously, only dag_id was 
marked as the primary key, causing a mismatch with the local definition, which 
triggered an SAWarning. (#43425)

Example: 
https://github.com/apache/airflow/actions/runs/11526187767/job/32090094094?pr=43243#step:6:745

When running a migration you see this. It was missed in 
https://github.com/apache/airflow/pull/41264:
```
/opt/airflow/airflow/migrations/versions/0026_2_10_0_dag_schedule_dataset_alias_reference.py:46
 SAWarning:
Table 'dag_schedule_dataset_alias_reference' specifies columns 'dag_id' as 
primary_key=True, not matching locally specified columns 'alias_id', 'dag_id'; 
setting the current primary key columns to 'alias_id', 'dag_id'.
This warning may become an exception in a future release
```

It is already a primary key in models:

https://github.com/apache/airflow/blob/e9192f5db32e453f150c73ad31287d4953e3c43d/airflow/models/asset.py#L290-L291

Kaxil verified that both columns are marked as primary keys already in 2.10.

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

With regards,
GitHub Actions via GitBox


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

Reply via email to