prabhusneha commented on issue #43690: URL: https://github.com/apache/airflow/issues/43690#issuecomment-2462274476
I couldn't reproduce the issue either. Attaching some screenshots and descriptions on how I tried to reproduce it.  1. As seen in the above image, started with airflow version 2.9.2. MySQL backend version 8.0.40. 2. Ran a sample DAG multiple times to populate some metadata. 3. Executed `airflow db downgrade --to-version=2.8.2 --yes` Revision id applied is 88344c1d9134 and downgrade completed successfully. 4. Upgraded successfully using `airflow db migrate` After the upgrade and downgrade, I checked a few things in the database (see image below): The unique key on the connection table is named connection_conn_id_uq. When I ran the query that caused the error mentioned in this issue, it executed without any errors.The query output is also shown in the image. <img width="699" alt="image" src="https://github.com/user-attachments/assets/cb3adcce-e396-489b-931c-d86e09c6d60a";> -- 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]
