"breeze start-airflow" failing on main branch

[shubhamraj-git]

Apache Airflow version

main (development)

If "Other Airflow 2 version" selected, which one?

No response

What happened?

"breeze start-airflow" is failing for main branch

INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 3a8972ecb8f9 -> 05234396c6fc, Rename dataset as asset.
Traceback (most recent call last):
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
    self.dialect.do_execute(
  File "/usr/local/lib/python3.12/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.UndefinedObject: constraint "dsdar_dataset_fkey" of relation "dag_schedule_asset_alias_reference" does not exist


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/bin/airflow", line 8, in <module>
    sys.exit(main())
             ^^^^^^

Seems some issue with migrating from datasets to assets

What you think should happen instead?

This PR could be a possible problem #42023
Reverting this fix is fixing the issue.

How to reproduce

1. Checkout main branch
2. Run breeze start-airflow

Operating System

MacOS

Versions of Apache Airflow Providers

No response

Deployment

Official Apache Airflow Helm Chart

Deployment details

No response

Anything else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

[bbovenzi]

Cc : @Lee-W @uranusjr looks like we missed something in the dataset - asset migration