| From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
|---|---|
| To: | Alexander Lakhin <exclusion(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Konstantin Knizhnik <knizhnik(at)neon(dot)tech> |
| Subject: | Re: Visibility bug with prepared transaction with subtransactions on standby |
| Date: | 2024-12-16 14:01:04 |
| Message-ID: | 9e857f95-0142-4b76-8551-03fb1e11125a@iki.fi |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Verite | 2024-12-16 14:08:55 | Re: UUID v7 |
| Previous Message | Jakub Wartak | 2024-12-16 13:45:37 | Re: FileFallocate misbehaving on XFS |