Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

show tag keys returns empty rows #9545

Closed
scotloach opened this issue Mar 10, 2018 · 2 comments · Fixed by #9573
Closed

show tag keys returns empty rows #9545

scotloach opened this issue Mar 10, 2018 · 2 comments · Fixed by #9573
Assignees
Labels
area/queries difficulty/low Resolving this issue should take a day or two. kind/bug
Milestone

Comments

@scotloach
Copy link

Bug report

System info: InfluxDB 1.5 built from standard docker container, inmem indexes.

Steps to reproduce:

I updated from 1.4 to 1.5 on a large system with multiple databases.
Since the upgrade, I noticed that on some (but not all) of the databases, a "show tag keys from ." query returns the first row as an empty string, and then the actual tag keys associated with the measurement.

Looks like a regression from 1.4.

Here is actual output, with names redacted.

> show tag keys from "autogen"."meas"
name: meas
tagKey
------

tag1
tag2
tag3
tag4
tag5
tag6
tag7
tag8
tag9
tag10
@e-dard
Copy link
Contributor

e-dard commented Mar 13, 2018

@scotloach do you have some test data that can be used to reproduce this issue?

@e-dard
Copy link
Contributor

e-dard commented Mar 14, 2018

Reproduced with the following:

CREATE DATABASE ""
USE 
INSERT cpu,tag0=v\, value=1
SHOW TAG KEYS

Results in:

name: cpu
tagKey
------

tag0

Also, rather than this being a formatting issue, it looks like the index is seeing multiple tag keys:

> SHOW TAG KEY CARDINALITY
name: cpu
count
-----
2
>

Yet:

> SHOW SERIES
key
---
cpu,tag0=v\,
>

It's affecting both inmem and tsi1. I have confirmed it's not in 1.4.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/queries difficulty/low Resolving this issue should take a day or two. kind/bug
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants