influxdata / influxdata/influxdb
Show Series with time filter exceeds "max-select-series"
@dgnorton is already working on this.
Since Mar 31, 2020.
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
When running SHOW SERIES with a time filter like below
SHOW SERIES FROM "livemetrics" WHERE time > 1570114082s
it shows error:
"error": "max-select-series limit exceeded: (10001/10000)"
which is OK.
Bug 1. But when I remove WHERE filter, it runs just fine and returns millions of series.
SHOW SERIES FROM "livemetrics"
Bug 2. I really want to keep WHERE time filter and add LIMIT 10, but still get the same error
SHOW SERIES FROM "livemetrics" WHERE time > 1570114082s LIMIT 10
This behavior is inconsistent.
I am also surprised that SHOW SERIES is subject to series limits.
InfluxDB OSS 1.7.8
Thank you very much.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.