CODEWITHSUNDEEP
influxdbgrafana-templating
FranAguiar
FranAguiar

Reputation: 647

InfluxDB - Drop series is not working

I want to delete some hosts that I'm not using anymore because show up on grafana with templates and I don't want that.

I execute drop series from measurement where host = 'hostName' Then I execute show series from measurement

The host still there. Any idea?

drop series from cpu where host = 'hostName'
show series from cpu where host = 'hostName'
cpu,cpu=cpu-total,host=hostName
cpu,cpu=cpu0,host=hostName
cpu,cpu=cpu1,host=hostName

Upvotes: 2

Views: 2168

Answers (2)

Ivan
Ivan

Reputation: 331

In some later version of influx another bug (behavior) exists - after dropping all series by tag you should restart influxdb server to reset/cleanup/rebuild some in-memory data. In my case hosts disapeared only after restart. See this issue later discussions for more details: https://github.com/influxdata/influxdb/issues/5092

Upvotes: 3

Tom
Tom

Reputation: 1133

There was a bug with the newer versions (1.4+) not dropping data: github.com/influxdata/influxdb/issues/9246

The bug was fixed, so you should upgrade your installation.

Install and start the InfluxDB service (older linux dist): sudo apt-get update && sudo apt-get install influxdb sudo service influxdb start

If your operating system is using systemd (Ubuntu 15.04+, Debian 8+): sudo apt-get update && sudo apt-get install influxdb sudo systemctl start influxdb

For full documentation: https://docs.influxdata.com/influxdb/v1.4/introduction/installation/

Upvotes: 2

Related Questions