influxdata / influxdata/influxdb

Unable to delete measurements with special charachters

Open
#17,803 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

I have a telegraf input_exec that runs commands and pipes it into influxdb. At time, based on the output, the command creates random measurements. I have a shell script that cleans up unwanted measurements.

With these new measurements, I am unable to delete these measurements.

__Steps to reproduce:__
List the minimal actions needed to reproduce the behavior.

1. show measurements
name: measurements
name
.amazonaws.com-(52.219.66.51)
amazonaws.com-(52.219.66.115)
amazonaws.com-(52.219.66.34)
azonaws.com-(52.219.66.76)

2. drop measurement "azonaws.com-(52.219.66.76)"

__Expected behavior:__
On running show measurement command again, the measurement should not exist

__Actual behavior:__
The measurements are not deleted
show measurements
name: measurements
name
.amazonaws.com-(52.219.66.51)
amazonaws.com-(52.219.66.115)
amazonaws.com-(52.219.66.34)
azonaws.com-(52.219.66.76)

__Environment info:__

* System info: Linux 3.10.0-1062.18.1.el7.x86_64 x86_64
* InfluxDB version: InfluxDB v1.8.0

__Logs:__
influxd: ts=2020-04-20T19:14:43.143670Z lvl=info msg="Executing query" log_id=0M43cdA0000 service=query query="DROP MEASUREMENT \"azonaws.com-(52.219.66.76)\""

I have tried various forms of deleting the measurement. Obviously regex is not supported. I can delete series, but the measurement still remains.

Any help would be appreciated.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the DROP MEASUREMENT query from the issue against InfluxDB v1.8.0 using the listed measurement name containing dots, parentheses, and an IP address. The fix is complete when the command removes that measurement and SHOW MEASUREMENTS no longer lists it.

Written by the indexing model from the issue text.

Assessment

Tech stack
shell
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.