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 data in DB #19262

Closed
fxfactorial opened this issue Aug 8, 2020 · 2 comments
Closed

Duplicate data in DB #19262

fxfactorial opened this issue Aug 8, 2020 · 2 comments

Comments

@fxfactorial
Copy link

I saw this open issue and it seems there is still an issue with duplicate data, or perhaps I'm querying incorrectly #13989

This is my query kicked off via the golang sdk , on 1.8 , but i confirmed the results on the chronograf

from(bucket: "pairs/")
	  |> range(start: -7d)
	  |> filter(fn: (r) =>
       r._measurement == "ETH-USD" and
       (r._field == "price" and r.side == "buy")
    )
	  |> toFloat()
	  |> timedMovingAverage(every: 12h, period: 1d)
    |> sort(columns: ["_time"])

printing out the golang map, I get

map[_field:price _measurement:ETH-USD _start:2020-08-01 22:36:23.400033863 +0000 UTC _stop:2020-08-08 22:36:23.400033863 +0000 UTC _time:2020-08-08 22:36:23.400033863 +0000 UTC _value:389.40864406779684 exchange:coinbase result:_result side:buy table:0]
map[_field:price _measurement:ETH-USD _start:2020-08-01 22:36:23.400033863 +0000 UTC _stop:2020-08-08 22:36:23.400033863 +0000 UTC _time:2020-08-08 22:36:23.400033863 +0000 UTC _value:389.40864406779684 exchange:coinbase result:_result side:buy table:0]

and the chronograf duplicate
Screenshot from 2020-08-08 18-42-31

today is my first day every touching flux so its possible I'm writing the query wrong, but I am def surprised to see two exact same rows produced

@russorat russorat added 1.x and removed 1.x labels Sep 1, 2020
@russorat
Copy link
Contributor

russorat commented Sep 1, 2020

@fxfactorial sorry for the delay here. did you ever figure out what was happening here?

if not, is it possible to narrow the time frame and provide sample data?

@fxfactorial
Copy link
Author

no, didn't figure out , have since stopped using influxdb, can close if like

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

2 participants