[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