Bug 79 – Error in pgm for action "query_time"

Bug 79 - Error in pgm for action "query_time"

Summary:

Error in pgm for action "query_time"

Status:	RESOLVED FIXED

Product:	check_postgres
Component:	General
Version:	unspecified
Platform:	All All

Importance:	Normal minor
Assigned To:	Greg Sabino Mullane

URL:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2011-06-22 09:05 EDT by Fabrice Metge
Modified:	2011-06-22 16:04 EDT (History)
CC List:	1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note

You need to log in before you can comment on or make changes to this bug.

Description Fabrice Metge 2011-06-22 09:05:29 EDT

Hi,
First, I got to say you that I like your work about perl, postgresql,
monitoring. Brief, BRAVO.

There is an error when you execute "query_time", because postgres user doesn't
have "client_addr" and "client_port" for "local operations" (autovacuum...).

Error is : Argument "" isn't numeric in numeric lt (<) at ./check_postgres.pl
line 4576.

# I replaced next :
$client_port < 1 ? '' : (sprintf ' %s:%s', msg('port'), $client_port),
$client_port lt 1 ? '' : (sprintf ' %s:%s', msg('port'), $client_port),

Fabrice Metge

Comment 1 Greg Sabino Mullane 2011-06-22 16:04:17 EDT

Proposed fix in ce3e0d13a293b9435ff01bde2b6c140c3129b8c7