Influx2 "Failed to load tag keys" when using data explorer

InfluxDB 2
1

New instance of Influx2-beta running inside docker. I was able to push data to it but i’m unable to load the data back.

When I try to use the data explorer and click on the bucket I get a “Loading tag values” then a failure.

Is there anything that I can do? Does that mean Influx couldn’t handle the data?

I loaded about 1million points with 3 tags and 3 fields.

2

Hello @phanosdev,
Welcome! What version of influx are you using? How did you push the data? Can you please share the influxdb logs and (and telegraf? or client? logs)? Finally, have you tried querying the database directly?

3

@Anaisdg I believe I’m also seeing a similar issue.

My setup:
VM: Ubuntu 18
InfluxDB: running local on VM (not container)
Telegraf: running as container, Telegraf 1.13.4 (git: HEAD ffabd6b5)

Telegraf is using Kafka Input to collect data from a topic and send to InfluxDB2.0.
The data gets stored and I’m able to perform some queries.

I’m using InfluxDB2.0 WebUI to generate my Flux Query:

from(bucket: “bb_interfaces_test”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: ® => r._measurement == “interfaces”)
|> filter(fn: ® => r._field == “in-octets”)
|> filter(fn: ® => r.interface-name == “et-0/0/0”)

When I click submit i see this error in the explorer window:

type error 5:36-5:40: undefined identifier "name"

The following items are configured to come in as tags:

> show tag keys from interfaces
name: interfaces
tagKey
------
device
host
interface-name
oper-status
parent-ae-name
path
system_id

When I try to filter for a specific tag “interface-name” value I get the following error message: Failed to load tag keys.

image
image1226×401 37.4 KB

However, if I remove the “interface-name” line from the Flux query. I do get data back, and within that data I see all my tags.

If I change filter to group I’m able to run the query but when I change to group I don’t see all my tags which I thought I would see, just shows the “interface-name” tag:

image
image999×384 33.9 KB

How can I group by more than one tag as we can do in InfluxQL?

Thank you,
Mo

4

Hello @mohsin106,
It’s hard for me to say. Sometimes keys don’t appear in the UI for me if my dashboard date selection isn’t far back enough in time. Can you please try changing your dashboard time first? Does that fix your problem? Finally, do you happen to have the system stats input plugin running? Could you see if this query works?

from(bucket: "telegraf")
  |> range(start: dashboardTime)
  |> filter(fn: (r) => r._field == "usage_system")
  |> filter(fn: (r) => r.cpu == "cpu-total" or r.cpu == "cpu0")

Thanks!

5

Hi @Anaisdg, so changing the time had no effect. I’m thinking that the for some reason the data explorer WUI does not like hypens “-” in the tag names. I had another problem where I could not use the “.” dot syntax when trying to query for a specific tag value. In my Flux query I had to replace dot notation with bracket notation so I had to do |> filter(fn: (r) => r["interface-name"] =~ /.+/) instead of r.interfaces-name.

I did have the stats plugin running and was able to run the Flux query you gave:

image
image3402×1237 371 KB