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

duplicate series with the same tag set #6771

Closed
zarnovican opened this issue Jun 2, 2016 · 1 comment
Closed

duplicate series with the same tag set #6771

zarnovican opened this issue Jun 2, 2016 · 1 comment
Assignees
Milestone

Comments

@zarnovican
Copy link

Bug report

System info: InfluxDB 0.13.0, Ubuntu Trusty 64-bit

Steps to reproduce:

# create db
curl -POST http://localhost:8086/query --data-urlencode "q=CREATE DATABASE mydb"
# insert two datapoints for the same series, but different tag order
curl -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'm,a=1,b=2,c=3 value=42'
curl -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'm,b=2,a=1,c=3 value=42'

Expected behavior: I would expect only one series to be created.

> show series
key
m,a=1,b=2,c=3

Actual behavior: There are two series, with the same tag set.

> show series
key
m,a=1,b=2,c=3
m,b=2,a=1,c=3

Additional info:

If you would test it with two tags..

curl -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'm,a=1,b=2 value=42'
curl -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'm,b=2,a=1 value=42'

..it would work as expected.

What's worse, if you write datapoint for the same time, it will create "duplicate" datapoint.

curl -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'm,a=1,b=2,c=3 value=10 1434055566000000000'
curl -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'm,b=2,a=1,c=3 value=20 1434055566000000000'
> select * from m
name: m
-------
time            a   b   c   value
1434055566000000000 1   2   3   10
1434055566000000000 1   2   3   20
@nordewal
Copy link

nordewal commented Jun 8, 2016

I can confirm this bug on InfluxDB 0.13.0, RHEL 7.2 64-bit

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants