OK, I hacked around this.
I managed to clean up the series with invalid tag value by explicitly dropping
series which do not have whitelisted type:
> drop series from my_measurement where "type" != 'client' AND "type" !=
> "service"
Also I managed to drop the messed up measurement by dropping all series from it:
$ influx -format json -pretty --database ...
> show series from /_r[^e]/
{
"results": [
{
"series": [
{
"columns": [
"key"
],
"values": [
[
"_r�que�ts,...redacted..."
],
[
"_r�que�ts,...redacted..."
]
]
}
]
}
]
}
> drop series from /_r[^e]/
...
> show series from /_r[^e]/
{
"results": [
{}
]
}
... also gone from show measurements output.
I explicitly tested the `drop series from /regexp/` command first on a test
database as this used to be bugged -
https://github.com/influxdata/influxdb/issues/4276 :
$ cat test.txt
# DDL
CREATE DATABASE test
# DML
# CONTEXT-DATABASE: test
bogus1,tag1=value1 value=1 1439856000
bogus2,tag2=value2 value=2 1439856000
unwanted_measurement,tag3=value3 value=3 1439856000
Import:
$ influx --database test -import -path=test.txt -precision=s
2018/03/26 18:34:01 Processed 1 commands
2018/03/26 18:34:01 Processed 3 inserts
2018/03/26 18:34:01 Failed 0 inserts
$ influx --database test
Connected to http://localhost:8086 version 1.2.0
InfluxDB shell version: 1.2.0
> select * from /.*/
name: bogus1
time tag1 tag2 tag3 value
---- ---- ---- ---- -----
1439856000000000000 value1 1
name: bogus2
time tag1 tag2 tag3 value
---- ---- ---- ---- -----
1439856000000000000 value2 2
name: unwanted_measurement
time tag1 tag2 tag3 value
---- ---- ---- ---- -----
1439856000000000000 value3 3
> SHOW SERIES FROM /unwanted/
key
---
unwanted_measurement,tag3=value3
> DROP SERIES FROM /unwanted/
> SHOW SERIES
key
---
bogus1,tag1=value1
bogus2,tag2=value2
> show measurements
name: measurements
name
----
bogus1
bogus2
I hope this helps.
--
Remember to include the version number!
---
You received this message because you are subscribed to the Google Groups
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit
https://groups.google.com/d/msgid/influxdb/c67cfe0b-7983-4e54-bbe6-b7708c93409e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
