[ 
https://issues.apache.org/jira/browse/AIRFLOW-5500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17091810#comment-17091810
 ] 

ASF GitHub Bot commented on AIRFLOW-5500:
-----------------------------------------

samdjstephens commented on pull request #8081:
URL: https://github.com/apache/airflow/pull/8081#issuecomment-619169385


   I've run into this issue too.. Looking at places `DAG.subdags` is called:
   - set_is_paused
   - DagBag
   
   Clearly DAG.subdags was intended to return all subdags and nested subdags, 
so I think fixing trigger_dag to respect that behaviour is the right way to go


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


> Bug in trigger api endpoint 
> ----------------------------
>
>                 Key: AIRFLOW-5500
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-5500
>             Project: Apache Airflow
>          Issue Type: Bug
>          Components: api
>    Affects Versions: 1.10.1
>            Reporter: Deavarajegowda M T
>            Priority: Critical
>         Attachments: 3level.py
>
>
> Unable to trigger workflow with nested sub dags, getting following error:
>  sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) duplicate key value 
> (dag_id,execution_date)=('dummy.task1.task_level1.task_level2','2019-09-10 
> 13:00:27+00:00') violates unique constraint 
> "dag_run_dag_id_execution_date_key"
>  trigger_dag for nested sub_dags is called twice.
>  
> fix:
> in airflow/api/common/experimental/trigger_dag.py -
> while populating subdags for a dag, each subdag's subdags is also populated 
> to main dag.
> So no need to repopulate subdags for each subdag separately.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to