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.klaver@aklaver.com