[GitHub] [airflow] spiremak edited a comment on issue #21291: Scheduled dag never runs

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

spiremak edited a comment on issue #21291:
URL: https://github.com/apache/airflow/issues/21291#issuecomment-1029816090


   I have created new dags today and this is what I see in the logs near time of creation 
   
   ```
   sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (MySQLdb._exceptions.IntegrityError) (1062, "Duplicate entry 'my_dag2' for key 'serialized_dag.PRIMARY'")
   [parameters: ('my_dag2', '/home/ec2-user/airflow/dags/spiremak_test.py', 70986863378950560, '{"__version": 1, "dag": {"edge_info": {}, "timezone": "UTC", "_task_group": {"_group_id": null, "prefix_group_id": true, "tooltip": "", "ui_color": " ... (800 characters truncated) ... Operator", "_task_module": "airflow.operators.bash", "_is_dummy": false, "bash_command": "echo \\"hello\\""}], "dag_dependencies": [], "params": {}}}', datetime.datetime(2022, 2, 4, 9, 42, 40, 154149), '13e704f28bd83ca69cd2969c9aa6c173')]
   ```
   and 
   ```
   sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (MySQLdb._exceptions.IntegrityError) (1062, "Duplicate entry 'my_dag3' for key 'dag.PRIMARY'")
   [parameters: ('my_dag3', None, 0, 0, 1, datetime.datetime(2022, 2, 4, 9, 47, 41, 672474), None, None, None, None, '/home/ec2-user/airflow/dags/another_test.py', 'airflow', None, 'graph', '"*/5 * * * *"', 9, 350, 0, 0, datetime.datetime(2022, 2, 4, 9, 40), datetime.datetime(2022, 2, 4, 9, 40), datetime.datetime(2022, 2, 4, 9, 45), datetime.datetime(2022, 2, 4, 9, 45))]
   ```
   However I don't see anything out of the ordinary in the logs after every 5 mins which is when I expect the dag to run


-- 
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: commits-unsubscribe@airflow.apache.org

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