Greetlist opened a new issue #21005: URL: https://github.com/apache/airflow/issues/21005
### Apache Airflow version 2.2.1 ### What happened When a Deferrable Task which is cleared or generated. This Trigger's TriggererId is NULL,and never change, which cause this trigger is never init and run by triggerer process. ### What you expected to happen When a Deferrable Task is generated, It will init and run correctly. ### How to reproduce Clear a Deferrable Task. I add some log to source code and find out the reason of this problem:  First Query: ``` is None ``` has a strange behavior, It does not work. Second Query: when the trigerer_id has a NULL value in database, it can not query correctly. I fix both problem by:  ### Operating System Ubuntu 16.04 ### Versions of Apache Airflow Providers _No response_ ### Deployment Other ### Deployment details 1.One Triggerer Process 2. Three Scheduler 3. Pecona Mysql 8.0 ### Anything else _No response_ ### Are you willing to submit PR? - [X] 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
