Package: munin-node Version: 1.4.0-1 Severity: normal The postgres_querylength_ plugin fails on PostgreSQL 8.4.1 | $ /etc/munin/plugins/postgres_querylength_bacula | DBD::Pg::st execute failed: ERROR: syntax error at or near "AND" | LINE 3: ..._TIMESTAMP-xact_start)),0) FROM pg_stat_activity AND datnam... | ^ at /usr/share/perl5/Munin/Plugin/Pgsql.pm line 389. | Query failed!
This is probably caused by the query | "SELECT 'query',COALESCE(max(extract(epoch FROM | CURRENT_TIMESTAMP-query_start)),0) FROM pg_stat_activity WHERE current_query | NOT LIKE '<IDLE%' %%FILTER%% UNION ALL SELECT | 'transaction',COALESCE(max(extract(epoch FROM | CURRENT_TIMESTAMP-xact_start)),0) FROM pg_stat_activity %%FILTER%%", because filter is defined as | wildcardfilter => " AND datname=?", so the query in the end looks like | "[…] FROM pg_stat_activity AND datname='bacula'" Greets Moritz -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
