Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wcgPw-003XdF-1T for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jun 2026 09:30:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wcgPv-004hee-11 for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jun 2026 09:30:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wcgPu-004heD-2l; Thu, 25 Jun 2026 09:30:38 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wcgPs-00000000B0l-3C5m; Thu, 25 Jun 2026 09:30:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1782379834; x=1782984634; i=mbanck@gmx.net; bh=GdzDrm+lisQBPUgK8BDcmJNapk6GJGkuiNSHWqCd58Q=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:Content-Transfer-Encoding:In-Reply-To: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=MHGmyWFOlCe5ySA2kqbUyxXNhUMLhUtovXpr6wNREZKbeL+8DKRHU/KHsx2IDzbY JPrhumOUxg0GXSJHtJBDih95VyBcgErMRDjsL+SHytFjpz+0hCy2mRm1PLXLxP+Xd 7GYWk+dwjE7JMFjvtmYmAJvNSQRSuUR6EFIHOoZIQMXORqvVNQ5IvWKKKj5+4lUoA vny8V3ajxdydOtQwiJ/C8FuxgoHmORFSlTDNbTApTQOhDUxXjjpI1cG1PgwHSn4Kq /kgSTf3nEmQ07MDzWMcWbQ5GPSB8pgtxyYcW33VikShUNnKFOiV3b9W7zkXvNlWSN Q72jlqA0eh5fQlQMhQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from client.hidden.invalid by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1Mk0NU-1x0icT3Wsi-00iePr; Thu, 25 Jun 2026 11:30:33 +0200 Received: from mbanck by lightning.p46.dedyn.io with local (Exim 4.92) (envelope-from ) id 1wcgPo-0002E7-JT; Thu, 25 Jun 2026 11:30:32 +0200 Date: Thu, 25 Jun 2026 11:30:32 +0200 From: Michael Banck To: Heikki Linnakangas Cc: Andrey Borodin , j.karremans@jk-consult.nl, rmt@lists.postgresql.org, PostgreSQL mailing lists Subject: Out-of-Cycle release? (was Re: BUG #19490: Streaming standby on 16.14 stops applying WAL on MultiXactOffsetSLRU when primary is 16.8) Message-ID: <20260625093032.GA8295@p46.dedyn.io;lightning.p46.dedyn.io> References: <9DF05C0C-D165-4821-80C2-FFAF47C07FF4@yandex-team.ru> <90F2A05B-FEEB-4695-87ED-32F53C6AC097@yandex-team.ru> <4016ab8b-84c0-4606-8a77-67ad5b157bfc@iki.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: <4016ab8b-84c0-4606-8a77-67ad5b157bfc@iki.fi> User-Agent: Mutt/1.10.1 (2018-07-13) X-Provags-ID: V03:K1:3ff1nXox+W65zBs/PFWgSneHrbVo3xMfTeRSRu4CksjWapc4fEd u2bViOQNDSnwuMSb2zqeY+4LPgiS/wEdf2SITjcMRZh087ZPyGXtTaR/8PH6NM14ZEJiuW5 /rb/npwS5HdpYyzRD1OIdzmUG6Phn3wqYcHm0arkTPxFz4QNe9KAAUWRFrCoNEy5oiOQ4V/ kRIeChlWt/t4NahipMQJQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:xwwl7milYis=;IvIN3sv6URupvGi1lgi2NkDXfx+ IitAciRS0spJHswteleHOMXkFX+nuhf+vu4EyY9DMyEQVUUYslbN18J9RaNWT7FKeHGl0XZ1f DMGPl/TEV+ubYlV/RzL832nQbplKCwJ3Xpfgd+/L3Odl0Zu4+7ErIUP9rhLjp49bQ5Ngs1xPg H0E0QAmnWuUTVx6LYSlkf/Qvdj0bExZ/UB4O4jzWqxLKAF/8w1h+bw10dRaSfDrQw3SxG6Yz6 LnycJV7IXAulfjUgDfd5kloAosESaYksedt5YREP0YQQCiAzm12KmwbqSZGnbOmoCenaOZSSY f3mSNLCY7orOBm4VuaTDaB4APA7zS8Se9s+w3J36nV9U05cLmihrU9GodoDSh25kDVmFDfYKi euadWeOQut3QbYB2fbIbsPfXoOaxAPCy7m3wb5v5sW/BBQsM7uGp7nhKLh7kc9cWBypE0pIHH G/1mvsOE0Sh0F6j3ACbtmjcQDQ2V5jRHG1CaZuh+oyxS77+GNG/vvxGfbiIDRcWTJUMuqPvBE 5vL+WJfXhj7i11Md1vzj4XToUQ4VjGlxzneUENyMvvXQY/bHrtPJwND1vghms4IuLeJJi07Es yRcz8QZz1CjRrteW97d6/FiNxxmUiuftL6/3CmWabd05yfcUhvB0Q7VmScb+dZGy6SMcKsU1T QJcdoPYcqxlWh3l0ZIWtV62KtjCn+D8y8beOpBEl/Tx7YGv4Xru897/MjG7+Wj1+NRMRc8J1n cSSuDz9BUtMXqO8WZFsQs2LkjJ/7m29kg0GI2nFDcB2RF+5MlUcuTuOyPENYWGZ4dtfNLEFyx 1/2bRA5tWzD55VYdeaR0p5PQ9ddJvta9sp4trgTUSnqi+pPEBo+upZF93lTrOGepCXA8EERo8 uUYqOvQiolIGKZR4dtGvf0xRivvxhGhAok08ETFQgooqZETsO6VG/gbLzyTUbJDUx1WEH8Zpx U8MBOww54B/NWX1hXA+yJaVMRhGXBNNmW19OtC6rSRe0C+H808V6HxDnPvmibJ8PrYqGnlGhS XYfnY1LoYpM8txvc9EOE8IzDaxjQuUK2ZqGZTiYohdeRfpsV1zZIDVnZ/54i/0i7s+v2r1yyg GAuZFL+Yknml2yqQ23fMVOTOY87OYp/B7m8O+8qvHdKokxPzXCVjMM5ZJ/eUN/N3lsHR5eGN9 bKZaTSuhB2OzUfUblKbgsgH7WCrg84gruU/C88aG8X3t/rKSWwe/pQllYBZayJhdXWV5nAtVE UXJeO4jo4sOpiCirFt3NCPrm5H8L2YDsNz0rwpnFhfsfjDV7AnvCXrHDL5nRmHSyItqcdI2XF WRTjzhoPphnTJZLurjPdoxs9L3Q7U3/x15kklGbxkWVZ6W6CFShR0W9dW7ZQB0Z1FYhObe8cO /KiQ6Kxqo+JaxOsh/NmLvURf6F9RVz8370MSC9VaX0gdgbJcDzuOTe4ZA3HUMZ59LdgvqeKc/ WFirIHfJSmAFmJ6Pz+ek5o5HZv7gsGLgQOh/6tcZnI+8OGlF3+L2FCaTgNJZ7WdrL4QcWdLTG tv4zVXuBPc/USdusnslA60nNSaaTx8JnOCA3aiWULD+fXEIiHVmYWZO7EgT3W9RSixiI2KSFD ZZhIQFsaO4jQJQ6aPMXkxV3BzPaHK9lLQrNitILMEYXMrC4F8kxtL5ZZ/cfqwG+790KIcv/Ml M9bJwN3Zf0P+ty+vMVuIbJUGSBJzUnZ64v9JgPhBmNjCVmEgAJi9CvbSgUV4bI24kHarEd9dK wQlPKlboDWP0Y1y6/P6UKdjVJELKuvYUMLwG28Z9JN6UOo2fqM7Z2g/Kexs9v/g9YwIvpNuW9 VGuG/iFp3FZlDQ9IuXcvcqHZe4RsM2GplbExMc2/qAxkE5cRv2b5koQBDLSD/XKheM5INprw1 LbBsq4Sw8SVmbr8LUSkNmaI6HWQT+PGZ8WdAZDJeg3Ut0x96E9TUaJRDGnGNkiKnIcL0RkR+P JbpwZkBFlfqEL5J8m7lRb2YEgUl/UL+hPJLDQGRu5rAfNmSm612k+kG6r9rAWhLGPvWINgdw0 60ssXIO5AoY5u6hXqiy62V3QmC/xsnxckIjpjd82h8LJTHPqVI4hyTr69k4GQpUUb/JT3tuGg 5iD/pyVlWi9eCKR9Q/EaP2K/ZjWkeRJQM0xCcSa2Qixk+782Xy2DxKW/dWXmYeiCi/9HF5mE1 xKvte4NCks4qcaqUpfzkXoP3nx1OWzKza2VoZEJFeOtQxCiVxlOo3EV/oJhlo+2r+TSVBnwZc WY8TNof3eyb2DIW/48Z8thgglaMhwigXJ/vT+kCBZp7oJ2jSOdTgpgObWYUSuhq83jvHwTMGw qYc1yUBbQMfQoSc0KA2+UamYX2iUjVxikCG87yzkvctkCHX8D8MOSYwmtGA8UBj8Sb4ADqwZ2 ZE2tSHuzOb32UyaYgI3/e9BvPUaOW6Kxhs8QaSbBPx5V0SZ1tzZhDUSU1sYT7WOjT0qKkTf/c 1sDnLBykbsTWDlvHXA2nUM1KT2my+3JkbajbqHl2i12cMdzzgvuCk9eA3YeL35Ul67KDYNAQV cR8jMI0Mfv43BszlsziALCc/nxNnMtpXNEeni/L6yrR1P2istC0D/lXGDEHZTC7NNxSzceRsJ iJlEsP4aRbtSwPQPVjCL7d1gCuFe1SCXSdnseUK21NdBcq8fBBmy2RdHrgrB7tZbsOMXULyMQ lta6y8P8r1Ss4ewtWLAE6+1gytSxOKhkX4S6dg5REzJh7EMxacAJ+XVQTOALuUjoEObDinV0b dAYbIneeheMiBk7VbNcxE2iqmX45RuHaIH4X5kaqoNxDYSqmHMQCZfttPf32P2g+PGUTbaHdr tQeT8oGWzd7TYPGyR/Y8xm6aSTm9DIc4INlnKUun82kjx7HPrQRaPe77ayxSbHtnzWx8FbS7C /qfc3IyI6r2Fqyx1GhfJI81AKaNgz/FhjbsaFadER/ZZutgbFQtQ7mPzEeZ+aJh0eYMbzhaR5 VEANaYS/CmyTfQRqJ3ULAD4M9LyKJ+FxVxgIhVbppAEcrr9B29q+i1VxE+vpnQMvvnGNLc9gZ uMLy/wWTXP6gL0RbPAsY0u0LbGZ16faMw/N2iIktcEcDokCqLZAqocwkgrn7NUZ0qpiR+LzFP 4nUKXoFRSSm7lxdMfcdbUWTR9j1E/OrZPLk725T2+By/v45rEyk6iZ4Pz8paVvj0EV0GGroTY ECRSwsN4tOsu3GHhEW8bHo+Zcv7zud+RicGFg6+R/jOHAxn/Ss9Tbkbp044G6suzJIgBDG7TG WiKT0EJNCvmIipazGiCVjD1rca752L1RjtgxNPiBzQ8OXLDyREJ+hd/P5oHIrqNxAB/esj5f6 kQuSR4ZafKvipE6gJ/vApbQ9fIUyfnwnKdUKXEmECckRp4G0HWU3dWPkvnMxat+EY1gpOM+FG F6d5kB7hUPFGjcaz0xDyhYW8ky9h0Y/sDH/fj/Vp7GjXLYIdLrtRTbxp80shoS4arQ6X5dTNz kJNq5dkiTLDcKxspbcS2MMhKV/qlsN+QzCChTCSliEekJl6+c1zqH8cgM1XygXHAB5lHS18HJ Rx81trQwJOS5+9Mx5yoHvQd/+Y61rZsA1GjuZaCxS+sAqmntntE2yDojKX1UobLRs8kDjsxiE ZSIW+/qcFhV+guxgSkvXolf8WbEnx8YNSjOM0L83j+lobFLc43AnzjRsiPjQh69gL3vFHjxy8 us7VlVlu4YFdgiQmqjMICDBtYy3Mb4/mWSwJcdbmnBmNmN2ZPeWZ8qhMzlE83Vz6s8Spwi5d1 w/QCLlOUpHcgrOgcIiYZzVVasb4CVf/WQKa60EMoRmQ6UtOXQ43mSW9+9Dt50SQB4bt8JQtCh OSWy0KhxM4oXu2I+iodwPnp1lgF196Bg7ltgOvekB5jN2U6EZDaVHA1oO8p2HjcxTncz9zmhL iwP1Cl1/kjxbA5Ol4BU8vFeWzM5PWNFoDEzOJGf8ngHs6uL8dreWYHovXeheF6SsVb0XvU+Ug FjjYCACl5Eh8nNaaJLjRT8c89mubKWpxD2Y+7KXXna0dHa/jTgnJWt9rl2XDFXfF3deuNKc/E a7orODefZKXHvsl+mlQuqCP9unKISNCJeKhDSY5tJElw4HfBYUZDDvGK3zQxjkpAjYHNTT3Oq pbJHScz5vtOp7nxb8sxiH8pzEScPRxTxDGnhgPVzxFYhnKoSUEVyWuPfFbrtxYVKll+3kxhHo R06mcK+UYbO+BlJ4VVWvHD/bKF2Vml5HcYXYBhzjsTP6VS4suM9+YYLC4FAK258ISnBwUGCLE V0tJuJIpvlIsmKrCA7Tr6sysmnSTTlu8rEURv6Bn29zD2X4HlRzBguoAItQHLFNMjaYW01DH7 R5wMdZhitwD2DdzYRnVjCDF1Dp3O8hthsKSHqtGc3X8eSqkwT0LlXlgpgiaMZH8oVmQxwTPAW /O/CdGsxIWHOeCjKFMvkUIbe+V3sr5ZyLY8o7+6g7/kUMR3z88tK7jOBjQVP2dpeT3MLPaaQB ZpWSLb42AywDuhM1wCvOTJ/bjCJ5WhBfICj/+/AHGzOVBJ/SOQWD2v0FrLZ37KE3YMyWCn8MZ pNT+mc03799brtTk6V0ezmZrHVvfOaSPg9k1Gw+GUqOVuzRmj3olc0FvSfxYPumgDdP9osHFH HvfhQ18Mxug8L/89TE/yhR/lTITNcuN+UkOEGGIcjM9nibbIt01ELmNB4EUKrJSWp0KQ8c8Jh smwMGCTp2FLVgx3JCtY8sSAn2oyGsEYiOmZfYNEvSyzufgANzYpZT/zFfXhaAlDHZL/2eeyq6 +pNW2FNuNantUSMdbSpYBtzqtSlnZ2wuHx/6u5lrS0SwY3Yynw4x76wx8VK2AwPN4Wcv9ESlG hA7zV8WSLlYHUliuBy2OLr5nZxiFGHOdmvPK+OUmqotXYaQ/lU/4sCb2giDWPQCn1inlo+Kbi xOkJ8mcG8JsBr4aD/6dhQqPItSVSWEgT5UVbwZ4KTw/3uAalt2Pg/pmBzdAznarYBjyP3lOW/ xT/4q8QHehBqFemMnwNKRjZJdFhWZrOjKLwHySiUWiUXyDe5JPgEyg7oXR17S570JduNV8r9m PcU0Ie/pDEuF8refscq7eorgNZbBu2o4TC7sJx+qoVyfHzL8jbK28nxFeUwlP8KdvLh8fjUeq ViQbn0DywWl7fhnrS/gpBgWeV4PwH6eH3lxnENYUIxJm6tEP0QE8rpabQUAhbYUFIl7qBRjGz FrKU1SKzgCsWnrHLsrd19kib67DFem47VsjIUALoLpY0qcyPtkJNhu70WCZZ14/XBa3e+G77y HOGsro5Eyb0C+8kXbR/FTcd12pZaKUlg4BuY65bOMM7vv251sIYnowLZm+OqzWOxLFprx1YxN osvxf7ijAzqEJP9JNIUL5JVF07KCj2lk1rEqfNeRRiFoeWUaNf45p46SjBiQFjDbl73mwI4u2 cD248RmMNc/dEJBiav6sbfMfrRwEmt4Oe0vOYPvHyCmscKVxkrslQTRlkOdABIk3mkzEpalYy VWERR63YojMwM0ihAziSAL8C0D+XHDBajalstWN2ktGKhFWmodF+gc8Kzg5GOFmdXtHLpmb0g fXr+GQZsJ9mcseu5s7xbY/Cgszp7QjtPnPoyRWaQyku/xjhlEMalRn5jrSGqQ6loIB4SA/4SW KZKy8pDpRKj2TX5amOlzO4mY3ynWa6/ZYZKkYIpV9DeSVnEC1GRjzZ+WbuAXji3GbIjTFE6V4 B8Qgm9Cie6GBQqmo52/jsdfKlS91hN List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, moving this to -hackers. On Wed, May 27, 2026 at 12:06:45PM +0300, Heikki Linnakangas wrote: > On 27/05/2026 05:55, Nazneen Jafri wrote: > > Tested Andrey's demo.diff on a fresh environment: > >=20 > > =C2=A0 - Primary: REL_16_8, Standby: REL_16_14 (--enable-cassert) > >=20 > > =C2=A0 - ~2300 MultiXacts crossing the offsets page boundary > >=20 > > =C2=A0 - Without patch: startup deadlocks at RecordNewMultiXact(multi= =3D2047) > >=20 > > =C2=A0 - With patch: standby replays all WAL and catches up >=20 > Thanks all. I have applied this to v14 - v16. I would like to suggest that this bug-fix might warrant an out-of-cylce release (even though it is has been a month since the fix got committed). There has been at least one more report on pgsql-bugs[1], we (at credativ) have had a customer issue about it and Jan Karremans (in CC) mentioned this on Telegram today as well. To reiterate, this bug is a regression in the latest back-branch releases for versions 14-16. If either the standby gets updated to the latest minor release first, or if somebody does PITR from a primary on an earlier release to an instance with the latest minor release, the standby/PITR deadlocks and just sits there. I think those are pretty important/usual use-cases, so even if versions 17/18 are not affected (to-the-best-of-my-knowledge), maybe 14-16 should get a re-release for this? Or has this already been discussed among the release team? Regards, Michael