Issue: Grafana doesn't assemble a query, gives output Network Error: undefined(undefined):

Grafana InfluxDB
1

Hi Support,

I have a paid account for WekaIo, please let me know if I can open support ticket by another channel other then community:

Steps:

  1. Choose ‘all’ for Zone and Instance ID for the ‘Redis servers not working’ dashboard:

https://wekaio.grafana.net/d/000000063/redis-servers-not-working?orgId=1

configurations:

Query of one of the graphs:
SELECT mean(“used_memory”) FROM “redis” WHERE (“instance_id” =~ /^$instance_id$/ AND “zone” =~ /^$zone$/) AND $timeFilter GROUP BY time($interval), “instance_id”, “zone”

Variables:
A. SHOW TAG VALUES FROM “redis” WITH KEY = “zone” WHERE “app” = ‘redis-server’ OR “app” = ‘digger’
B. SHOW TAG VALUES FROM “redis” WITH KEY = “instance_id” WHERE “app” = ‘redis-server’ OR “app” = ‘digger’

Grafana is connected to influxdb.
2) Run the query

Results:
Error in Graph pane: ‘Network Error: undefined(undefined)’:
Screenshot 1:
https://photos.app.goo.gl/wkoZJc1Le3dKje6F7

Screenshot 2:
https://photos.app.goo.gl/1gaq25Udir96Qgc49

Checking the ‘Query inspector’, see it’s stuck on ‘loading’ logo:
Screenshot 3:
https://photos.app.goo.gl/8RkjfPxE73Qq2T366

Important note from investigation:
Reviewing the the influxdb logs, shows that the query never reached the server.

