spiremak commented 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 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to