Unexpected duplicate values

InfluxDB 2
1

Hi!

I’m seeing duplicate records when, from the docs, I expect to overwriting to occur.

I had some data and (via python API) added more at the same _time with the same group key.
See below for a minimal example. I perhaps misunderstand, but expected _value to be overwrite. I now have a ‘duplicate’ point and can’t differentiate them.

I’ve tried

  • restarting Influxd
  • waiting 24h in case influxd does some background cleanup
  • triple checking group key is the same value/type

Possibly related:

Probably related: the error I receive running a mean() :

runtime error @28:6-28:12: mean: aggregate found duplicate table with key: {_field=Watts,_measurement=iotawatt,_start=2023-07-20T16:07:32.890000000Z,_stop=2023-07-23T12:17:29.340000000Z,device=andrea,sensor=ConsumptionNet,units=Watts}

What am I missing?

Thanks, Brett

#
# The query,
#
from(bucket: "iotawatt")
   |> range(start: 2023-07-23T12:22:50.44Z, stop: 2023-07-23T12:23:50.44Z)
  |> filter(fn: (r) => r.device == "andrea" and
                       r.sensor == "Consumption"
              )     

#
#  Result from  "cat flux/double-point.flux | influx query
#
Result: _result
Table: keys: [_start, _stop, _field, _measurement, device, sensor, units]
                   _start:time                      _stop:time           _field:string     _measurement:string           device:string           sensor:string            units:string                      _time:time                  _value:float
------------------------------  ------------------------------  ----------------------  ----------------------  ----------------------  ----------------------  ----------------------  ------------------------------  ----------------------------
2023-07-23T12:22:50.440000000Z  2023-07-23T12:23:50.440000000Z                   Watts                iotawatt                  andrea             Consumption                   Watts  2023-07-23T12:23:00.000000000Z                       4378.37
Table: keys: [_start, _stop, _field, _measurement, device, sensor, units]
                   _start:time                      _stop:time           _field:string     _measurement:string           device:string           sensor:string            units:string                      _time:time                  _value:float
------------------------------  ------------------------------  ----------------------  ----------------------  ----------------------  ----------------------  ----------------------  ------------------------------  ----------------------------
2023-07-23T12:22:50.440000000Z  2023-07-23T12:23:50.440000000Z                   Watts                iotawatt                  andrea             Consumption                   Watts  2023-07-23T12:23:00.000000000Z                       4435.97

ps I am using

  • Influx OSS on Ubuntu 22
  • Influx CLI dev (git: none) build_date: 2023-04-28T14:24:14Z
  • InfluxDB v2.7.1 (git: 407fa622e9) build_date: 2023-04-28T13:24:27Z