Need help with a minor issue troubling my telegraf conf file. The telegraf logs shows this repeating error and I can’t find what I’m doing wrong. It’s a simple query to Solar Assistant to extract its data into my Influxdb/telegraf/mosquitto/grafana Pi4. My output to Grafana is working fine. The dashboard looks and works great. Just trying to get this cleared up before I move forward.
telegraf logs….
2025-11-17T15:13:05Z E! [agent] Error writing to outputs.influxdb_v2: failed to write metrics to solar_data (will be dropped: 422 Unprocessable Entity): unprocessable entity: failure writing points to database: partial write: field type conflict: input field “value” on measurement “mqtt_consumer” is type string, already exists as type float dropped=4
2025-11-17T15:13:15Z E! [outputs.influxdb_v2] failed to write metrics to solar_data (will be dropped: 422 Unprocessable Entity): unprocessable entity: failure writing points to database: partial write: field type conflict: input field “value” on measurement “mqtt_consumer” is type string, already exists as type float dropped=4
Here’s the redacted telegraf:
[agent]
interval = “15s”
debug = true
[[inputs.cpu]]
percpu = true
totalcpu = true
[[inputs.mqtt_consumer]]
servers = [“tcp://192.168.5.xx:1883”]
topics = [“solar_assistant/#”]
username = “marbob”
password = “pi”
client_id = “telegraf-eg4”
topic_tag = “topic”
data_format = “value”
data_type = “auto_float”
qos = 1
[[outputs.influxdb_v2]]
urls= [“http://192.168.5.xxx:8086”]
token= "influx_token>
organization = “Boxoxox”
bucket= “solar_data”
Here are the SA topics.
solar_assistant/inverter_1/device_mode/state Solar/Battery
solar_assistant/inverter_1/load_power_1/state 58
solar_assistant/inverter_1/grid_voltage/state 0.0
solar_assistant/inverter_1/grid_power_ct_2/state 0
solar_assistant/inverter_1/ac_output_frequency/state 59.99
solar_assistant/inverter_1/grid_power_ld/state 0
solar_assistant/inverter_1/ac_output_voltage/state 240.0
solar_assistant/inverter_1/load_power/state 67
solar_assistant/inverter_1/pv_power_2/state 583
solar_assistant/total/battery_power/state 1018
solar_assistant/total/battery_state_of_charge/state 81
solar_assistant/total/battery_temperature/state 86.0
solar_assistant/inverter_1/grid_frequency/state 0.0
solar_assistant/inverter_1/pv_current_1/state 3.568840579710145
solar_assistant/inverter_1/grid_power_ct/state 0
solar_assistant/inverter_1/pv_power/state 1174
solar_assistant/inverter_1/battery_voltage/state 53.2
solar_assistant/inverter_1/pv_current_2/state 3.5965453423812463
solar_assistant/inverter_1/temperature/state 87.8
solar_assistant/inverter_1/grid_power_ct_1/state 0
solar_assistant/inverter_1/battery_current/state 19.13533834586466
solar_assistant/inverter_1/load_power_2/state 10
solar_assistant/inverter_1/grid_power/state 0
solar_assistant/inverter_1/pv_voltage_1/state 165.6
solar_assistant/inverter_1/pv_voltage_2/state 162.1
solar_assistant/inverter_1/grid_power_ld_1/state 0
solar_assistant/inverter_1/pv_power_1/state 591
solar_assistant/inverter_1/grid_power_ld_2/state 0
