On Wed, Nov 2, 2016 at 7:57 AM, <cslfn...@unife.it> 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 influxdb+unsubscr...@googlegroups.com. > To post to this group, send email to influxdb@googlegroups.com. > 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 influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/CALGqCvOxHQSLYPTsFz4A2WeuYBFCxmXhi1gEBAS2zSShm8tFOw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
