[pgpool-general: 7665] Re: load test pauses and throws a 'DISCARD ALL'
Francesco Mazzi
fmazzi at comune.genova.it
Mon Aug 9 15:46:32 JST 2021
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>
More information about the pgpool-general
mailing list