FAB migration failing for existing relationships during Alter Table

[meher1993]

Apache Airflow Provider(s)

fab

Versions of Apache Airflow Providers

apache-airflow-providers-fab==2.4.3

Apache Airflow version

3.1.0

Operating System

Debian GNU/Linux 12 (bookworm)

Deployment

Official Apache Airflow Helm Chart

Deployment details

Helm official chart 1.18.0 on AKS moving airflow app version from 2.10.4 to 3.1.0.

What happened

This is an extension of #55856

I'm upgrading an Airflow instance from 2.10.4 to 3.1.0 while setting auth_manager = airflow.providers.fab.auth_manager.fab_auth_manager.FabAuthManager as detailed in the migration guide.

During the deployment, the airflow-run-airflow-migrations container is errors out with the following. As a result, the migration doesn't complete and the waitformigrations init container will keep waiting preventing the pods from coming up.

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.DuplicateTable) relation "idx_group_id" already exists
[SQL: CREATE INDEX idx_group_id ON ab_group_role (group_id)]
(Background on this error at: https://sqlalche.me/e/14/f405)`

What you think should happen instead

For all existing indexes, the migration should finish successfully.

How to reproduce

Upgrade an existing airflow 2.10.x version with FabAuthManager to 3.1.0

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.