Re: Why does “failed protocol test [PGSQL ]” happen when system is under load, or how to trou bleshoot?
| Newsgroups | gmane.comp.monitoring.monit.general |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> 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 -- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general