Drop series from Influx 1.8 database

Hello

I use a very simple InfluxDB 1.8.10 on my old Raspberry Pi 3B+ to collect my watermeter data.
The DB “wasserzaehler” has only time and kubikmeter as values.
They are written with the ESP32 project GitHub - jomjol/AI-on-the-edge-device: Easy to use device for connecting "old" measuring units (water, power, gas, ...) to the digital world
But the meter cannot be read at the moment (waterdrops everywhere) and I want to insert my own readings in the database.
Now I first tried something like this inside of my rasp (via ssh):

curl -i -XPOST ‘``http://localhost:8086/write?db=wasserzaehler’`` --data-binary 'kubikmeter=2.643'
here I get a missing fields error, but on:
curl -i -XPOST ‘``http://localhost:8086/write?db=wasserzaehler’`` --data-binary ‘kubikmeter value=2.643’

I got a 204 No content, which should be fine, but the value is not in the db :frowning:
When I do in the influxdb:
SELECT * FROM zaehlerstand WHERE kubikmeter > 2
I get nothing (my values are all under 2).

Also when I directly try to put values in the influx with:
INSERT kubikmeter=2.643
or
INSERT time=’2025-09-07T07:03:00Z’ kubikmeter=2.643
neither I find this value in the db.
But now I have weird series:

SHOW series
key

kubikmeter
time=’2025-09-07T07:03:00Z’
zaehlerstand

I added series instead of values :frowning:
And in theses series indeed the entered values are present.
So in the end (by making these errors) I found that I can curl this:

curl -i -XPOST ``http://192.168.0.160:8086/write?db=wasserzaehler`` --data-binary ‘zaehlerstand kubikmeter=2.677’

where 192.168.0.160 is the IP from my rasp in my local network.
And this enters the value 2.677 into the zaehlerstand series :slight_smile:

But how can I drop now the wrong series kubikmeter and time=’2025-09-07T07:03:00Z’ from my database?
DROP series kubikmeter
Doesnt obviusly work (missing from or where). In the help DROP SERIES it is not clear to me and I fear to delete my good series.
Thanks for help :slight_smile:
frank

OK found it by myself:

DROP SERIES FROM kubikmeter
DROP SERIES FROM “time=’2025-09-07T07:03:00Z’”

did the trick. The help about DROP SERIES says:

The DROP SERIES query deletes all points from a series in a database, and it drops the series from the index.

So deleting the content deletes the series too.