InfluxDB queries work on CLI, but stay pending from within a Grafana dashboard

Hi all,

First, let me open by saying: 1) I’m a newbie to InfluxDB, and all the various stacks, so 2) feel free to respond with a one-liner of “This is a question for the Grafana boards.”

I had been running this Grafana dashboard to monitor my Jitsi Meet server with no issues whatsoever for many weeks: https://grafana.com/grafana/dashboards/11969

Then yesterday, it started indefinitely hanging.

According to Chrome’s Dev Tools, the first two of these InfluxDB queries return quickly, then the next four remain pending indefinitely:

show tag values from "jitsi_stats" with key="host"
SELECT mean("conferences") FROM "jitsi_stats" WHERE ("host" =~ /^jitsi_host$/) AND time >= now() - 6h GROUP BY time(30s)
SELECT mean("largest_conference") FROM "jitsi_stats" WHERE ("host" =~ /^jitsi_host$/) AND time >= now() - 6h GROUP BY time(30s)
SELECT mean("rtt_aggregate") FROM "jitsi_stats" WHERE ("host" =~ /^jitsi_host$/) AND time >= now() - 6h GROUP BY time(30s) fill(none)
SELECT mean("jitter_aggregate") FROM "jitsi_stats" WHERE ("host" =~ /^jitsi_host$/) AND time >= now() - 6h GROUP BY time(30s) fill(none)
SELECT mean("total_conferences_created") FROM "jitsi_stats" WHERE ("host" =~ /^jitsi_host$/) AND time >= now() - 6h GROUP BY time(30s) fill(null)

All these queries return immediately from the CLI in influx, however.

Can anyone suggest how I could troubleshoot this? I tried dropping the database and recreating it; same result. The only thing I can think is that I’ve been creating new datasources, databases, dashboards, etc., and, at the time that I was possibly sending new data to an incorrect database (but not my Jitsi one), my Jitsi datasource was set as a default in Grafana. I’ve removed it as a default now, and have since recreated the database, as I said, so that shouldn’t be an issue now, even if it was, I’d assume.

But, yes, I’m so new to this, I’m having difficulty even generating theories to investigate. Any suggestions would be gratefully received!

JJ

It’s a bug.

1 Like