influxdata / influxdata/influxdb
missing measurements in show measurements
Nobody has claimed this yet.
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
I'm using influxdb-1.7.7-1.
I am not able to list all the measurements in the database, neither from influxdb CLI nor from Grafana. However, I am able to fetch the contents of unlisted measurements.
The data is being pushed from a python program and measurements are dynamically created, and the measurement name is uploaded in string format.
```
> show measurements
name: measurements
name
----
287493
287494
287496
287515
287517
287523
287524
287525
287526
287527
287530
287532
287533
287534
287535
287536
287537
287541
287573
287691
> select "MEM" from "287782"
name: 287782
time MEM
---- ---
1631081112987773200 5
1631081145591863700 59
1631081178187028500 103
1631081210738190500 771
1631081243288976600 124
1631081275842197500 87
1631081308893271800 198
1631081341726734300 198
1631081374567554500 209
1631081407501610600 137
1631081440342052600 141
1631081473178180900 146
1631081506247356500 187
1631081539084222900 226
1631081571940585400 144
1631081604788969500 169
1631081637651767400 371
1631081670500279100 939
1631081703343545700 1338
1631081736444318300 1397
>
```
As you can see measurement ```287782``` is not listed in the available measurements but I can still fetch the contents from it.
Is there any limitation on the number of measurements that can be displayed for ```show measurements```? If so, how can I list all the available measurements?
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.
Research direction
Start by reproducing the SHOW MEASUREMENTS result on InfluxDB 1.7.7 using dynamically created numeric measurement names, then compare it with a direct SELECT from an omitted measurement. Check both the InfluxDB CLI and Grafana paths. Done means the listing behavior or limitation is established and a reliable way to list all available measurements is identified.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- grafana, python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100