stevenewey / octograph

Python tool for extracting Octopus Energy meter readings to InfluxDB
98 stars 49 forks source link

Field type conflict on initial import #5

Open GadgetUK opened 4 years ago

GadgetUK commented 4 years ago

Just tried to do an initial import, and get the following error

Original exception was: Traceback (most recent call last): File "app/octopus_to_influxdb.py", line 223, in <module> cmd() File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 764, in __call__ return self.main(*args, **kwargs) File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 717, in main rv = self.invoke(ctx) File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 956, in invoke return ctx.invoke(self.callback, **ctx.params) File "/usr/local/lib/python3.6/dist-packages/click/core.py", line 555, in invoke return callback(*args, **kwargs) File "app/octopus_to_influxdb.py", line 209, in cmd store_series(influx, 'electricity', e_consumption, rate_data['electricity']) File "app/octopus_to_influxdb.py", line 114, in store_series connection.write_points(measurements) File "/usr/local/lib/python3.6/dist-packages/influxdb/client.py", line 490, in write_points tags=tags, protocol=protocol) File "/usr/local/lib/python3.6/dist-packages/influxdb/client.py", line 551, in _write_points protocol=protocol File "/usr/local/lib/python3.6/dist-packages/influxdb/client.py", line 327, in write headers=headers File "/usr/local/lib/python3.6/dist-packages/influxdb/client.py", line 286, in request raise InfluxDBClientError(response.content, response.status_code) influxdb.exceptions.InfluxDBClientError: 400: {"error":"partial write: field type conflict: input field \"consumption\" on measurement \"electricity\" is type float, already exists as type integer dropped=1"}