Alerts on InfluxDB

[jasonmallory]

Trying to get an answer for this:

summary: Replication is {{ $value.B }} seconds behind {{ $labels.host }}

Value doesn’t show the value for B even though it shows at the top. Labels does not show the column host. Can someone PLEASE help with this? This is deciding whether we go with Grafana or stick with Nagios that works!

Query:

SELECT host, slave_Seconds_Behind_Master FROM “mysql” where slave_Seconds_Behind_Master > 600

I have tried with and without host. I need to get this working and I never get a response for this

[jasonmallory]

Anyone have any suggestions?

[jasonmallory]

Any suggestions yet?

[georgerobinson]

Hi! Can we see a screenshot of the alert rule definition with the “Preview” button is clicked?

[jasonmallory]

Here’s one of them. This is without host in the query:

[grant2]

I could be wrong, but I think @georgerobinson was asking for this screen:

[jasonmallory]

How do I pull that info up?

[georgerobinson]

The Preview button can be found on the page where you add / edit alert rules:

[jasonmallory]

This is what I have:

[georgerobinson]

Can you click the Preview button and send the screenshot again? Also, your query D, Reduce expression E and Threshold expression F don’t do anything so you can delete them, unless you want to keep them for your tests.

[jasonmallory]

Running two queries to check for SQL and IO threads:

[georgerobinson]

OK! I’m not sure if you know but your check for slave_Slave_IO_Running doesn’t work as D is not used in the alert condition. E and F don’t do anything either.

To answer the question about $labels it looks neither of the queries in A or D return labels - just the last row of the slave_Slave_SQL_Running and slave_Slave_IO_Running columns.

If you change your query back to SELECT host, slave_Seconds_Behind_Master FROM “mysql” where slave_Seconds_Behind_Master > 600 and then click Preview what do you see?

[jasonmallory]

Sorry for the long delay. Here is what I did in Grafana:

This is what I ran in Influx:

I expect to see the same in Grafana but I don’t

[jasonmallory]

When I do my original query I posted, SELECT host, slave_Seconds_Behind_Master FROM mysql where slave_Seconds_Behind_Master > 600, it shows the host in Explore but doesn’t show the same in alerting.