[pgpool-general: 7664] Re: load test pauses and throws a 'DISCARD ALL'
Tatsuo Ishii
ishii at sraoss.co.jp
Sun Aug 8 14:02:24 JST 2021
> 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
More information about the pgpool-general
mailing list