Re: Visibility bug with prepared transaction with subtransactions on standby - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Visibility bug with prepared transaction with subtransactions on standby
Date
Msg-id 9e857f95-0142-4b76-8551-03fb1e11125a@iki.fi
Whole thread Raw
In response to Re: Visibility bug with prepared transaction with subtransactions on standby  (Alexander Lakhin <exclusion@gmail.com>)
List pgsql-hackers
On 16/12/2024 10:00, Alexander Lakhin wrote:
> Recently hornet made some noise too: [1], by failing on the test
> modification added with e9c8747ee (in REL_13_STABLE):
> # issuing query via background psql: SELECT count(*) FROM 
> t_009_tbl_standby_mvcc
> # pump_until: process terminated unexpectedly when searching for "(? 
> ^:background_psql: QUERY_SEPARATOR)" with stream: ""
> query failed: psql:<stdin>:6: ERROR:  relation "t_009_tbl_standby_mvcc" 
> does not exist
> 
> It looks like t_009_tbl_standby_mvcc had not arrived to standby yet when
> it was queried.
> 
> I can reproduce the same with TEMP_CONFIG containing:
> recovery_min_apply_delay = '500ms'
> 
> All the other tests (I ran check-world) pass with this setting. So maybe
> this test lacks waiting for standby synchronization.

Fixed, thanks!

-- 
Heikki Linnakangas
Neon (https://neon.tech)




pgsql-hackers by date:

Previous
From: Jakub Wartak
Date:
Subject: Re: FileFallocate misbehaving on XFS
Next
From: "Daniel Verite"
Date:
Subject: Re: UUID v7