Error writing to outputs.sql: ERROR: type "double" does not exist (SQLSTATE 42704)

[Waqas_Rana]

View in #telegraf on Slack

@Waqas_Rana: Hi, I have updated it to 1.19.2 and testing the output.sql for Postgres with the following configurations

[[outputs.sql]]
driver = "pgx"
data_source_name = "<postgres://postgres:postgres@10.32.22.179:5438/postgres>"

2021-07-30T13:37:38Z I! Starting Telegraf 1.19.2
2021-07-30T13:37:38Z I! Using config file: /etc/telegraf/telegraf.conf
2021-07-30T13:37:38Z I! Loaded inputs: snmp snmp_trap
2021-07-30T13:37:38Z I! Loaded aggregators:
2021-07-30T13:37:38Z I! Loaded processors:
2021-07-30T13:37:38Z I! Loaded outputs: influxdb_v2 sql
2021-07-30T13:37:38Z I! Tags enabled: host=6342c9d3bc82
2021-07-30T13:37:38Z I! [agent] Config: Interval:1m0s, Quiet:false, Hostname:"6342c9d3bc82", Flush Interval:10s
2021-07-30T13:37:38Z D! [agent] Initializing plugins
2021-07-30T13:37:38Z D! [agent] Connecting outputs
2021-07-30T13:37:38Z D! [agent] Attempting connection to [outputs.influxdb_v2]
2021-07-30T13:37:38Z D! [agent] Successfully connected to outputs.influxdb_v2
2021-07-30T13:37:38Z D! [agent] Attempting connection to [outputs.sql]
2021-07-30T13:37:38Z D! [agent] Successfully connected to outputs.sql
2021-07-30T13:37:38Z D! [agent] Starting service inputs
2021-07-30T13:37:38Z I! [inputs.snmp_trap] Listening on udp://:162

The plugin is connecting and loading fine but I am getting the following error while it tries to metrics.

2021-07-30T12:57:37Z E! [agent] Error writing to outputs.sql: ERROR: type "double" does not exist (SQLSTATE 42704)

Please help

[mattesilver]

Old post, so I guess I’m answering for posterity

Take a look at [outputs.sql.convert] section of your outputs.sql configuration. Telegraf is not smart enough to use the right types, so you need to configure the right one.
I used decimal(10,2) for my needs.

Haven’t found a way to configure it per column yet. It’s my first day with Telegraf

Chapter 8. Data Types