Delete "MEASUREMENTS " from the database

Telegraf
1

Hello,
I can’t delete a “measurements” from the database.

Unfortunately I created a CQ by assigning a wrong name to the “measurements” and I would like to delete it, but I cannot manage with any command, even deleting the continuous query.

The measure in question is called: “sensor_infinite_dataraw_temperture” and is located in the database “homeassistant”

I tried with the following command:
DROP MEASUREMENT sensor_infinite_dataraw_temperture

but influx responds with “database non found”

Which command should I use?

I use InfluxDB with HomeAssistant

Thanks

2

Hello @SmartM-ui,
Welcome! What version of InfluxDB are you running?

3

@Anaisdg
Hi,
I use influxdb 1.8 as an add-on in Home Assistant.
Thanks for answering me, I hope for your help!

4

Hello @SmartM-ui,
I’ll admit I’m a little confused.
Can you show the output of

  • > SHOW DATABASES
  • USE homeassistant
  • SHOW MEASUREMENTS

Thank you.

5

@Anaisdg
Thanks for replying, I send the reference screenshots

Schermata 2020-12-15 alle 23.15.17
Schermata 2020-12-15 alle 23.15.172156×1278 213 KB

Schermata 2020-12-15 alle 23.15.57
Schermata 2020-12-15 alle 23.15.572150×1276 212 KB

Schermata 2020-12-15 alle 23.17.03
Schermata 2020-12-15 alle 23.17.032150×1320 214 KB

6

@Anaisdg
with the command
SHOW MEASUREMENTS ON “homeassistant”
i can see the measurements

Schermata 2020-12-15 alle 23.22.45
Schermata 2020-12-15 alle 23.22.452146×1280 241 KB

the sensor I was talking about in the first post (“sensor_infinite_dataraw_temperture”) I deleted it by deleting the entire “homeassistant” database, but I would like to learn how to delete the “measurements” for the future in case of need, without having to delete the entire DB !

7

Ahhh I understand the problem now @SmartM-ui,
You have to use the CLI to use the command drop measurements.

8

Thanks for the reply, but how do I connect to the influx db?
I have installed the add-on in HomeAssistant installed on raspberry as an operating system.

9

Hello @SmartM-ui,
How did you install influxdb?
In the directory that you installed influxDB you run ./influx to start the CLI.
This might be useful:

Or you could use the API

10

Thanks, I try to see.
I installed the add-on directly into the HASSOS operating system:

11

Hello @SmartM-ui,
Looking at the home assistant docs

It looks like the hassio-addons/addon-influxdb “exposes an HTTP API for client interaction” So I would use the InfluxDB API to drop a series or measurement. With default as localhost:8086. So I’d try following the InfluxDB API documentation examples.

12

Thanks, I try to understand how to do it :slight_smile:

13

Hello @SmartM-ui,
I haven’t used the 1.x API in a while, so I might be wrong, but you could try:

curl http://localhost:8086/query \
  -d db="homeassistant" \
  -d q='drop measurement "sensor_infinite_dataraw_temperture"'
14

Hi!
thanks for the information, writing the code from the terminal in home assistant reports an authentication error, as shown in the image.

Schermata 2020-12-16 alle 20.13.15
Schermata 2020-12-16 alle 20.13.15908×458 45.6 KB

Writing the code from the terminal on the macbook, it reports the following message:
curl: (7) Failed to connect to localhost port 8086: Connection refused

15

ah okay you need to add auth according to: InfluxDB API reference | InfluxDB OSS 1.8 Documentation

16

Thank you very much!

17

Hi @Anaisdg ,
thanks to the documentation you indicated, my friend Mario (shogunxam (MARIO D'AMICO) · GitHub) was able to process the code that allowed the cancellation of the “measurements”:

curl -u myusername: mypassword -XPOST ‘http: // localhost: 8086 / query? db = mydb’ --data-urlencode ‘q = drop measurement “mymeasurement”’

Have a nice day and thanks again