More info:

    1. If we compose the query by ourselves, manually, it executed successfully:
      SELECT mean(“used_memory”) FROM “redis” WHERE (“app” =~ /^(redis-server|digger)$/ AND “instance_id” =~ /^(digger|i-000c9f611b6f4baf6|i-00400e96784f9fde2|i-00415641d34a02364|i-004f9b1bc3b11a3c6|i-00540f14fe12b6315|i- 008ac2e0f3f725382|i-008caa1dd8800f8e1|i-0094608dbbcda8cc9|i-009b472635fff765a|i-00a06e1ca1915b053|i-00a34c24 1dab13b66|i-010d6b61432647a1e|i-012e0ae025d6e31eb|i-016400c125d50e6f4|i-019c51e73ed2e87ed|i-01af95ea645926 f2f|i-01f502e2c6cdec71e|i-01fc77f2dc766af22|i-0211c6a871811c7a9|i-0213e167c6c4bccc0|i-02219bad90b22a094|i-0225 7823866845fd5|i-024301a3629940d9c|i-0254da9f5db295ac1|i-02898854d47185c44|i-028dbc114ffc60f41|i-02a78258e98 7b1b24|i-02a868933205fd134|i-02c5ecbb00525b8ad|i-03045f2faf447f5cb|i-030e962eadbfe922b|i-0312ffefcc49f98c3|i-033 4dc6b4ad1f2125|i-03372a930f97833b4|i-037c53c3bbc494073|i-03a3c22c4637ae5a9|i-03a957062f2b64cfd|i-03ae3f2edfc cf9363|i-03bdaa06bdb39c9f4|i-03f65fce72feb7c71|i-041947472fe2f2d05|i-042ec5b0ed143fc31|i-043093f0448495791|i-04 4226c4a0c970a9e|i-044258afd687798e7|i-048c94b925f06628d|i-04aa5a9329b0ca03b|i-04c08307bf65275f7|i-04c09f804 6acdcc85|i-04da3c3855baa4be1|i-04dbc0f12ed003ee2|i-05062848f9b5a3594|i-050769a9fcacdc8cc|i-054ec6c804902b5d 0|i-055153df83d63b0a4|i-0551d6d828ca6db45|i-057c627f4f87d8fd5|i-0587178067f2d8429|i-058b29dfbfb48b8f3|i-058b2b 5b41225ae79|i-059516ac1b5ae4cee|i-05ab1b98a9fcfccad|i-05dac50c14b7de158|i-061d46fab3a8e0af4|i-063a77805c363 b6b8|i-064476993cf83dd80|i-066729000374c828c|i-067903a0a7365b3c9|i-067e0de34be6929ad|i-068209b0641a0e1bb|i- 068475d181ff69cbb|i-069a677b7c567bcf4|i-06a765d65a86173ac|i-06bc98588ab24ae90|i-06f1409d7d735c9b1|i-06f9129 ac77eb9261|i-070d8c9f44838e096|i-0724129fd36b968fc|i-0737ad2aa1f22e8e7|i-0763a856b52062d78|i-0775a3834a5255 9ed|i-07dc50f530b107bc7|i-0822d3f95108d125c|i-0824a388451c215cf|i-08261e53550d2fe58|i-0839747075083a697|i-08 46a53e7c928e3d6|i-08597c3be3cc95787|i-0865bb1ae8514fa7c|i-0892f1cfc84e36b1f|i-08996a7fb2bcd54b4|i-08ab81599f 4ea71f6|i-08f1e5a3d207d8ac1|i-08f42efde553513d0|i-09065b1aaa61fb0b8|i-090e72675086dd87c|i-0952ae865cf171650|i -0998cce44e791f093|i-09a593477e027f9a0|i-09a817344a68d6cdb|i-09ac8cc6bf3d24315|i-09b015ea65e066624|i-0a09f8 9cf45d39296|i-0a17b4418f08e259b|i-0a32694eaa00dc9ee|i-0ad4417337de5f764|i-0ade8c5f27f9c3ccb|i-0af0119cdd6e7d d4b|i-0b11d48fb094979d1|i-0b1c4c832f2628a32|i-0b2adfa858d5880ec|i-0b55658de7458007c|i-0b6aa17ffbb703920|i-0b8 956408744b9613|i-0ba0128d2d9f3ce07|i-0bb614d2765f9b27f|i-0bcd47b000e771ffb|i-0bd22a103467a84dc|i-0bd9848340 883d1fa|i-0befdc70d719ab994|i-0c0da1de313d432ad|i-0c63055de9c6ab17a|i-0c66a4f6f8a9a52a3|i-0c96d7cd62643d505| i-0cd2122028adb9314|i-0cf3300a7251df846|i-0d07faf3d9f1eccf2|i-0d26d0a304639b82b|i-0d413e4fecdcf930b|i-0d75849e 586fa1c9f|i-0d7e3beccb551d151|i-0d99a556f20120aba|i-0da6f7c186e63c06a|i-0dad0326d802edffe|i-0dbc5484ae941a72 3|i-0e02c910d75f02f7d|i-0e26a6c78b48a4150|i-0e3d1d0c3cd2d9aa6|i-0e44322eed662ca3c|i-0e545410c5d19c991|i-0e5c 87d6b14988df3|i-0e75edf2b98dde52f|i-0e941e4a25126fab0|i-0e9addba632b7960d|i-0ea25fc1085d704fa|i-0ea61377427 da2e62|i-0eb9011a1de095f24|i-0ebe83bca8fe1eb4e|i-0ec8614b54dd66a9f|i-0ed86eb435cb13a07|i-0edf70aec5e6db32a|i -0ef2e15e30d4b23f5|i-0f14da8513b974788|i-0f15aafa017294f66|i-0f39079910c6ed489|i-0f5727be71ad44439|i-0f5f79696 e8d43aea|i-0f9c6f566d97b5241|i-0facdb9ddb00309e5|i-0fb4b8a3edaf235c1|i-0ffc3c1e3707f8e52)$/ AND “zone” =~ /^(ap-northeast-1a|ap-northeast-1c|ap-northeast-1d|ap-northeast-2a|ap-northeast-2c|ap-south-1a|ap-south-1b|ap-southea st-1a|ap-southeast-1b|ap-southeast-1c|ap-southeast-2a|ap-southeast-2b|ap-southeast-2c|eu-central-1a|eu-central-1b|eu- central-1c|eu-west-1a|eu-west-1b|eu-west-1c|eu-west-2a|eu-west-2b|sa-east-1a|sa-east-1c|us-east-1a|us-east-1b|us-east -1c|us-east-1e|us-east-1f|us-east-2a|us-east-2b|us-east-2c|us-west-1a|us-west-1c|us-west-2a|us-west-2b|us-west-2c|tlv-1 )$/) AND time >= now() - 12h GROUP BY time(30s), “instance_id”, “zone”
    1. Another workaround:
      In variables, we remove the ‘app tag, ““app” = ‘digger’”, and running the query from step 1, query assembled and executed correctly.
      See it in dashboard ‘Redis Servers’: Grafana
2

in the query above, it doesn’t look like you are referencing the template variables.

If the name of the template variables are A (list of zones) and B (list of instances), the query would look like this:

SELECT mean(“used_memory”) FROM “redis” WHERE (“instance_id” =~ /^$A/ AND “zone” =~ /^$B/) AND $timeFilter GROUP BY time($interval), “instance_id”, “zone”

Can you take a screenshot of the variables to confirm their names?