pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Evgeny Morozov <postgresql3@realityexists.net>
Cc: PostgreSQL General <pgsql-general@postgresql.org>
Subject: Re: "PANIC: could not open critical system index 2662" - twice
Date: Mon, 8 May 2023 15:20:03 +0900
Message-ID: <ZFiUkyuZ6KCsSpgR@paquier.xyz> (raw)
In-Reply-To: <CA+hUKG+wCOQzgLpWUrUvx_4SPUaeKC-ZK5mUwqP2G482syJyJw@mail.gmail.com>
References: <CA+hUKGLwDBnVHbef=p-BonSfiU1-XRoEg3ShECRZJFx2ti=TuQ@mail.gmail.com>
	<01020187eae42315-1cc83aed-2b4f-4c9e-ae36-ee82778f7154-000000@eu-west-1.amazonses.com>
	<CA+hUKGK7A42wpGvW3HouYAy+ud9c_8=5=jsaByR2-oxnbFkpZA@mail.gmail.com>
	<01020187f07f341f-d1593cf8-4fc7-4186-b70c-0c8862a2aa32-000000@eu-west-1.amazonses.com>
	<CA+hUKGJ-yWVQGJQiK5XHpD+97Qc533mNr1L=-sOQmCqDYoMB-w@mail.gmail.com>
	<CA+hUKGJDfBEfqatSsV16XosCkr=3k2vb6X1mcbL_kdod_wHQwQ@mail.gmail.com>
	<4029098.1683422490@sss.pgh.pa.us>
	<CA+hUKGJ5zz8a6-D5ZQcoftZbAeBDs_h_3NL87TndKhW_2_aw1Q@mail.gmail.com>
	<ZFhdcLp3x5Pg5Qr4@paquier.xyz>
	<CA+hUKG+wCOQzgLpWUrUvx_4SPUaeKC-ZK5mUwqP2G482syJyJw@mail.gmail.com>

On Mon, May 08, 2023 at 02:46:37PM +1200, Thomas Munro wrote:
> That sounds like good news, but I'm still confused: do you see all 0s
> in the target database (popo)'s catalogs, as reported (and if so can
> you explain how they got there?), or is it regression that is
> corrupted in more subtle ways also involving 1s?

Nope, I have not been able to confirm that yet without 8a86618.  The
test runs at a high frequency, so that's kind of hard to catch.  I
have not been able to get things in a state where I could look at a
FPW for pg_class or its index, either, in a way similar to Evgeny.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (65+ messages)  latest in thread

Message-ID: <ZFiUkyuZ6KCsSpgR@paquier.xyz>
Permalink:  ../ZFiUkyuZ6KCsSpgR@paquier.xyz/
Also on:    postgresql.org/message-id/ZFiUkyuZ6KCsSpgR@paquier.xyz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: michael@paquier.xyz, thomas.munro@gmail.com, tgl@sss.pgh.pa.us, postgresql3@realityexists.net
  Subject: Re: "PANIC: could not open critical system index 2662" - twice
  In-Reply-To: <ZFiUkyuZ6KCsSpgR@paquier.xyz>
  References: <CA+hUKGLwDBnVHbef=p-BonSfiU1-XRoEg3ShECRZJFx2ti=TuQ@mail.gmail.com> <01020187eae42315-1cc83aed-2b4f-4c9e-ae36-ee82778f7154-000000@eu-west-1.amazonses.com> <CA+hUKGK7A42wpGvW3HouYAy+ud9c_8=5=jsaByR2-oxnbFkpZA@mail.gmail.com> <01020187f07f341f-d1593cf8-4fc7-4186-b70c-0c8862a2aa32-000000@eu-west-1.amazonses.com> <CA+hUKGJ-yWVQGJQiK5XHpD+97Qc533mNr1L=-sOQmCqDYoMB-w@mail.gmail.com> <CA+hUKGJDfBEfqatSsV16XosCkr=3k2vb6X1mcbL_kdod_wHQwQ@mail.gmail.com> <4029098.1683422490@sss.pgh.pa.us> <CA+hUKGJ5zz8a6-D5ZQcoftZbAeBDs_h_3NL87TndKhW_2_aw1Q@mail.gmail.com> <ZFhdcLp3x5Pg5Qr4@paquier.xyz> <CA+hUKG+wCOQzgLpWUrUvx_4SPUaeKC-ZK5mUwqP2G482syJyJw@mail.gmail.com> <ZFiUkyuZ6KCsSpgR@paquier.xyz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox