| From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
|---|---|
| To: | Nazneen Jafri <jafrinazneen(at)gmail(dot)com>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>, Radim Marek <radim(at)boringsql(dot)com>, Marko Tiikkaja <marko(at)joh(dot)to>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #19490: Streaming standby on 16.14 stops applying WAL on MultiXactOffsetSLRU when primary is 16.8 |
| Date: | 2026-05-27 09:06:45 |
| Message-ID: | 4016ab8b-84c0-4606-8a77-67ad5b157bfc@iki.fi |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On 27/05/2026 05:55, Nazneen Jafri wrote:
> Tested Andrey's demo.diff on a fresh environment:
>
> - Primary: REL_16_8, Standby: REL_16_14 (--enable-cassert)
>
> - ~2300 MultiXacts crossing the offsets page boundary
>
> - Without patch: startup deadlocks at RecordNewMultiXact(multi=2047)
>
> - With patch: standby replays all WAL and catches up
Thanks all. I have applied this to v14 - v16.
- Heikki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2026-05-27 11:50:12 | BUG #19498: Anonymous ROW() field expansion fails after scalar subquery relay |
| Previous Message | Ayush Tiwari | 2026-05-27 07:16:24 | Re: BUG #19493: Assertion failure in pg_plan_advice with EXISTS subquery and DO_NOT_SCAN advice |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Lepikhov | 2026-05-27 10:11:17 | Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table |
| Previous Message | Matthias van de Meent | 2026-05-27 08:56:57 | PGConf.dev CSN unconference session: notes and follow-up discussion takeaways |