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

[pc10201]

[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]

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]

I have upgrade telegraf from 1.8 to 1.9.

I use qcloud.com rds

[danielnelson]

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