You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "obautista (via GitHub)" <gi...@apache.org> on 2023/02/24 15:11:24 UTC

[GitHub] [airflow] obautista opened a new issue, #29742: Dependency rule tried to blank-out primary key column 'serialized_dag.dag_id'

obautista opened a new issue, #29742:
URL: https://github.com/apache/airflow/issues/29742

   ### Apache Airflow version
   
   2.5.1
   
   ### What happened
   
   Just completed a fresh Airflow:
   - Airflow: v2.5.1
   - Ubuntu: v22.04
   - MySql:  Ver 8.0.32-0ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))
   
   I am setting up maintenance tasks using [](https://github.com/teamclairvoyant/airflow-maintenance-dagsl)
   
   Airflow is reporting "Dependency rule tried to blank-out primary key column 'serialized_dag.dag_id'" when running Clear Missing Dags ([](https://github.com/teamclairvoyant/airflow-maintenance-dags/blob/master/clear-missing-dags/airflow-clear-missing-dags.py)).
   
   Is there a way to resolve this?
    
   
   
   ### What you think should happen instead
   
   _No response_
   
   ### How to reproduce
   
   I am setting up maintenance tasks using [](https://github.com/teamclairvoyant/airflow-maintenance-dagsl)
   
   Airflow is reporting "Dependency rule tried to blank-out primary key column 'serialized_dag.dag_id'" when running Clear Missing Dags ([](https://github.com/teamclairvoyant/airflow-maintenance-dags/blob/master/clear-missing-dags/airflow-clear-missing-dags.py)).
   
   ### Operating System
   
   Ubuntu v22.04
   
   ### Versions of Apache Airflow Providers
   
   v2.5.1
   
   ### Deployment
   
   Other
   
   ### Deployment details
   
   _No response_
   
   ### Anything else
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
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.apache.org

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

[GitHub] [airflow] hussein-awala closed issue #29742: Dependency rule tried to blank-out primary key column 'serialized_dag.dag_id'

Posted by "hussein-awala (via GitHub)" <gi...@apache.org>.
hussein-awala closed issue #29742: Dependency rule tried to blank-out primary key column 'serialized_dag.dag_id'
URL: https://github.com/apache/airflow/issues/29742


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

[GitHub] [airflow] hussein-awala commented on issue #29742: Dependency rule tried to blank-out primary key column 'serialized_dag.dag_id'

Posted by "hussein-awala (via GitHub)" <gi...@apache.org>.
hussein-awala commented on issue #29742:
URL: https://github.com/apache/airflow/issues/29742#issuecomment-1444749197

   This error is not related to Airflow, for that I convert the issue to discussion.
   
   You are using code that has not been updated since August 2021, while we have made a lot of changes to Airflow DB and its schema since that date.
   
   I suggest using the internal API to delete the dags, for example using the method [delete_dag](https://github.com/apache/airflow/blob/671b88eb3423e86bb331eaf7829659080cbd184e/airflow/api/common/delete_dag.py#L37-L37). And if you want to delete the dags in batch query, you can override the method by replacing `models.TaskInstance.dag_id == dag_id` by `models.TaskInstance.dag_id.in_(list_dag_ids)`


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

[GitHub] [airflow] boring-cyborg[bot] commented on issue #29742: Dependency rule tried to blank-out primary key column 'serialized_dag.dag_id'

Posted by "boring-cyborg[bot] (via GitHub)" <gi...@apache.org>.
boring-cyborg[bot] commented on issue #29742:
URL: https://github.com/apache/airflow/issues/29742#issuecomment-1443825119

   Thanks for opening your first issue here! Be sure to follow the issue template!
   


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