[pgpool-general: 7665] Re: load test pauses and throws a 'DISCARD ALL'

[Francesco Mazzi]

I don't see pauses in log too. 
Anyway, I had a similar problem: https://www.pgpool.net/pipermail/pgpool-general/2021-August/007718.html 



Da: "Tatsuo Ishii" <ishii at sraoss.co.jp> 
A: sbob at quadratum-braccas.com 
Cc: "pgpool-general" <pgpool-general at pgpool.net> 
Inviato: Domenica, 8 agosto 2021 7:02:24 
Oggetto: [pgpool-general: 7664] Re: load test pauses and throws a 'DISCARD ALL' 

> Hi all; 
> 
> we are running load tests through pgpool v 4.1.4 
> 
> running in logical replication mode 
> 
> 
> while running a load test we see the test pause from the client 
> exactly every 1016 requests, the connection pauses for a few seconds, 
> this shows up in the pgpool log (see below), then everything picks up 
> again and runs for another 1016 requests. 
> 
> 
> I looked at the bug tracker but did not see anything 
> obvious... Thoughts? 
> 
> 
> 
> 21-08-06 20:37:31: pid 3270: LOG: DB node id: 0 backend pid: 326135 
> statement: SELECT 1 FROM transactions WHERE codigo = 'UNK' LIMIT 1 
> 2021-08-06 20:37:31: pid 3270: DEBUG: waiting for query response 
> 2021-08-06 20:37:31: pid 3270: DETAIL: waiting for backend:0 to 
> complete the query 
> 2021-08-06 20:37:31: pid 3270: DEBUG: decide where to send the query 
> 2021-08-06 20:37:31: pid 3270: DETAIL: destination = 3 for query= " 
> DISCARD ALL" 
> 2021-08-06 20:37:31: pid 3270: LOG: DB node id: 0 backend pid: 326135 
> statement: DISCARD ALL 
> 2021-08-06 20:37:31: pid 3270: DEBUG: waiting for query response 
> 2021-08-06 20:37:31: pid 3270: DETAIL: waiting for backend:0 to 
> complete the query 
> 2021-08-06 20:37:31: pid 3270: DEBUG: setting backend connection 
> close timer 
> 2021-08-06 20:37:31: pid 3270: DETAIL: close time 1628282251 

I am confused. I don't see any "pauses for a few seconds" in the 
log. The timestamps look all 20:37:31. 
-- 
Tatsuo Ishii 
SRA OSS, Inc. Japan 
English: http://www.sraoss.co.jp/index_en.php 
Japanese:http://www.sraoss.co.jp 
_______________________________________________ 
pgpool-general mailing list 
pgpool-general at pgpool.net 
http://www.pgpool.net/mailman/listinfo/pgpool-general 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210809/7d6a96a7/attachment.htm>