influxdata / influxdata/influxdb
Unable to delete measurements with special charachters
- 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
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