Show tag is not showing all the tag values

In our telegraf config we give ip manually and get hostname from hostname command, and by mistake we added one ip as two different servers, ip and hostname both are tag keys,
so now we had two hostname for one ip. and

SHOW TAG VALUES FROM “cpu” WITH KEY = host

would never show the correct hostname, but it would show the hostname of the other host were ip was configured wrong.
even after the correction in config we are not able to see the correct host while we can get data for that host via command like this.

select * from cpu where host=‘XXX’ group by *

but this host does not shows in

SHOW TAG VALUES FROM “cpu” WITH KEY = host

hi @Amit_Kumar_Singh ,

what is the output of

show tag keys from cpu

and

show field keys from cpu

best regards ,

Below is the response.

show tag keys from cpu
name: cpu
tagKey

app_stack
cpu
host
ip
os

and

show field keys from cpu
name: cpu
fieldKey fieldType


usage_idle float
usage_iowait float
usage_system float
usage_user float

could you share this after replacing the data you don’t want to be visible with xxxxx ?

   select * from cpu where host=‘XXX’ group by * limit 1

name: cpu
tags: app_stack=XXX, cpu=cpu-total, host=XXX, ip=XXX, os=aix7.1

time usage_idle usage_iowait usage_system usage_user


1556014717851364256 97 0 2 1

Hi @Amit_Kumar_Singh ,

could be related to this bug …

tag values