Package: munin-plugins-core Version: 2.0.21-2 Severity: normal Dear Maintainer,
All Postgresql graphs generate an error since a recent upgrade of PostgreSQL. The munin-nonde.log file reads: 2014/09/26-08:50:09 [29076] Error output from postgres_autovacuum: 2014/09/26-08:50:09 [29076] Unable to detect PostgreSQL version 2014/09/26-08:50:09 [29076] Service 'postgres_autovacuum' exited with status 255/0. 2014/09/26-08:50:10 [29076] Error output from postgres_autovacuum: 2014/09/26-08:50:10 [29076] Unable to detect PostgreSQL version 2014/09/26-08:50:10 [29076] Service 'postgres_autovacuum' exited with status 255/0. 2014/09/26-08:50:12 [29076] Error output from postgres_locks_ALL: 2014/09/26-08:50:12 [29076] Unable to detect PostgreSQL version 2014/09/26-08:50:12 [29076] Service 'postgres_locks_ALL' exited with status 255/0. 2014/09/26-08:50:13 [29076] Error output from postgres_locks_ALL: 2014/09/26-08:50:13 [29076] Unable to detect PostgreSQL version 2014/09/26-08:50:13 [29076] Service 'postgres_locks_ALL' exited with status 255/0. 2014/09/26-08:50:30 [29076] Error output from postgres_xlog: 2014/09/26-08:50:30 [29076] Unable to detect PostgreSQL version 2014/09/26-08:50:30 [29076] Service 'postgres_xlog' exited with status 255/0. 2014/09/26-08:50:31 [29076] Error output from postgres_xlog: 2014/09/26-08:50:31 [29076] Unable to detect PostgreSQL version 2014/09/26-08:50:31 [29076] Service 'postgres_xlog' exited with status 255/0. [snip] The blog entry <http://cosmicb.no/2013/02/> provided the solution, which is that the plugin fails to detect PostgreSQL version. I checked the output directly for psql and got this: postgres@b3:~$ psql psql (9.4beta2) Type "help" for help. postgres=# select version(); version ----------------------------------------------------------------------------------------------------- PostgreSQL 9.4beta2 on armv7l-unknown-linux-gnueabi, compiled by gcc (Debian 4.9.1-5) 4.9.1, 32-bit (1 row) postgres=# Looking in /usr/share/perl5/Munin/Plugin/Pgsql.pm, the regexp for the version number extraction is /^PostgreSQL (\d+)\.(\d+)(\.\d+|devel)\b/. This implies that regular numbers or even an added "devel" would be recognized versions, but "9.4beta2" is not, due to the "beta". Fixing the regular expression by adding an thris alternative with beta and some numbers afterwards solves the problem (see patch). -- System Information: Debian Release: jessie/sid APT prefers testing APT policy: (990, 'testing'), (980, 'stable-updates'), (980, 'stable'), (90, 'experimental') Architecture: armel (armv5tel) Kernel: Linux 3.2.62-1 Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages munin-plugins-core depends on: ii munin-common 2.0.21-2 ii perl 5.20.0-6 Versions of packages munin-plugins-core recommends: ii libnet-snmp-perl 6.0.1-2 Versions of packages munin-plugins-core suggests: pn conntrack <none> pn libnet-netmask-perl <none> pn libnet-telnet-perl <none> ii libxml-parser-perl 2.41-3 ii python 2.7.8-1 pn ruby | ruby-interpreter <none> -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
