[GitHub] [airflow] kaxil commented on a change in pull request #9067: Make conn_id unique in Connections table

[GitBox <gi...@apache.org>]

kaxil commented on a change in pull request #9067:
URL: https://github.com/apache/airflow/pull/9067#discussion_r464053787



##########
File path: UPDATING.md
##########
@@ -322,6 +322,14 @@ We should default it as `true` to avoid confusion
 In order to migrate the database, you should use the command `airflow db upgrade`, but in
 some cases manual steps are required.
 
+#### Unique conn_id in connection table
+
+Previously, Airflow allowed users to add more than one connection with the same `conn_id` and on access it would choose one connection randomly. This acted as a basic load balancing and fault tolerance technique, when used in conjunction with retries.
+
+This behavior caused some confusion for users, and there was no clear evidence if it actually worked well or not.
+
+Now the `conn_id` will be unique. If you already have duplicates your metadata database, you will have to manage those duplicate connections before upgrading the database.

Review comment:
       ```suggestion
   Now the `conn_id` will be unique. If you already have duplicates in your metadata database, you will have to manage those duplicate connections before upgrading the database.
   ```




----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org