doitintl / bigquery-grafana

Google BigQuery Datasource Plugin for Grafana. (NO LONGER MAINTAINED)
https://www.doit-intl.com/labs/
MIT License
242 stars 76 forks source link

Problem with alerting #265

Closed tomashman8 closed 4 years ago

tomashman8 commented 4 years ago

Bug Report

When creating an Alert instead of it working correctly and alerting we get this:

Execution Error: tsdb.HandleRequest() error Could not find executor for data source type: doitintl-bigquery-datasource

I have already made sure doitintl-bigquery-datasource is listed as an unsigned plugin.

Expected Behavior

Alerts being able to be sent.

Actual Behavior

I get this error message:

Execution Error: tsdb.HandleRequest() error Could not find executor for data source type: doitintl-bigquery-datasource

Steps to Reproduce the Problem

  1. Create a dashboard with graph and use plugin datasource doitintl-bigquery-datasource.
  2. Setup an alert based upon that graph.

Specifications

tomer-harpaz commented 4 years ago

I get the same error Version:2.0.0 Platform: GKE Grafana Version: Grafana v7.0.3

LiorRacer commented 4 years ago

Hi all, It will be very helpful if one of you can share the deployment yaml file, so I can work with the enviroment

sergiojoker11 commented 4 years ago

@LiorRacer I am replying on behalf of @tomashman8 (we work for the same organization). Here is the relevant helm values where we configure the plugin.

grafana:
  grafana.ini:
    plugins:
      allow_loading_unsigned_plugins: "doitintl-bigquery-datasource"
  adminPassword: XXXXXXXXXXXXXXXXXXXX
  persistence:
    enabled: true
  ingress:
    enabled: true
    annotations:
      kubernetes.io/ingress.class: nginx
      certmanager.k8s.io/cluster-issuer: "letsencrypt-prod"
    hosts:
      - grafana.monitoring.flexys.co.uk
    tls:
      - secretName: grafana-tls
        hosts:
          - grafana.monitoring.flexys.co.uk
  plugins:
    - https://github.com/doitintl/bigquery-grafana/archive/2.0.0.zip;doit-bigquery-datasource
  notifiers:
    notifiers.yaml:
      notifiers:
        - name: Stage-Alerts
          type: slack
          uid: Grafana-Stage
          # either
          org_id: 1
          is_default: false
          send_reminder: true
          frequency: 1h
          disable_resolve_message: false
          # See `Supported Settings` section for settings supporter for each
          # alert notification type.
          settings:
            recipient: '#stage-alerts'
            token: 'xoxb'
            uploadImage: true
            url: <Some_URL_TO_Slack>
  sidecar:
    datasources:
      enabled: true

Shout if you need more info and I'll try to support you.

tomer-harpaz commented 4 years ago

Hi @LiorRacer , any update? did you guys manage to reproduce it?

Tamirk commented 4 years ago

Hi @tomer-harpaz not yet, I hope next week we will be able to allocate time and check this out, Will send an update once we news. Thanks for the follow-up

burbma commented 4 years ago

I've got Version:2.0.0 Platform: GKE Grafana Version: Grafana v7.1.5 (Although I tried several others)

For me the Alert tab doesn't show up at all.

burbma commented 4 years ago

Nevermind. I just had to switch the visualization type to Graph and not Table.

burbma commented 4 years ago

I now also see Execution Error: tsdb.HandleRequest() error Could not find executor for data source type: doitintl-bigquery-datasource.

johanbaath commented 4 years ago

@burbma Did you manage to get this working?

burbma commented 4 years ago

@johanbaath No I still have the same error.

NeckBeardPrince commented 4 years ago

Same issue. Looks like we have to wait until 2.0.1 gets released?

burbma commented 3 years ago

Or you can pin to a commit in you helm values.yaml

plugins:
  - https://github.com/doitintl/bigquery-grafana/archive/860cabeb098e3acab01ec5cf6d74a7769eadfed8.zip;doit-bigquery-datasource
tomer-harpaz commented 3 years ago

This bug still reproduced on 2.0.1 image