deferrable FileSensor alway get stuck

Apache Airflow version

Other Airflow 2 version (please specify below)

If "Other Airflow 2 version" selected, which one?

2.9.1

What happened?

when i use FileSensor and set deferrable=True，i got the warning, “The triggers does not appear to be running. Triggers will not run, and any deferred operator will remian deferred until it times out and fails”, and the task looks stuck. But everything is good when i set deferrable =False.

I am not sure if this is a bug or I mis-config anything. My python version is 3.8.10 with airflow 2.9.1 using a mysql as a dataset backend on ubuntu 20.04. And code almost running on gpfs file system. I don‘t know whether it doesn't support deferrable operators and cause all of this.

My test code is really simple here.

with DAG("dev_test", schedule=None) as dag:
      FileSensor(task_id = "test", filepath=“/home/ubuntu/test.airflow”, deferrable=True, poke_interval=30, timeout=300,

The only warning message i can find is

WARNING - empty cryptography key - values will not be stored encrypted.

by the way, airflow db clean also doesn't work for me with a warning below, i have to delete the trigger table mannual in sql.

WARNING - Encountered error when attempting to clean table 'trigger'

What you think should happen instead?

No response

How to reproduce

with DAG("dev_test", schedule=None) as dag:
      FileSensor(task_id = "test", filepath=“/home/ubuntu/test.airflow”, deferrable=True, poke_interval=30, timeout=300,

And trigger it mannually.

Operating System

ubuntu 20.04

Versions of Apache Airflow Providers

No response

Deployment

Official Apache Airflow Helm Chart

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

apache / airflow