You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2021/01/25 22:42:56 UTC

[GitHub] [airflow] SamWheating commented on issue #13685: scheduler dies with "sqlalchemy.exc.IntegrityError: (MySQLdb._exceptions.IntegrityError) (1062, "Duplicate entry 'huge_demo13499411352-2021-01-15 01:04:00.000000' for key 'dag_run.dag_id'")"

SamWheating commented on issue #13685:
URL: https://github.com/apache/airflow/issues/13685#issuecomment-767161126


   I experienced the same issue today while upgrading Airflow from 1.10.14 -> 2.0. Upgrading `mysqlclient` from 1.3.x to 1.4.x didn't seem to help. 
   
   By manually deleting the rows in the dagrun table in question we were eventually able to get the scheduler to run reliably, however I would love to know more about what caused these issues (Also, dropping production data isn't a great solution in most cases 🙃 )


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