<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>I don't see pauses in log too.</div><div>Anyway, I had a similar problem: https://www.pgpool.net/pipermail/pgpool-general/2021-August/007718.html</div><div data-marker="__SIG_PRE__"><div><br data-mce-bogus="1"></div></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>Da: </b>"Tatsuo Ishii" <ishii@sraoss.co.jp><br><b>A: </b>sbob@quadratum-braccas.com<br><b>Cc: </b>"pgpool-general" <pgpool-general@pgpool.net><br><b>Inviato: </b>Domenica, 8 agosto 2021 7:02:24<br><b>Oggetto: </b>[pgpool-general: 7664] Re: load test pauses and throws a 'DISCARD ALL'<br></div><div><br></div><div data-marker="__QUOTED_TEXT__">> Hi all;<br>> <br>> we are running load tests through pgpool v 4.1.4<br>> <br>> running in logical replication mode<br>> <br>> <br>> while running a load test we see the test pause from the client<br>> exactly every 1016 requests, the connection pauses for a few seconds,<br>> this shows up in the pgpool log (see below), then everything picks up<br>> again and runs for another 1016 requests.<br>> <br>> <br>> I looked at the bug tracker but did not see anything<br>> obvious... Thoughts?<br>> <br>> <br>> <br>> 21-08-06 20:37:31: pid 3270: LOG: DB node id: 0 backend pid: 326135<br>> statement: SELECT 1 FROM transactions WHERE codigo = 'UNK' LIMIT 1<br>> 2021-08-06 20:37:31: pid 3270: DEBUG: waiting for query response<br>> 2021-08-06 20:37:31: pid 3270: DETAIL: waiting for backend:0 to<br>> complete the query<br>> 2021-08-06 20:37:31: pid 3270: DEBUG: decide where to send the query<br>> 2021-08-06 20:37:31: pid 3270: DETAIL: destination = 3 for query= "<br>> DISCARD ALL"<br>> 2021-08-06 20:37:31: pid 3270: LOG: DB node id: 0 backend pid: 326135<br>> statement: DISCARD ALL<br>> 2021-08-06 20:37:31: pid 3270: DEBUG: waiting for query response<br>> 2021-08-06 20:37:31: pid 3270: DETAIL: waiting for backend:0 to<br>> complete the query<br>> 2021-08-06 20:37:31: pid 3270: DEBUG: setting backend connection<br>> close timer<br>> 2021-08-06 20:37:31: pid 3270: DETAIL: close time 1628282251<br><br>I am confused. I don't see any "pauses for a few seconds" in the<br>log. The timestamps look all 20:37:31.<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: http://www.sraoss.co.jp/index_en.php<br>Japanese:http://www.sraoss.co.jp<br>_______________________________________________<br>pgpool-general mailing list<br>pgpool-general@pgpool.net<br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br></div></div></body></html>