Without the raw data we can't recreate it. Can you upload the raw points to a gist, perhaps?
On Thu, Nov 3, 2016 at 9:46 AM, <[email protected]> wrote: > I tried to upload the same data in a different computer with influxdb > v0.13 installed and all works. > > I think is an issue of influx new version. > > > > Il giorno mercoledì 2 novembre 2016 17:57:33 UTC+1, Sean Beckett ha > scritto: > > On Wed, Nov 2, 2016 at 7:57 AM, <[email protected]> wrote: > > Hi all, > > > > after upgrading influxdb from 0.13 to 1.0 I notice some problems when I > insert data with identical measurement name, tag and timestamp writing > multiple points from different files: with old version the points were > overwritten but now points are duplicate. > > > > > > > > There is no change in behavior between 0.13 and 1.0 when it comes to > duplicate measurement, tagset and timestamps. The duplicates are stored as > the union of the field sets, but the overall point count would be the same. > > The files that I used is of this type: > > > > cumulato,matricola_contatore=1012-008-5647 value=85.627 > 1476286500000000000 > > > > cumulato,matricola_contatore=1012-008-5647 value=85.627 > 1476286200000000000 > > > > cumulato,matricola_contatore=1012-008-5647 value=85.627 > 1476285900000000000 > > > > (...) > > > > > > > > The files contain one value from 291 different sources every 5 minutes > so every day I should have 83808 (291*24*12) points. > > > > I insert data in two different moments and the time series have 5 days > during which they overlap. > > > > > > > > This is the result of the query SELECT COUNT(value) FROM cumulato WHERE > time>='2016-10-01T00:00:00Z' AND time<='2016-10-25T23:55:00Z' GROUP BY > time(1d) > > > > > > > > name: cumulato > > > > -------------- > > > > time count > > > > 1475280000000000000 83808 > > > > 1475366400000000000 83808 > > > > 1475452800000000000 83808 > > > > 1475539200000000000 83808 > > > > 1475625600000000000 83808 > > > > 1475712000000000000 83808 > > > > 1475798400000000000 83808 > > > > 1475884800000000000 85175 > > > > 1475971200000000000 103426 > > > > 1476057600000000000 126510 > > > > 1476144000000000000 130752 > > > > 1476230400000000000 106096 > > > > 1476316800000000000 83983 > > > > 1476403200000000000 83808 > > > > 1476489600000000000 83808 > > > > 1476576000000000000 83808 > > > > 1476662400000000000 83808 > > > > 1476748800000000000 83808 > > > > 1476835200000000000 83808 > > > > 1476921600000000000 83808 > > > > 1477008000000000000 83808 > > > > 1477094400000000000 83808 > > > > 1477180800000000000 83808 > > > > 1477267200000000000 83808 > > > > 1477353600000000000 83808 > > > > > > > > > > > > How can I solve this issue? > > > > > > > > For some reason, the points are distinct. Either they have distinct > measurements, tag sets, or timestamps. I recommend looking at the raw data > from those days to determine what is not as expected. > > > > > > > > -- > > > > 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/be14a610-7e56-4022-9a35-62762d41ff37%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > -- > > > > > > Sean Beckett > > Director of Support and Professional Services > > InfluxDB > > -- > 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/307b1b37-6238-4d5a-8767-4f2680a7dfad%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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/CALGqCvOFsb6XmPSo8AUTdCjwGG2%3DW%3DMcW9MpEbpNaTvgc8sDqQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
