Re: BUG #19490: Streaming standby on 16.14 stops applying WAL on MultiXactOffsetSLRU when primary is 16.8

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

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

In response to

Responses

Browse pgsql-bugs by date

  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