Alerts state UNKNOWN in version 10

Issue Summary

Hi, I’m having issues sending alerts on Redash 10, upgraded from 8 to use custom templates as it is necessary.
No logs regarding for the alerts, and state is stuck in UNKNOWN.
I have followed all public discussions and nothing came up (not using any parameter)

Technical details:

  • Redash Version: 10.1.0.b50633
  • How did you install Redash: docker-compose, upgraded with your guide from 8.0.0

Did you apply the necessary database migrations?

[edit] Does this affect very query that has a schedule? What happens if you execute a query manually?

yes I have migrated everything successfully.
it happens with every query and even manually

Check your docker logs for the worker service. Do you see log messages of this format?

This should tell you whether or not alerts are event being checked.

worker_1     | [2022-06-07 14:36:56,068][PID:32][INFO][rq.job.redash.tasks.alerts] job.func_name=redash.tasks.alerts.check_alerts_for_query job.id=d0aeee7f-dff9-42f2-850e-26a7779c6324 Checking alert (1) of query 9.