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

Solution

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/