Alert still running, dashboard deleted

Grafana
1

Grafana version: 5.0.0
Datasource: InfluxDB

few days ago I setup up an dashboard with alert, just for testing, then I deleted the dashboard before I deleted the Alert, now it seems that the alert is running all the time.
Where can I check what “ruleId” belongs to what dashboard?

this is the text from grafana.log

t=2018-03-13T09:06:44+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
t=2018-03-13T09:06:48+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
t=2018-03-13T09:06:52+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
2

Sometimes it can take 10s before the alert is removed from memory. Is it still present after 10s?

3

Yes, it is still there after 2 days.
I have restarted Grafana server but it didn’t helped

t=2018-03-13T00:00:01+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
t=2018-03-13T00:00:09+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
t=2018-03-13T00:00:13+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
t=2018-03-13T00:00:17+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
t=2018-03-13T00:00:21+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
t=2018-03-13T00:00:29+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting
t=2018-03-13T00:00:33+0100 lvl=info msg="Alert Rule returned no data" logger=alerting.evalHandler ruleId=75 name="Panel Title alert" changing state to=alerting

Is it possible to read in a file what ruleId that belongs to what dashboard?

6

Auch. That’s a nasty bug. What kind of database are you using for storing dashboards?

You need to delete those alerts from the alert table in the database.
The alert table also contains the dashboardid used to create those alerts.

7

I don’t know what database I am using for storing dashbaords, I think I am using built-in for Grafana, if that exist :slight_smile:

I didn’t know that I could use other than built-in.

Is Grafana database MySQlite?

8

It is SQLite. I used this program to edit the DB file
http://sqlitebrowser.org/