Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1puc2T-0006JH-7G for pgsql-general@arkaria.postgresql.org; Thu, 04 May 2023 16:42:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1puc2R-0006gY-SX for pgsql-general@arkaria.postgresql.org; Thu, 04 May 2023 16:42:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1puc2R-0006gP-D0 for pgsql-general@lists.postgresql.org; Thu, 04 May 2023 16:42:39 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1puc2O-000ZGr-P7 for pgsql-general@postgresql.org; Thu, 04 May 2023 16:42:38 +0000 Received: by mail-ed1-x532.google.com with SMTP id 4fb4d7f45d1cf-50bc4ba28cbso1329260a12.0 for ; Thu, 04 May 2023 09:42:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1683218556; x=1685810556; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=ibynluT4iWDsCa4iidnxCwLVHBQ6HovU4FSUBBCUpnQ=; b=srRM313gm7wGLgtI8zbGHP+oNaBdMYH2pSSz0NOZcD4m/k8iouN7HbMjyLJQCOqaio 0L+EYOMs7fz1m4mBdN2AXfvnSKcxx6rLCbgq/T7SYBZBhaUqlv0h2MhWPoibJAySJc48 WnAThZ8muw9nYxIqjkDYTwcaQlUb8+979E1PYZXMrjtvo6d+ubsfjFBwiAh4W4EybKVh sHoZtnDcaz2kvDPO26hLHevixHm87x/gAMCBZurQj3fBXZwMcFWBfV3fVJwSeH02OsOf 09OauzLY+02/7a5wxqL5tPfS/hxQjm3CdelaD2HK4iJdTsaJ7/MgFGCx3TSzG7/hFW0E OPiw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1683218556; x=1685810556; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=ibynluT4iWDsCa4iidnxCwLVHBQ6HovU4FSUBBCUpnQ=; b=WQo//z9PF4dgx+g2UkmasjPTDMN1zg2gQdAbfrKZTZfGGXORw3moQUX1hEtWX/1naC 1qfexIs+NkZO6b0RM3hvq/Tz1RgA2vcWy2S5r4y98Mdzfes1QYcj3IrGs49DVpPsyaX8 h1jEkY/TcdPrCmnDixw4zhVnnTnoSV66+UDpbsLh36TkoPmk9EcEnKiG0cewiwb4rVW0 cV4omyYAyTcrg/jByAQagklM5TajgckMXVeHLnDGeJ+67MpjfadLnd6TB4w3ekqDz8TC PONXkIHT1kjHiZ1mbFyGWucxgDmgzpUUZuVLA1ta2c3+pXUEg86VUtXp8lSR94L76jRh XsEw== X-Gm-Message-State: AC+VfDzCb9KgxMRwoOkcuQAVgkNT+T9Q7Kn4HfZfMy8Hk1jnT4WrfP8W ZBoRQtNICEgmCYRsIux9LL5Z7A== X-Google-Smtp-Source: ACHHUZ43QuqnrIFJ8c4mgw+Ez6/DUf1+MZk2f2Fx4+WeKcf7vNhE1WmISNj7XBxn5m0wwKRJILvELQ== X-Received: by 2002:a05:6402:757:b0:509:c669:6841 with SMTP id p23-20020a056402075700b00509c6696841mr1796555edy.37.1683218555802; Thu, 04 May 2023 09:42:35 -0700 (PDT) Received: from localhost.localdomain (62-47-147-14.adsl.highway.telekom.at. [62.47.147.14]) by smtp.gmail.com with ESMTPSA id hy12-20020a1709068a6c00b0094f09cd4658sm19181071ejc.71.2023.05.04.09.42.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 04 May 2023 09:42:35 -0700 (PDT) Message-ID: Subject: Re: "PANIC: could not open critical system index 2662" - twice From: Laurenz Albe To: Evgeny Morozov , Alban Hertroys Cc: PostgreSQL General Date: Thu, 04 May 2023 18:42:34 +0200 In-Reply-To: <01020187e773e031-eecea370-714f-4858-82e5-ed1c9091eb6f-000000@eu-west-1.amazonses.com> References: <01020187577238cf-da8c0f4a-3ab9-445a-8c74-31ef51439f30-000000@eu-west-1.amazonses.com> <4f4ab16320d7b3a4e9950eaabde752dce204dc77.camel@cybertec.at> <010201877134be1c-fb837249-04a1-4cb0-a13f-c542425b50a0-000000@eu-west-1.amazonses.com> <010201877966fc0d-e09f5a0b-e846-417b-b30a-b8d57ac61fa3-000000@eu-west-1.amazonses.com> <010201877c0423c8-0a35b03c-d274-4857-ba99-ff7ea51d676b-000000@eu-west-1.amazonses.com> <8486f71f9c11e98af787e15e2d2ed0ecfdbf6ee7.camel@cybertec.at> <010201877eb3c125-d9aff979-cad6-407b-8b4e-012487666088-000000@eu-west-1.amazonses.com> <01020187e773e031-eecea370-714f-4858-82e5-ed1c9091eb6f-000000@eu-west-1.amazonses.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-05-04 at 15:49 +0000, Evgeny Morozov wrote: > Well, the problem happened again! Kind of... This time PG has not > crashed with the PANIC error in the subject, but pg_dumping certain DBs > again fails with >=20 >=20 > pg_dump: error: connection to server on socket > "/var/run/postgresql/.s.PGSQL.5434" failed: FATAL: =C2=A0index > "pg_class_oid_index" contains unexpected zero page at block 0 If you dumped and restored the database after the last time the error happened, there must be a systemic problem. Perhaps you have bad hardware, or a problem with a storage driver, file system or some other low-level software component. It might of course be a PostgreSQL bug too, but it is hard to say without a way to reproduce... Yours, Laurenz Albe