Influxdb error with datatype of "state"

Third party integrations
1

Hi,

I’m using the influxdb integration to write some sensor values into influxdb

My config is like so:

  host: a0d7b954-influxdb
  port: 8086
  database: hass
  username: hass 
  password: elided
  max_retries: 3
  default_measurement: state
  tags_attributes:
    - friendly_name
    - FeedName
    - device_class
    - Tag

I’m getting this error in my home-assistant.log:

2019-12-30 19:23:33 ERROR (InfluxDB) [homeassistant.components.influxdb] Write error: 400: {"error":"partial write: field type conflict: input field \"state\" on measurement \"state\" is type string, already exists as type float dropped=1"}
2019-12-30 19:23:34 ERROR (InfluxDB) [homeassistant.components.influxdb] Resumed, lost 1 events
2019-12-30 19:25:34 ERROR (InfluxDB) [homeassistant.components.influxdb] Write error: 400: {"error":"partial write: field type conflict: input field \"state\" on measurement \"state\" is type string, already exists as type float dropped=1"}
2019-12-30 19:25:35 ERROR (InfluxDB) [homeassistant.components.influxdb] Resumed, lost 14 events
2019-12-30 19:27:35 ERROR (InfluxDB) [homeassistant.components.influxdb] Write error: 400: {"error":"partial write: field type conflict: input field \"state\" on measurement \"state\" is type string, already exists as type float dropped=1"}
2019-12-30 19:27:36 ERROR (InfluxDB) [homeassistant.components.influxdb] Resumed, lost 14 events

How do I go about figuring out the sensor(s) that are causing the problem and in any event how to fix it.

I presume that Influxdb “guessed” the type as float based on an initial value but later values can’t be parsed as floats?

Thanks,
Steve

2

I have the same problem, did you ever fix it?