Deleting a measurement

Hello,

I can delete a measurement using “influx delete --org…”

Currently, I have three measurements with the same name in InfluxDB. I can’t delete them all with Influx delete. What other methods are there?

You can study this
Use commandline like below

influx.exe delete -o MyOrganization -t myToken -b myBucket --start 1970-01-01T00:00:00Z --stop 2026-01-01T00:00:00Z -p _measurement="gasheater"

Everything is running on a Raspberry Pi 5 with Bookworm.

Currently, only the faulty measurement is visible in Data Explorer. I was able to delete the one with the correct data using influx delete (it still exists as a CSV file).

influx.exe delete returns a command not found.

influx delete is the primary way that InfluxDB 2 handles deletes, so if you’re not able to remove the exact measurements/datapoints you want with it, then the only other way would be to manually clean things up on disk.

I do think the .exe was just a typo on CZvacko’s part, but the link to the docs got you there :slight_smile:

I also tried using curl…, but that didn’t work either. The measurement in question contains no data. The AI ​​suggested an index error and proposed another solution, but it seems too risky. I guess I’ll have to live with this faulty entry for now.

Yeah, it seems like removing an entire measurement is somewhat tricky with v2. There’s another thread from a couple years ago where it seems like there’s not a super clean way of doing it - emptying out all the data is more or less the best you can do.

I think if it really bothers you, you could do something like move your data into a new bucket and delete the entire old bucket, but that may be overkill.

I did manage to get a data output for the measurement in question and exported the data. The name is actually “TmaxproTag”. However, an extra character is displayed at the end. It’s not a space, because the measurement “TmaxproTag” cannot be deleted using InfluxDelete.

It is indeed a space, but the measurement cannot be deleted.

It seems it’s not just the name that’s the problem:

Influx.exe is InfluxDB CLI that can be used on Windows OS. The user didn’t mention the OS before my reply.

1 Like