Re: "PANIC: could not open critical system index 2662" - twice
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Evgeny Morozov <postgresql3@realityexists.net>,
PostgreSQL General <pgsql-general@postgresql.org>
Date: 2023-05-07T01:21:30Z
Lists: pgsql-general
Thomas Munro <thomas.munro@gmail.com> writes:
> Did you previously run this same workload on versions < 15 and never
> see any problem? 15 gained a new feature CREATE DATABASE ...
> STRATEGY=WAL_LOG, which is also the default. I wonder if there is a
> bug somewhere near that, though I have no specific idea.
Per the release notes I was just writing ...
<listitem>
<!--
Author: Michael Paquier <michael@paquier.xyz>
Branch: master [8a8661828] 2023-02-22 10:14:52 +0900
Branch: REL_15_STABLE [fa5dd460c] 2023-02-22 10:14:56 +0900
-->
<para>
Fix potential corruption of the template (source) database after
<command>CREATE DATABASE</command> with the <literal>STRATEGY
WAL_LOG</literal> option (Nathan Bossart, Ryo Matsumura)
</para>
<para>
Improper buffer handling created a risk that any later modification
of the template's <structname>pg_class</structname> catalog would be
lost.
</para>
</listitem>
The comment about only pg_class being affected is my interpretation
of what the commit message said, but I might have misunderstood.
regards, tom lane
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Handle DROP DATABASE getting interrupted
- f66403749df7 15.4 landed
- 1c38e7ae17b6 11.21 landed
- 034a9fcd2bb8 12.16 landed
- 81ce000067e3 13.12 landed
- d11efe830385 14.9 landed
- a4b4cc1d60f7 16.0 landed
- c66a7d75e652 17.0 landed
-
Remove the restriction that the relmap must be 512 bytes.
- d8cd0c6c95c0 16.0 cited