How to avoid "Error: tsdb.HandleRequest() error Could not find executor for data source type:mydb"

Grafana Plugin Development
1

Hello Everyone,

   I found a issue when using datasource plugin with  id "mydb",  when I wanted to create Alert in dashboard and  clicked "Test Rule" button In Alert panel,  i got below error message:

   Error: tsdb.HandleRequest() error Could not find executor for data source type:mydb

 Who knows this issue and can help me to avoid that?   Thanks!
2

Only specific backend supported datasources (Graphite, Prometheus, InfluxDB, OpenTSDB) support alerting queries as tey are executed by the backend, and external plugins are frontend only.

We are working on backend plugins so external plugins can also provide alerting but this 1-2 months away

3

Thanks for your response!

And another issue is How to clean alerting scheduler queue, i found there are always 5 rules in queue as below grafana.log, perhaps some alert is corrupted, so how to clean it or check why cause this issue. Thanks!

Thanks for your response!

And another issue is How to clean alerting scheduler queue, i found there are always 5 rules in queue as below grafana.log, perhaps some alert is corrupted, so how to clean it or check why cause this issue. Thanks!

t=2017-09-28T14:56:32+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:56:42+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:56:52+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:02+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:12+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:22+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:32+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:42+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:52+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:02+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:12+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:22+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:32+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:42+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:52+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:02+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:12+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:22+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:32+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:42+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:52+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T15:00:02+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T15:00:12+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5

Original Message
Sender:Torkel Ödegaardgrafana@discoursemail.com
Recipient:sllinsllin@taosdata.com

torkel Leader
September 28
Only specific backend supported datasources (Graphite, Prometheus, InfluxDB, OpenTSDB) support alerting queries as tey are executed by the backend, and external plugins are frontend only.
We are working on backend plugins so external plugins can also provide alerting but this 1-2 months away
Visit Topic or reply to this email to respond.
To unsubscribe from these emails, click here.

4

Thanks for your response!

And another issue is How to clean alerting scheduler queue, i found there are always 5 rules in queue as below grafana.log, perhaps some alert is corrupted, so how to clean it or check why cause this issue. Thanks!

Thanks for your response!

And another issue is How to clean alerting scheduler queue, i found there are always 5 rules in queue as below grafana.log, perhaps some alert is corrupted, so how to clean it or check why cause this issue. Thanks!

t=2017-09-28T14:56:32+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:56:42+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:56:52+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:02+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:12+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:22+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:32+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:42+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:57:52+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:02+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:12+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:22+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:32+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:42+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:58:52+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:02+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:12+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:22+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:32+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:42+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T14:59:52+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T15:00:02+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5
t=2017-09-28T15:00:12+0800 lvl=dbug msg=“Scheduling update” logger=alerting.scheduler ruleCount=5

5

do to the Alerting list view using Grafana main side nav, there you should see all rules and you can pause them or go to each dashboard and remove them

6

Yes! It works now ! Thanks!

7

Hello Torkel,

I try to implement a executor in pkg/tsdb/mydb , rebuild grafana and restart grafana, it looks like alert works well and i receive the Alert mail, but the image does not display nothing(no spark line), Could you please give me your suggesion? Thanks !

grafana-1
grafana-11371×1471 94.4 KB

8

Any errors in the Grafana Server log? And when you click on the link in the email, then the graph is working?

9

Clicked “View Your Alert rule” Link in mail, in the open window i got “Invalid CORS request” message. Thanks!

Original Message
Sender:Daniel Leegrafana@discoursemail.com
Recipient:sllinsllin@taosdata.com

daniellee
September 29
Any errors in the Grafana Server log? And when you click on the link in the email, then the graph is working?
Visit Topic or reply to this email to respond.
In Reply To
sllin
September 29
Hello Torkel, I try to implement a executor in pkg/tsdb/mydb , rebuild grafana and restart grafana, it looks like alert works well and i receive the Alert mail, but the image does not display nothing(no spark line), Could you please give me your suggesion? Thanks ! [grafana-1]
Visit Topic or reply to this email to respond.
To unsubscribe from these emails, click here.

10

No errors found in server log. Thanks!

11

Hello . Daniel,
below message from server log:

  t=2017-09-29T20:54:27+0800 lvl=info msg="Sending notifications for" logger=alerting.notifier ruleId=9 sent count=1

t=2017-09-29T20:54:27+0800 lvl=info msg=Rendering logger=png-renderer path="dashboard-solo/db/tbase-alert-final?&panelId=1"
t=2017-09-29T20:54:28+0800 lvl=info msg=“Request Completed” logger=context userId=0 orgId=1 uname= method=POST path=/api/datasources/proxy/6/query status=403 remote_addr=127.0.0.1 time_ms=42 size=20 referer="http://grafana.staged-by-discourse.com/dashboard-solo/db/tbase-alert-final?panelId=1&refresh=5s&orgId=1"
t=2017-09-29T20:54:28+0800 lvl=dbug msg=“Image rendered” logger=png-renderer path=/var/lib/grafana/png/gqJAoLECU2mzdyW5eZ42.png
t=2017-09-29T20:54:28+0800 lvl=info msg=uploaded logger=alerting.notifier url=

12

It is either a CORS error or a 403 - Forbidden error. Are you using Proxy or Direct mode for your data source?

13

Yes, i am using Proxy. I found below server logs:
t=2017-09-30T10:10:34+0800 lvl=info msg=“Request Completed” logger=context userId=0 orgId=1 uname= method=POST path=/api/datasources/proxy/6/query status=403 remote_addr=127.0.0.1 time_ms=50 size=20 referer="http://grafana.staged-by-discourse.com/dashboard-solo/db/tbase-alert-final?panelId=1&refresh=5s&orgId=1"
t=2017-09-30T10:10:35+0800 lvl=dbug msg=“Image rendered” logger=png-renderer path=/var/lib/grafana/png/WedSqZiNbmoAKmZwYd7b.png

Image was rendered without data(spark-line). I am not sure the reason. Thank You!

14

Hello Daniel and Torkel,

Thanks for your support and help! It works well for alert email for my datasource (-:! Grafana is great!

ok-alert-email
ok-alert-email1774×1632 281 KB

1 Like
15

Hello Torkel,

When would be implemented alerting feature for simple json data source in grafana ?

16

We would need to implement backend plugins for Grafana first. Alerting needs to be run on the server. It is on our roadmap but is probably a few months into the future.

17

Is there any other way so that we can use alert feature of grafana in
simple json data source ?

18

No, not that I can think of.

19

Hey,

could you setup a simple example of how to implement alerts on the backend?

I have a simple HTTP/REST datasource implemented in the frontend, but now I need to implement alerts (in the backend :frowning:).

However Go is not one of my best languages and I have no idea what I need to implement in order to make alerts work on my datasource.

thanks!

20

Can you guys make an example (maybe an extension to this one: https://github.com/grafana/simple-json-datasource) for the people who want to change the backend in order to make the alerts work for their datasources?

Thanks!