Re: Testing autovacuum wraparound (including failsafe)
Daniel Gustafsson <daniel@yesql.se>
From: Daniel Gustafsson <daniel@yesql.se>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Noah Misch <noah@leadboat.com>,
John Naylor <john.naylor@enterprisedb.com>,
Heikki Linnakangas <hlinnaka@iki.fi>,
Ian Lawrence Barwick <barwick@gmail.com>,
Andres Freund <andres@anarazel.de>,
Anastasia Lubennikova <lubennikovaav@gmail.com>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
Peter Geoghegan <pg@bowt.ie>
Date: 2023-11-28T10:16:25Z
Lists: pgsql-hackers
> On 28 Nov 2023, at 03:00, Masahiko Sawada <sawada.mshk@gmail.com> wrote: > > On Mon, Nov 27, 2023 at 10:40 PM Daniel Gustafsson <daniel@yesql.se> wrote: >> >>> On 27 Nov 2023, at 14:06, Masahiko Sawada <sawada.mshk@gmail.com> wrote: >> >>> Is it true that we can modify the timeout after creating >>> BackgroundPsql object? If so, it seems we don't need to introduce the >>> new timeout argument. But how? >> >> I can't remember if that's leftovers that incorrectly remains from an earlier >> version of the BackgroundPsql work, or if it's a very bad explanation of >> ->set_query_timer_restart(). The timeout will use the timeout_default value >> and that cannot be overridden, it can only be reset per query. > > Thank you for confirming this. I see there is the same problem also in > interactive_psql(). So I've attached the 0001 patch to fix these > documentation issues. -A default timeout of $PostgreSQL::Test::Utils::timeout_default is set up, -which can be modified later. +A default timeout of $PostgreSQL::Test::Utils::timeout_default is set up. Since it cannot be modified, I think we should just say "A timeout of .." and call it a default timeout. This obviously only matters for the backpatch since the sentence is removed in 0002. > Which could be backpatched. +1 >> With your patch the timeout still cannot be changed, but at least set during >> start which seems good enough until there are tests warranting more complexity. >> The docs should be corrected to reflect this in your patch. > > I've incorporated the comments except for the following one and > attached updated version of the rest patches: LGTM. -- Daniel Gustafsson
Commits
-
Fix meson installation of xid_wraparound test.
- 1aa67a5ea687 17.0 landed
-
Add tests for XID wraparound.
- e255b646a16b 17.0 landed
-
Add option to specify timeout seconds to BackgroundPsql.pm.
- 334f512f45eb 17.0 landed
-
Fix wrong description of BackgroundPsql's timeout.
- 2d758dca1b31 16.2 landed
- 5abff2aaa1ab 17.0 landed
-
Refactor background psql TAP functions
- 664d757531e1 16.0 cited
-
Consider triggering VACUUM failsafe during scan.
- c242baa4a831 14.0 landed
-
Fix autovacuum log output heap truncation issue.
- fbe9b80610fe 14.0 landed