Re: Postgresql 9.4.4: ERROR: bigint out of range

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(dot)klaver(at)aklaver(dot)com