On 08/10/2015 06:23 AM, Arthur Chan wrote:
Hi,
I have installed 9.4.4 and repmgr 3.0.1 (installed by using "yum install
repmgr"). From the system log, I found many errors with same type:
ERROR: bigint out of range
STATEMENT: INSERT INTO "repmgr_pg_cluster".repl_monitor
(primary_node, standby_node, last_monitor_time,
last_apply_time, last_wal_primary_location,
last_wal_standby_location, replication_lag, apply_lag )
VALUES(1, 2, '2015-07-31 13:18:24.91771+08'::TIMESTAMP
WITH TIME ZONE, '2015-07-31 13:18:22.73631+08'::TIMESTAMP WITH TIME
ZONE, '5F/74000000', '5F/737C0000', 8650752,
18446744073700900864)
ERROR: bigint out of range ......
FYI, the schema definition for repmgr_pg_cluster".repl_monitor would be
helpful.
http://www.postgresql.org/docs/9.4/interactive/datatype-numeric.html#DATATYPE-INT
bigint 8 bytes large-range integer -9223372036854775808 to
+9223372036854775807
18446744073700900864
9223372036854775807
The value being entered for apply_lag is too big for the field,
Any idea how to resolve it?
Find out what is generating such a big number for apply_lag. I doubt
that is the real number. Probably something to ask the repmgr folks.
Regards
Arthur
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
