influxdata / influxdata/influxdb

show tag values unexpected behavior

Open
#14,375 2 comments 1 reaction 0 assignees View on GitHub
1.x
Dominant language
Rust
Stars
31.7k
Forks
3.7k
Avg merge
13h 37m
Merged PRs (30d)
8

Description

__scenario__

__query:__
`show tag value with key="mykey"`

__Actual and expected behavior:__
```
name: data
key value
--- -----
mykey aaa
mykey bbb
mykey ccc
.....
```

__query:__
`show tag value with key="mykey" where mykey='aaa'`

__Actual behavior__
empty

__Expected behavior__
```
name: data
key value
--- -----
mykey aaa
```

__query:__
`show tag value with key="mykey" where mykey=~/^a.*/`

__Actual behavior__
empty

__Expected behavior__
```
name: data
key value
--- -----
mykey aaa
```

__query:__
`select * from data where mykey='aaa'`

__Actual and expected behavior:__
NOT empty

__additional notes:__

1. the problem seems to affect the series which have "holes" in the time span i.e. maybe not all the tsm files contain all the series
2. the problem vanishes after a restart

__Environment and System Info__

system: debian stretch Linux 4.9.0-6-amd64 x86_64
InfluxDB: 1.5.2
index-version = "inmem"
db with a 30d retention policy

Contributor guide

Open the contributing guide

Research direction

Start at the SHOW TAG VALUES query path and compare its filtering with SELECT handling, focusing on series with holes across TSM files. Reproduce the literal and regex queries in the reported InfluxDB 1.5.2, 30-day retention setup, then verify both return aaa consistently without requiring a restart.

Written by the indexing model from the issue text.

Assessment

Tech stack
go
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.