Airflow 2.0 - duplicate key value violates unique constraint "ab_view_menu_name_key" .. Key (name)=(DAG:xxx) already exists

user_14444816 0
Viewed 1036

I'm upgrading to airflow 2.0, and I'm this error, I'm wondering if anyone else has come across this. (also this happened when after trying to run 'airflow db upgrade':

sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates 
unique constraint "ab_view_menu_name_key"

/ecs/ds-airflow/dev  DETAIL:  Key (name)=(DAG:vl2_daily) already exists.

ecs/ds-airflow/dev  [SQL: UPDATE ab_view_menu SET name=(%(name_1)s || ab_view_menu.name) 
WHERE ab_view_menu.id IN (%(id_1)s, %(id_2)s, %(id_3)s, %(id_4)s, %(id_5)s, %(id_6)s, 
%(id_7)s, %(id_8)s, %(id_9)s, %(id_10)s, %(id_11)s]

/ecs/ds-airflow/dev  [parameters: {'name_1': 'DAG:', 'id_1': 57, 'id_2': 58, 'id_3': 59, 
'id_4': 60, 'id_5': 61, 'id_6': 62, 'id_7': 63, 'id_8': 64]

ecs/ds-airflow/dev  (Background on this error at: http://sqlalche.me/e/13/gkpj)
airflow
1 Answers

You will have to remove the record from DB manually using the following SQL:

DELETE FROM ab_view_menu WHERE name = 'DAG:vl2_daily';
user_56915250
Related