I'm attempting to use collectd postgresql plugin to monitor a Postgres 9.5.2 RDS instance. I've created a user with the correct permissions and tested the queries manually. The predefined "transactions" query works as expected but many of the others such as "queries" and "query_plans" result in the following error:
Initialization complete, entering read-loop. Successfully connected to database postgres (user perf_user) at server redacted:5432 (server version: 9.5.2, protocol version: 3, pid: 25691) parse_value: Failed to parse string as derive: . db query utils: udb_result_submit: Parsing `' as derive failed. parse_value: Failed to parse string as derive: . db query utils: udb_result_submit: Parsing `' as derive failed. parse_value: Failed to parse string as derive: . db query utils: udb_result_submit: Parsing `' as derive failed. db query utils: udb_query_handle_result (flurish_etl, row_stats): All results failed. postgresql: udb_query_handle_result failed with status -1. I've tried collectd 5.5.1 and 5.4.2 with identical results. Any tips are appreciated. What's the best way for me to troubleshoot this? Best, -Aaron
_______________________________________________ collectd mailing list collectd@verplant.org https://mailman.verplant.org/listinfo/collectd