# Problem generating alerts "msg=Alert Rule returned no data"

**URL:** <https://community.grafana.com/t/problem-generating-alerts-msg-alert-rule-returned-no-data/53029>\
**Category:** Elasticsearch\
**Tags:** alerting\
**Created:** [September 8, 2021, 1:07pm UTC](https://community.grafana.com/t/problem-generating-alerts-msg-alert-rule-returned-no-data/53029 "2021-09-08T13:07:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vinaykrish25aws](https://avatars.discourse-cdn.com/v4/letter/v/91b2a8/32.png) [@vinaykrish25aws](https://community.grafana.com/u/vinaykrish25aws)\
**Post date:** [September 8, 2021, 1:07pm UTC](https://community.grafana.com/t/problem-generating-alerts-msg-alert-rule-returned-no-data/53029/1 "2021-09-08T13:07:30Z")

</div>

Hi,

I am having troubles in creating Grafana alerts. Raising this topic here to get some help in identifying the issue.

Below are the details.

Grafana version: 7.5.9  
Data source: AWS Elasticsearch(Open Distro for Elasticsearch).  
Query:

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/5/6/561d76faab785094b1dfd106dbf8d867b8fadeb9.png)

Alert:

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/8/8/88ef01b1f0a5e71fa0a1e72d07af12cd49476f5c.png)

Test rule:  
{  
“firing”: false,  
“state”: “no\_data”,  
“conditionEvals”: “false = false”,  
“timeMs”: “46.340ms”,  
“logs”: [  
{  
“message”: “Condition[0]: Query”,  
“data”: {  
“from”: 1631105903722,  
“queries”: [  
{  
“refId”: “A”,  
“model”: {  
“alias”: “”,  
“bucketAggs”: [  
{  
“field”: “@timestamp”,  
“id”: “1”,  
“settings”: {  
“interval”: “1m”,  
“min\_doc\_count”: “1”  
},  
“type”: “date\_histogram”  
}  
],  
“format”: “table”,  
“metrics”: [  
{  
“field”: “response\_time\_ms”,  
“id”: “1”,  
“meta”: {  
“max”: true,  
“std\_deviation\_bounds\_lower”: false,  
“std\_deviation\_bounds\_upper”: false  
},  
“type”: “extended\_stats”  
}  
],  
“query”: “message.raw:"Request finished" AND app\_name.keyword:pharmacy-api”,  
“queryType”: “lucene”,  
“refId”: “A”,  
“timeField”: “@timestamp”  
},  
“datasource”: {  
“id”: 11,  
“name”: “Elasticsearch - health-prod”  
},  
“maxDataPoints”: 0,  
“intervalMs”: 0  
}  
],  
“to”: 1631106203722  
}  
},  
{  
“message”: “Condition[0]: Query Result”,  
“data”: {  
“fromDataframe”: true,  
“series”:   
}  
},  
{  
“message”: “Condition: Eval: false, Query Returned No Series (reduced to null/no value)”,  
“data”: null  
}  
]  
}

Debug log related to Alert:  
t=2021-09-08T12:55:40+0000 lvl=dbug msg=“Scheduler: Putting job on to exec queue” logger=alerting.scheduler name=“ **TestAlert alert** ” id=128  
t=2021-09-08T12:55:40+0000 lvl=info msg=“Alert Rule returned no data” logger=alerting.evalContext ruleId=126 name=“Pharmacy API response times alert” changing state to=no\_data  
t=2021-09-08T12:55:40+0000 lvl=info msg=“Alert Rule returned no data” logger=alerting.evalContext ruleId=128 name=“ **TestAlert alert** ” changing state to=no\_data  
t=2021-09-08T12:55:40+0000 lvl=info msg=“New state change” logger=alerting.resultHandler ruleId=128 newState=no\_data prev state=unknown  
t=2021-09-08T12:55:40+0000 lvl=info msg=“Database locked, sleeping then retrying” logger=sqlstore error=“database is locked” retry=0  
t=2021-09-08T12:55:40+0000 lvl=info msg=“Alert already updated” logger=alerting.resultHandler  
t=2021-09-08T12:55:40+0000 lvl=dbug msg=“Job Execution completed” logger=alerting.engine timeMs=56.802 alertId=128 name=“ **TestAlert alert** ” firing=false attemptID=1

I have tried multiple conditions as well like,  
query(A,1m,now-1m),  
query(A,1m,now-5m)  
I have upgraded to latest version as well but same issue then i reverted the version.

This same alert works perfect when i change the data source to dev index and fails when i change it back to point to prod index.

Please let me know if any further details are needed to provide support on this.

---

<div class="post-metadata">

**Author:** ![vinaykrish25aws](https://avatars.discourse-cdn.com/v4/letter/v/91b2a8/32.png) [@vinaykrish25aws](https://community.grafana.com/u/vinaykrish25aws)\
**Post date:** [September 13, 2021, 10:49am UTC](https://community.grafana.com/t/problem-generating-alerts-msg-alert-rule-returned-no-data/53029/2 "2021-09-13T10:49:51Z")

</div>

Reconfigured everything from scratch and it has worked.