Alert state is changing between OK → pending → alerting → OK whereas there is no change in the metrics data and also alert condition didn’t matched to true.
Change the alert state to pending only if the alert condition matched and fire alert if the condition is true for the evaluation period of 30 min.
Below is the alert condition:
Faced the same kind of issue in the past, but it resolved automatically without changing any configuration at datasource or grafana end but it reappears again.
Please let me know what logs/config is required and I will share that here.