[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