[check_postgres] error on sequence with bigint
Scott Marlowe
scott.marlowe at gmail.com
Wed Nov 5 00:02:21 UTC 2008
Trying to run 2.4.0 against a database with bigserial / bigsequences
and I get this:
bin/check_postgres.pl -db www --action=sequence --warning=95%
ERROR: ERROR: bigint out of range
If I turn on -v three times, I get some output at the end like this:
Starting run_command with "SELECT last_value, slots, used,
ROUND(used/slots*100) AS percent, slots - used AS numleft FROM
(SELECT last_value,
CEIL((max_value-min_value+1)/increment_by::NUMERIC) AS slots,
CEIL((last_value-min_value+1)/increment_by::NUMERIC) AS used FROM
_slony_www.sl_local_node_id) foo"
$POSTGRES1 = [
"-q",
"-U",
"postgres",
"-d",
"www",
"-t",
"-p",
5432,
"-o",
"/tmp/VZ2MvOnl41/check_postgres_psql.PJCQuzv.tmp",
"-c",
"SELECT last_value, slots, used, ROUND(used/slots*100)
AS percent, slots - used AS numleft FROM (SELECT last_value,
CEIL((max_value-min_value+1)/increment_by::NUMERIC) AS slots,
CEIL((last_value-min_value+1)/increment_by::NUMERIC) AS used FROM
_slony_www.sl_local_node_id) foo"
];
System call failed with a 256
ERROR: ERROR: bigint out of range
I'm wondering if the problem is actually too many sequences...
More information about the Check_postgres
mailing list