Re: 035_standby_logical_decoding unbounded hang
Noah Misch <noah@leadboat.com>
From: Noah Misch <noah@leadboat.com>
To: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2024-02-19T23:09:30Z
Lists: pgsql-hackers
On Fri, Feb 16, 2024 at 06:37:38AM +0000, Bertrand Drouvot wrote: > On Thu, Feb 15, 2024 at 12:48:16PM -0800, Noah Misch wrote: > > On Wed, Feb 14, 2024 at 03:31:16PM +0000, Bertrand Drouvot wrote: > > > What about creating a sub, say wait_for_restart_lsn_calculation() in Cluster.pm > > > and then make use of it in create_logical_slot_on_standby() and above? (something > > > like wait_for_restart_lsn_calculation-v1.patch attached). > > > > Waiting for restart_lsn is just a prerequisite for calling > > pg_log_standby_snapshot(), so I wouldn't separate those two. > > Yeah, makes sense. > > > If we're > > extracting a sub, I would move the pg_log_standby_snapshot() call into the sub > > and make the API like one of these: > > > > $standby->wait_for_subscription_starting_point($primary, $slot_name); > > $primary->log_standby_snapshot($standby, $slot_name); > > > > Would you like to finish the patch in such a way? > > Sure, please find attached standby-slot-test-2-race-v2.patch doing so. I used > log_standby_snapshot() as it seems more generic to me. Thanks. Pushed at commit 0e16281.
Commits
-
Back-patch test modifications that were done as part of b6df0798a5.
- 22cecaddf7c8 16.3 landed
- b5abeb751419 15.7 landed
-
Fix the intermittent buildfarm failures in 031_column_list.
- b6df0798a5e2 17.0 landed
-
Fix test race between primary XLOG_RUNNING_XACTS and standby logical slot.
- c59a97313ba3 16.3 landed
- 0e162810df76 17.0 landed
-
Bound waits in 035_standby_logical_decoding.pl.
- f024746484b9 16.3 landed
- 4791f87f34bd 17.0 landed