I can't get rid of a ghost tag after performing a delete of records

InfluxDB 2
, ,
1

Greetings all… I am pulling my hair out over having what appears to be a ghost tag after a purge of records where it existed.

  • InfluxDB2 v 2.7.10 on Rocky 8.10
  • v2 bucket created with DBRP link created

I used: influx delete --org myOrg --bucket mybucket --start ‘1970-01-01T00:00:00.00Z’ --stop ‘2024-09-05T00:00:00.00Z’ to get rid of all records that contained that tag value. The “ghost tag value” was changing a misspelled hostname.

If I run ‘influx v1 shell’, ‘use mydatabase’ then ‘show tag values with key = “host”’ I get both the corrected and incorrect hostname.
Index Key Value
1 host correctspelledhostname
2 host incorrectspelledhostname

If I run ’ show tag values with key = “host” WHERE host = ‘incorrectspelledhostname’ ’ I get nothing back.

If I run ’ show tag values with key = “host” WHERE host = ‘correctspelledhostname’ ’ I get a single line response listing the key/host and ‘correctspelledhostname’

I’ve tried wildcards in a SELECT query to find any instance of ‘incorrectspelledhostname’ and nothing is returned.

I run the same query for ‘correctspelledhostname’ and I get lots.

I cannot for the life of me figure out how to get rid of key/host ‘incorrectspelledhostname’ from the database. I cannot find a single record in a query yet ‘show tag values with key = “host”’ shows it.

I’ve rebooted the server where the database resides. I’ve restarted influxdb several times. I’m at a loss as to where this ghost is hiding.

Thanks for all who read this…

2

Hello @JeffAeon,
Are you still encountering this issue?
Ive seen this issue before with InfluxDB, where the tag index might not update correctly after a data deletion.

you might want to try triggering a compaction with

influxd inspect buildtsi -b mybucket

the data might not be physically removed until compaction occurs

Do you have any luck with the v2 CLI?
You might want to recreate your mapping as well.