[collectd] parse errors on predefined postgresql plugin queries

[Aaron Vinson]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.verplant.org/pipermail/collectd/attachments/20160621/7a9d2ed8/attachment.html>