Re: Why does “failed protocol test [PGSQL]” happen when system is under load, or how to troubleshoot?

[address@hidden]

Hi,

the error is most probably caused by timeout ... you can catch and verify the 
communication between monit and postgresql for example using Wireshark. 

Best regards,
Martin


> On 9 Apr 2019, at 23:23, Support Team <address@hidden> wrote:
> 
> The error from Monit:
> 
> [EDT Apr 9 12:40:45] error : 'pgbouncer' failed protocol test [PGSQL] at 
> [127.0.0.1]:6432 [TCP/IP] -- PGSQL: error receiving data -- Resource 
> temporarily unavailable
> 
> This happened while the system was under higher-than-normal load (nginx was 
> handling about 330 requests/second vs. 90).
> 
> My question, what would cause this, how do I troubleshoot it, and what might 
> fix this?
> 
> Monit has done this before on this machine with other processes.
> 
> Here is the config:
> 
> check process pgbouncer with pidfile /var/run/postgresql/pgbouncer.pid
> start program = "/etc/init.d/pgbouncer start"
> stop  program = "/etc/init.d/pgbouncer stop"
> if failed host 127.0.0.1 port 6432 protocol pgsql then restart
> 
> Thank you!
> 
> I appreciate & respect your time. I am very keen to solve this, whatever is 
> necessary.
> 
> 
> -- 
> To unsubscribe:
> https://lists.nongnu.org/mailman/listinfo/monit-general