input field "version_comment" on measurement "mysql_variables" is type string, already exists as type float dropped=4; discarding points

influxdata / telegraf

Agent for collecting, processing, aggregating, and writing metrics, logs, and other arbitrary data.

https://influxdata.com/telegraf

MIT License

14.48k stars 5.54k forks source link

input field "version_comment" on measurement "mysql_variables" is type string, already exists as type float dropped=4; discarding points #5076

Closed pc10201 closed 5 years ago

pc10201 commented 5 years ago

[Include Telegraf version, operating system name, and other relevant details]

telegraf version:19.0

influxdb version:17.1

2018-12-01T07:46:40Z E! [outputs.influxdb]: when writing to [xxxx:8086]: received error partial write: field type conflict: input field "version_comment" on measurement "mysql_variables" is type string, already exists as type float dropped=4; discarding points

turn log on of telegraf conf

glinton commented 5 years ago

Did you change versions on the mysql db you are monitoring? This can cause issues like this, especially on major version changes as occasionally the types/tables change slightly.

pc10201 commented 5 years ago

I have upgrade telegraf from 1.8 to 1.9.

I use qcloud.com rds

danielnelson commented 5 years ago

I think this is the same issue as #5055, let's follow up over on that issue.