The indentation is hard to follow in a variable width font. Can you post
the JSON output? (i.e. from the influx CLI run `format json` and then your
query `select * from "metricId_1_intervalId_5" where time >=
'2014-01-13T01:00:00Z' and sourceId = '315' limit 10`.

It looks like maybe the forecastOffset tag is 0 in half of the points and
absent in the other half, in which case I believe the system is behaving as
expected. If it isn't that, are you able to try running with 1.2?

On Thu, Feb 9, 2017 at 10:02 AM, Davis Kirkendall <
[email protected]> wrote:

> I'm trying to track down some weird behavior in Influxdb 1.1
>
>
> > select * from "metricId_1_intervalId_5" where time >=
> '2014-01-13T01:00:00Z' and sourceId = '315' limit 10
>
> name: metricId_1_intervalId_5
> -----------------------------
> time                  flags   forecastOffset  intervalId      sensorId
>      sign    sourceId        statId  value
> 1389574800000000000        0                       5               132
>           1       315             0       152800
> 1389574800000000000                               5               132
>         1       315             0       152800
> 1389575700000000000       0                       5               132
>         1       315             0       160000
> 1389575700000000000                               5               132
>         1       315             0       160000
> 1389576600000000000       0                       5               132
>         1       315             0       183200
> 1389576600000000000                               5               132
>         1       315             0       183200
> 1389577500000000000       0                       5               132
>         1       315             0       111200
> 1389577500000000000                               5               132
>         1       315             0       111200
> 1389578400000000000       0                       5               132
>         1       315             0       158400
> 1389578400000000000                               5               132
>         1       315             0       158400
>
> The interesting part is that "flags" and "values" are fields, meaning that
> there should be no way for duplicate points such as [1,2], [3,4] and so on
> to exist since timestamp and tag set are the same.
>
> > show field keys from metricId_1_intervalId_5
>
> name: metricId_1_intervalId_5
> -----------------------------
> fieldKey  fieldType
> value          float
> flags              float
>
>
> Am I missing something or has anyone experienced something comparable
> before?  Could this be some sort of bug with the sharding process?
>
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/85f0e693-33d9-4fca-af79-8c1723d732bb%40googlegroups.com
> <https://groups.google.com/d/msgid/influxdb/85f0e693-33d9-4fca-af79-8c1723d732bb%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CALxJwdPEcDhCD3NZ5EwYyhF2DJ5UBGnxPHUweSVCqNpnkXvibg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to