CODEWITHSUNDEEP
influxdbgrafana
Tineler
Tineler

Reputation: 253

Grafana alert always gives no_data

I'm trying to set an alert in Grafana as soon as the value is outside the range 16 to 36. I'm using influxDB

I have a simple query (A): 

SELECT "value" FROM "temp"

The graph is shown correctly.

My alert config looks like this: WHEN last() OF query(A, 1s, now) IS OUTSIDE RANGE 16 TO 36

But if I evaluate the Test Rule, I always get the state no_data. What am I doing wrong?

Upvotes: 2

Views: 4127

Answers (1)

João Soares
João Soares

Reputation: 59

Well.. 3 years later.. =)

I had this same problem. To fix this, go to your Influx server and type:

use <databasename>
show field keys

The command "show field keys" will return something like this:

name: table_name
fieldKey fieldType
-------- ---------
value    string

The problem is the column fieldType need to be float and not string. In my case, I dropped the database and created it again. And I inserted as decimal.

Upvotes: 3

Related Questions