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

sbob sbob at quadratum-braccas.com
Sat Aug 7 05:41: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




More information about the pgpool-general mailing list