[check_postgres] ERROR: Cannot test replication: values are not the same
Greg Sabino Mullane
greg at endpoint.com
Sat Dec 6 18:02:56 UTC 2014
On Fri, Dec 05, 2014 at 04:25:28PM +0530, Juned Khan wrote:
> Greg, I think problem is, sometimes it takes too long to update values so
> tried with increasing timeout parameter.
>
> root at db02:/usr/lib/nagios/plugins# ./check_nrpe -H server-ip -c
> check_replication_astpp --timeout=20
> CHECK_NRPE: Socket timeout after 20 seconds.
> root at db02:/usr/lib/nagios/plugins# ./check_nrpe -H server-ip -c
> check_replication_astpp --timeout=30
> ERROR: Cannot test replication: values are not the same
How long until this message appears in the command where the timeout
is 30? Based on these two messages, I would say your replication is
not working as it should, or at least is not firing right away. Is
there a trigger on the table in question? If you manually change
it on server one via psql, can you get an idea of how long it takes
to have the value changed on server two?
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20141206/dc79c2f2/attachment.sig>
More information about the Check_postgres
mailing list