Andres Freund <[email protected]> writes:
> It's not surprising that pg_dump takes 30s on that old a machine. But more
> than 2min still surprised me. Is that really do be expected?
In the previous buildfarm run, that dump took just under 31s:
2022-01-31 14:21:10.358 EST [19325:1] [unknown] LOG: connection received:
host=[local]
2022-01-31 14:21:10.367 EST [19325:2] [unknown] LOG: connection authorized:
user=buildfarm database=regression application_name=027_stream_regress.pl
...
2022-01-31 14:21:41.139 EST [19325:2663] 027_stream_regress.pl LOG:
disconnection: session time: 0:00:30.782 user=buildfarm database=regression
host=[local]
In the failing run, we have:
2022-02-01 04:48:37.757 EST [3683:1] [unknown] LOG: connection received:
host=[local]
2022-02-01 04:48:37.767 EST [3683:2] [unknown] LOG: connection authorized:
user=buildfarm database=regression application_name=027_stream_regress.pl
...
2022-02-01 04:49:09.719 EST [3683:2584] 027_stream_regress.pl LOG: statement:
COPY public.tenk1 (unique1, unique2, two, four, ten, twenty, hundred, thousand,
twothousand, fivethous, tenthous, odd, even, stringu1, stringu2, string4) TO
stdout;
2022-02-01 04:49:09.881 EST [3683:2585] 027_stream_regress.pl ERROR: canceling
statement due to conflict with recovery
2022-02-01 04:49:09.881 EST [3683:2586] 027_stream_regress.pl DETAIL: User
query might have needed to see row versions that must be removed.
2022-02-01 04:49:09.881 EST [3683:2587] 027_stream_regress.pl STATEMENT: COPY
public.tenk1 (unique1, unique2, two, four, ten, twenty, hundred, thousand,
twothousand, fivethous, tenthous, odd, even, stringu1, stringu2, string4) TO
stdout;
2022-02-01 04:49:09.889 EST [3685:1] [unknown] LOG: connection received:
host=[local]
2022-02-01 04:49:09.905 EST [3683:2588] 027_stream_regress.pl LOG: could not
send data to client: Broken pipe
2022-02-01 04:49:09.905 EST [3683:2589] 027_stream_regress.pl ERROR: canceling
statement due to conflict with recovery
2022-02-01 04:49:09.905 EST [3683:2590] 027_stream_regress.pl DETAIL: User
query might have needed to see row versions that must be removed.
2022-02-01 04:49:09.906 EST [3683:2591] 027_stream_regress.pl FATAL:
connection to client lost
2022-02-01 04:49:09.935 EST [3683:2592] 027_stream_regress.pl LOG:
disconnection: session time: 0:00:32.179 user=buildfarm database=regression
host=[local]
That's only a little over 30s. Where are you getting 2m from?
regards, tom lane
