Mourya1319 commented on issue #58894: URL: https://github.com/apache/airflow/issues/58894#issuecomment-3644960288
Same issue here. Getting this error: ``` sqlalchemy.exc.ProgrammingError: (MySQLdb.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS idx_group_id ON ab_group_role (group_id)' at line 1") [SQL: CREATE INDEX IF NOT EXISTS idx_group_id ON ab_group_role (group_id)] (Background on this error at: https://sqlalche.me/e/14/f405) ``` The fab version we use: `apache-airflow-providers-fab==3.0.1` Should i manually run the sql queries in this below file to finish the migration and update the alembic version? `/airflow/providers/fab/migrations/versions/0001_1_4_0_create_ab_tables_if_missing.py` Also should i run `airflow db migrate` command again to check for any missing migrations? Or if i downgrade `apache-airflow-providers-fab` to `2.4.4` as @fsilberstein said, should i run migrate command again? Tagging @vinitpayal @meher1993 to confirm my next steps! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
