[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