If unable to connect to source host page always says "Loading Hosts..."

[goller]

When failing to connect to a source, rather than showing an error message it says "Loading Hosts..."

[cryptoquick]

@goller What should Chronograf do in this case?

[goller]

@cryptoquick I think it should only display loading hosts when it is running a query. If the query returns zero hosts, I think it should say zero hosts found. If it cannot contact the server (error or otherwise) it should say something about unable to connect, etc.

[cryptoquick]

Sounds good. I'll see what I can do.

[games]

I got this error:

the data as below:

{
  "results": [{
    "statement_id": 0
  }, {
    "statement_id": 1
  }, {
    "statement_id": 2,
    "series": [{
      "name": "win_cpu",
      "tags": {
        "host": "MyServer"
      },
      "columns": ["time", "mean"],
      "values": [
        [1490658776937, 8.668630778541168]
      ]
    }]
  }, {
    "statement_id": 3,
    "series": [{
      "name": "win_system",
      "tags": {
        "host": "MyServer"
      },
      "columns": ["time", "mean"],
      "values": [
        [1490659366939, 0]
      ]
    }]
  }, {
    "statement_id": 4
  }, {
    "statement_id": 5
  }]
}

softwares:
chronograf-1.2.0~beta5-1
influxdb-1.2.0_windows_amd64

[cryptoquick]

@games can you try making chronograf from the code that's in master? Or the latest release.

[goller]

@games thank you for the bug report! Especially, thank you for the results from the endpoint.

@games @cryptoquick My hunch is that it is this query:

show tag values from system with key = "host"

that is used here:

chronograf/ui/src/hosts/apis/index.js

Line 20 in 2ee0008

const hostnameIndex = allHostsSeries.columns.findIndex((col) => col === 'value');

@cryptoquick To fix this we need another query here:

chronograf/ui/src/hosts/apis/index.js

Line 8 in 2ee0008

query: `select mean(usage_user) from cpu where cpu = 'cpu-total' and time > now() - 10m group by host; select mean("load1") from "system" where time > now() - 10m group by host; select mean("Percent_Processor_Time") from win_cpu where time > now() - 10m group by host; select mean("Processor_Queue_Length") from win_system where time > now() - 10s group by host; select non_negative_derivative(mean(uptime)) as deltaUptime from "system" where time > now() - 10m group by host, time(1m) fill(0); show tag values from system with key = "host"`,

The query would likely be

show tag values from win_system with key = "host"

Additionally, this piece of code needs an additional query:

chronograf/ui/src/hosts/apis/index.js

Line 70 in 2ee0008

query: 'show tag values from system with key = "host"',

The query would also likely be

show tag values from win_system with key = "host"

[goller]

@games I've created a PR for your issue here: #1104

Again, thanks for reporting it!