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 1vrBaT-008Gup-0H for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Feb 2026 09:05:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vrBaQ-00HKSb-2a for pgsql-bugs@arkaria.postgresql.org; Sat, 14 Feb 2026 09:05:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vrBaQ-00HKSS-1E for pgsql-bugs@lists.postgresql.org; Sat, 14 Feb 2026 09:05:10 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vrBaN-00000000ZqA-11mi for pgsql-bugs@lists.postgresql.org; Sat, 14 Feb 2026 09:05:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1771059904; x=1771664704; i=mbanck@gmx.net; bh=KGyS/ldYk80UGFrAdvHp7HJH8/Ojnjyrx4cFUDmlJnk=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=uDpxGXQgJs/N+Tm+HPwLywbxkyXTCwtVLFUDVOA7MA6pYPdKNziINAJ9q13PNT1D Lyoc9BY9DFJEEjLkL/QIXyoQN84GnlJZYbL3CGf66hrYFErne1016k2KszC7+oFrO Yi7yblkSU32Tna6I2vSBvZsYPNQswKA3CtlDmV1a4YbVMUE3wygYakyFCJZ17IesW chYCJ/vCOulcukSuz/wmK4ydtPTuO+FRZaqK8+4CL61jqr5rRujkfE4M5MDtIfiTg KH6Noq9YbdU7vyy9glNbFaEAKCeyT2QeEzdJ8+AqveAcjzHJwooDRfE+7QXM4tJPE cq/yswdcndWG0uuNjA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from lightning.p46.dedyn.io ([188.174.173.229]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1N4zAs-1vjf6x43KW-00uTFy; Sat, 14 Feb 2026 10:05:04 +0100 Received: from mbanck by lightning.p46.dedyn.io with local (Exim 4.92) (envelope-from ) id 1vrBaI-0007kw-Dw; Sat, 14 Feb 2026 10:05:02 +0100 Date: Sat, 14 Feb 2026 10:05:02 +0100 From: Michael Banck To: Sebastian Webber Cc: pgsql-bugs@lists.postgresql.org Subject: Re: 17.8 standby crashes during WAL replay from 17.5 primary: "could not access status of transaction" Message-ID: <20260214090150.GC2297@p46.dedyn.io;lightning.p46.dedyn.io> References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) X-Provags-ID: V03:K1:p5UXVvOuydTPT1ZMTupARATpCRiwEHcp6j+AhaY0hQY1gGK6CAK HmJbT4BfciHYNHSn1Gza8Xos9ukpgL7hSlCyZ4dFJJtdkklKgNcdqcIquIFpUPMVKRSwveI RMg5ugzVI9Eh5nqV5Ovyd1KR9N+SKQJYYiTusDPNSzndfJ0wGRZuLTffQmBIinnWwSU/PPx HXv0HHwNdnv3Gg4GvDuWQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:f88f3cNmLK0=;w1qjihcAOyNXigJgZNyd3vq0Ls2 u5sPvZmPAcWV7d95SBetzDOP4ga47qpEc560kLRI4nEw8rA8rpvcsrLmgeXRDlOZg+SrSIYcN deslHvlztYs6sMYzfNvf51e+SRfXB1tzSlSKWw5HZCYWcylPREu3zkmLNoC+Tc4yN20QfQVvR NpZyEZn07ggrPOOsRgfJdRV02HZqo3JzYSCZqV0HK58ticikXRNtT+Oy0Lv96d+bb0topKd2A 0V+mjWxQvh82I2uhzbOuqqr09krDjefPY73jLAs4PFpCKC9/2N6l7hCgz6RHm3szXOoKqjgZO 3BP5o5Q8Nl1moTtuCq1ozCrOkSrYYCxFOvwAmSBrSeqBT9rI+Jb3ksZ2g2sUy7FvKM+woWD+o 5WpuOp1vSi5m7K/3JODgN/iaP2gYywNiF3P20e7dy4c9TwOJhGpS6LYgxUrDD7N5YTpUOewYV JvBayda+BZR7ZDQk5lufsl7YS07tiM84FXFpPf2Kc5fKkjtuVs48mZMug1BMhdwm7drSPWDlx RvDXdziFNpd/xV3wJNqVOKlSl4EtAAgo2QY5Ip6mD1WhC62u1e/TR2LNZG1pEzVEO4IOI9cEY sB2VSVcFBhzy1hQzbU9rc3WoGhE9YRwvDSbwu3XtJhn0CLiPD2WsiQv32uo1Zy0033hKTGG/A rFwa613GwXzeIPH2lP9eKh6D0sK57SvnkYiQojFm07vUqPSiL1mm45Tt+iBaKR3SJ5xh7zXfd 7sFiQdNYCESljfFM37whK3OShatEP5Yy5DvcCUGwqr1KQCd+xJHBrP8L5ITHuwlcx/xC5E8s8 euHXKyYBwQSSFdpqqphsuo+xwX8tRINFnBfthZaicEucaASPPrsbapfXYWGwnRbaWsrVagdXW /2wZlvRaINAN/eBz3DzE2oVOlikz40c3PIU2HP4r1P+15Juc7ZU425a2gjQrOxUjpPRUTcTLo EVG8RGqEUHb4E/+VYdd4fF4wn6v20BLDKQ6NRI/TkhJk9vD7TQFirtKvukBlCfVsInU0po04n 2bxY0FZEC1VTzJ56KA4FtJwQnNiuC1Fc0/6HGVuJ1oUGSR4jg7R9ALkNZiAXEcMHv5jr9Ap8Z jiH209BqBKHnb4YkQQAYt0CJMholvjYzsc6wA1s+34DPNyB7EvCXC9UeonUi7CfL5YZJnvc5C JUQXYodhWLe/ZVG99w2x/8KoaRXxF1V81vDNU3XaJLPrar9kvsZGiC+x4VyNGAWw0vt244RKb o5mErdvV7ic7raY1x9op/5Tce0SbuS7B7EJXeG1j7h6mrULzrMpo73PPxK7bxSbjw2eeWL/lv wNsWLh6OhJk8oDRqIxgIEjC7ld9BeFVD1SnkEpWsUukzf4Bqsi8YXw+1dmhpjAxF0Jl9WNe7S dwmSx0t96CCtEVqlzBaPElYJuonjIvE2J3QP3k2/rqBF0FAy0/tNmF0ZHwcuVYII+q4RudTLI a/H2TfpfKquIdAdAuWqV986WN4dgboxQZCQsa+iagNXycny1wgH7jLIvYUqHLwL/vGzGUpq6X xJInM7h2F4aRP9SJl7Fd/34i0kUXMpgJ9Qf9rMy4HLC/Gajhj3D3jcIaPVnZvP0Aunfd9HvaF rL1QX/QWYsyonDMXTE7GvilWfF5jKjtCqlmBlJU+admVYhP0Ym0C/HGUr+tbKhoDEr6DHNL7k 8qM7CgUEHcLhwvywE6Hp7dFi5keDDcHkeV/9b4hPZipOyOCcgCI67XB6cs4ws527iX6Ok+T6K S4yGYz8HQKf3cFFIJ5srywFwWhw08IMAsXd9IO1lbSU6qn+8C87kd0uDsybuyfmS9bkpUQgcN ycR6STV/I2z1nUX6jh148lqsPYjHUmxsJgn2WN9W9MmL82c7ZuKbtTq0GNCRSi2MPbrjFxzKJ l10Bf6TOIiGzWdbRj0QnHlT81xC1PT5ea0P/3CyMCWrGUe4caDgGDpzSvgzbzsXwPLlkWM8cL HCCcV50sk7eV2Davcc0FGtLEGUaAcgCJB6wyDmSVjUiDWGE3sufAS3o5zZA/g6jddX4mjTZcC oeYQO/KdUAFZo1wUqmryF0/lD5pcCFy9dJ2G4kjfiXlsmaHo7zeGADI5QLQAY+rjuEEHsxg6c cM42cChTz/Ffi/BSfIoKLGkvUKST9u3/yBEdwAz4lVIB7pQxZdeeYAhjxpUTMfE2BYYmmjOiz L6m2ftCf20CC/9KHsXDvtJd9g/Lb+0h1XuHhRS3kRY4zq0jLD1c5+QipWaJMob5TappcUOvkA Tq9PQdDJkUlhqL9efS3kX+yvdCfAYdb4Ze+ZDoiMF1AbN9DHvRe3XWg8aYZfwkhdBgTpi0oTU /1WYyh3JvNhUeEIJOTXwJKWfVGrN1qIhZ5jfGR6PZpdQz0dskQWkhFe9WIHgOf6rl7Z3U23pD 3c3kxF7anGb0VuwLRdicfajZabkNVNx6UWRdssfBBt+RlKTmQ9IE207+S3ZqYuYG47SeyPC7h UWH+E3j01MbTF5zKMN/elvwrJzdNuLErwx/ssqhVonvGnb0AYRP6zQRBujIGE7BEJO2WGCRdR FUhTEqZXQFl7V7Qd5wIMn/vbaaXKbGrjKpLuwWXdWYeh2WY1k1pVyR1LVC7Qg2zSskhYTObOV Dpwd0FWIce3hO8rhAv3itsL1Zfeki21xwc8WvjekLnWDDmZO6IptYlPG50uEuNCZRvfgelLfh n+DVoMpS0o8chJwdWj0dlhhQdbd7kIhPEoQM01wjN4Ex3sQBy5dGr4qrZOlduV42HHWDPhVzH HuPLAGkt04hCSUwcQrA9tcaXJKKkNSxBmchcZ/V1M6lkcXWWBhB2c508eS/HtKAatgn5n4QQ8 zYM6hZY+mKOLTpXkII2wDDKIfBbVRGN0cS8855pHI1VDJjRFI9f8+2NK47Tr5UPI8vqLCqGq5 pvu6cA0/5pLqOT797Qw2BSwZPdsz2qg69UfHo78K9Pn39cX7ZM+oFsS08HpmuXguMjS3aq0Wb B5rvp5LusZjyakUVQsLPXkTQea8oGMJoe7urJFv3MUuwxNCbSGKs2KC60D2i3V0JDyKqFoqRk wa6eYGVXctK39mYhixUVLjCOfW6awOxD+UnSOPDDoVVu9Z9z4wj4G2qYmhA08Qkx22NkG959S 09QUaxk9jer5VnQPFMixcRcNDd8ygmISw49j6MYrG2eYij1R5HRyBm46Pbm0N8gFudO8pouow Oz05MWvRCLZvYVn3pavcm2jLgJmWgtWMXuK70XG1Cgo5ZlYitbvU5byU2lhHhQsr/s/vrh7CD tIsu9H8srFWLQvx+NIN+WB6AQYTPUAxw8IZAQvgfgqwZj9wKxZVdrWFG7CgChDtAZ4IOMjd7k e+t0eI+C2BXIz+5yCUSRD1ppy5HrzNz/LeAjq2q131CEp75pultqKBoX3CYfdf8lwgFOS8d6/ hHwWgehzEdgMbU76DLnTUlNVXbzffXgGLrHDM84ccShVJLCauPd1nsiHlFVf+zYxdsHQTD64G 9LNl0zIaVrCYM28uFWtN2pCJ7DiW8TEfZy8KfjwhjkvhZlIHZN/1yuQfuz4ZDfQ0xDdWuoyl8 ZWV13p+NhgP21uav6eSnR5Iw4GanAFyaCIMv+9eXqRfXRiHVGqEESXD8DQi/Ww09D6Oyo0nB6 GJMhh2zUG6OV5K/J1S6HdSvUW5dB5VZgoJEv37R4RobEDMusUqzpjauwv1sk5tmM+IBqvYgrB +4STqOrTvDMuGGitjqcJUVLmqGK93eIgXeWcvp71D2rAtwmfBBc8ziJgFBsTB7Ip9QdkwY6Nn J40XM26uh0VeF4SvQPL4+PU9sHqUSEumppgG/udm2a/PiwEjlyR79PGN7ul0vq4OWXlGngJaj gUp/Yn/0LDEatpKUxPaOdKX44FevjYxsgC5wikVKl7MzXrNFo/B7KYfY5KumGCN8p/wkXzbsE iQ1xGVfvRPwy68IVzzu5Q5Lv5KBbewERvAnk3SJ9BM5K+thdE8eT201wohR+w9rZ1/WPUz1lv m/hW4TpMNTsaPEOEPQ7qy/A7XgKZtGmc3j5fb/f8Ksat1MttLNUOTAE/GA7CAmTG1OYC0M3UJ Zo+c7X2B1JmmXdc5hWVvt+5Ob1HLvwn6c0GG+1+ZdT2bVwTK5knv7gx4B0gA0UXCtxMf+HhJv cmuSjf/V4Hy2vgGql13KosVD4cnCOiLKXHlhj847ZA5QjNVvyUqhplaQP872Zg3NmGBXalDzU +qCteH8ARkmBj7bXKB0xFGRzOl8tGa+w3cIQA7tc5m1NkwoVpLtJRaG/modinRR7ftOQcVjIo lLQ00VLQEO7E278FI3VPdy2Q3ZR1jWBm6kqHq7QePg6Nbl6N/QbHE/e2IfC36mhpuCol+L9Fd RubjN7Cb25V97FC+2iOV8PuCjSYOuKCAFQfsSGsu7Kyx8IUMv2sOFrPITxILc7LUObYhvHCEk f76ZaH3IfjAAK8RyZMJZ/r+g5M54V7ylu1xAZv+yaXW/sZpA5TmjGaimR/CMF6xYzimzdL+kD EhtylhRKRzsTpUz1XLO9jYC1An0ij5m/NT59QkpobWq+m+okKqrtVp820EWIYEVbntmOgdgm0 k04YsN+l/jCLHDG8ldclMA1ZM04ux8Gya/wM+dz0koDDo6j9SZuNcftnPY6GDCtFrr28wreSD X2FeQUGz2Na6Tk6LTbwA21btdrjWRum6EFvlqyUIdr6sAvb8E7X2NvVlRUcjNli/FVE2znYAy NNtSC1gxGiX1sEnQVvz05Mic/GVXy/CTP+1UB2t9W+i0sP8r2w/73XZr4DSfZXzrwT1K4ueq6 vuZ9OhjAFONx6e5v/jkVsrrIT83qAw5tnu5UzYUWcctzbY1A56laBq3BZrPn2wmHL6beI9Cbi TYwCPNSBh+6b6BMQbEJgkkTaFRB7wAUFWgeZ/ItEyv4658yBOdi/5xIdAXhDFqA4K3Srsnlie hRBME7KK04WmpOWxDKAf0TFyT6jXJZf0mAzuYL/XLZwnWvWCz4TAWTD6lkTClvm9VmCc3qCwn YqGpDkIenCGOu59zZvaH9xINOoPSc4WDPylTmKDzRRMA1zdbxri6BLd8aQ/HwJytDvbxWVpfR RTFp4sTOKPVf6KFMoFbLt/+qEoMqx2nNdGsIUYS3q+0bdtHnl3srh904iRLiqhDRiE7yjD80O N4XkeqCuQ+MTSyLGMV1tlObHe75CyZM7lNQ0ODFEe9CHguVQRNQ3i4uQ8ZRXZt0WdxZj1kSBm 8VmNazXj9F30bMCTJ5fPFBHhAqOImcBbSmz0yWz7KRTAgxaUtc0BRW5+uVTRq4gIpRPCR0H4= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Fri, Feb 13, 2026 at 05:31:18PM -0300, Sebastian Webber wrote: > Description > ----------- >=20 > A PostgreSQL 17.8 standby crashes during WAL replay when streaming > from a 17.5 primary. The crash occurs after replaying a > MultiXact/TRUNCATE_ID record followed by a MultiXact/CREATE_ID > record. Ouch. For the record, somebody else (Jacob Bunk Nielsen) reported the same(?) is= sue independently on Slack: |We are running a PostgreSQL 17.7 primary with a number of physical replic= as. We upgraded some of the replicas from 17.5 to 17.8 earlier today, and = now 4 of them consistently die after a short time with errors like: | |Feb 13 13:36:01 srv2 postgres[13068]: [12-1] 2026-02-13 13:36:01 UTC::@:[= 13068]: FATAL: could not access status of transaction 155428864 |Feb 13 13:36:01 srv2 postgres[13068]: [12-2] 2026-02-13 13:36:01 UTC::@:[= 13068]: DETAIL: Could not read from file "pg_multixact/offsets/0943" at o= ffset 172032: read too few bytes. |Feb 13 13:36:01 srv2 postgres[13068]: [12-3] 2026-02-13 13:36:01 UTC::@:[= 13068]: CONTEXT: WAL redo at 9F79/27144740 for MultiXact/CREATE_ID: 15542= 8863 offset 1359592572 nmembers 2: 448728610 (keysh) 448728612 (keysh) | |Did we hit a bug in the newly released 17.8?=20 Sebastian, as it looks like you are able to reproduce it - are you maybe i= n a position to bisect from 17.5 to 17.8 to see which commit is responsible fo= r this? Michael