influxdata / influxdb

Scalable datastore for metrics, events, and real-time analytics
https://influxdata.com
Apache License 2.0
28.96k stars 3.56k forks source link

CPU measurement tags are not returned #20915

Open KannappanSomu opened 3 years ago

KannappanSomu commented 3 years ago

Tags are not loading at all for “CPU” measurement.. for other measurements its loading properly.

Upon investigating , found that Chronograf posts following metadata query to InfluxDb when we select CPU metric in chronograf UI and it goes to pending state as there is no response back from InfluxDB for longer duration and then times out

SHOW TAG VALUES FROM "autogen"."cpu" WITH KEY IN ("GlobalMon.Site", "__auth_key", "_resourcegroup_", "_subscription_", "_team_", "application", "cluster_owner", "cpu", "cynosure.isCynosure", "dc", "dspa.xdm application", "dspa.xdm environment", "env", "host", "hostname", "logfile", "month", "namespace", "weekday", "year")"

This metadata query works fine when posted without Tag key "CPU".

SHOW TAG VALUES FROM "autogen"."cpu" WITH KEY IN ("GlobalMon.Site", "__auth_key", "_resourcegroup_", "_subscription_", "_team_", "application", "cluster_owner", "cynosure.isCynosure", "dc", "dspa.xdm application", "dspa.xdm environment", "env", "host", "hostname", "logfile", "month", "namespace", "weekday", "year")"

TAG value cardinality for key "CPU "- in CPU measurement is 418

Tried posting following query manually in Influx data node command line and it takes longer duration and never loads.

SHOW TAG VALUES ON "vc" FROM "autogen"."cpu" WITH KEY IN ("cpu")

Any pointers how to troubleshoot this ?

KannappanSomu commented 3 years ago

chronograf version used is 1.8.0

sranka commented 3 years ago

Thank you for posting an issue and an initial investigation that pinpoints the root cause of the issue (which is near to influxDB ), you can also try asking at https://community.influxdata.com/ .

Please include also the version the InfluxDB database that you are running against.

kristinarobinson commented 3 years ago

Are you using 1.8 or 2.x OSS or Cloud2 InfluxDb?