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 1pn9bS-00055W-Eh for pgsql-general@arkaria.postgresql.org; Fri, 14 Apr 2023 02:55:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pn9bR-0004Zk-8n for pgsql-general@arkaria.postgresql.org; Fri, 14 Apr 2023 02:55:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pn9bQ-0004Zb-QP for pgsql-general@lists.postgresql.org; Fri, 14 Apr 2023 02:55:56 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pn9bO-0003bb-KO for pgsql-general@postgresql.org; Fri, 14 Apr 2023 02:55:55 +0000 Received: by mail-ej1-x631.google.com with SMTP id dm2so42352822ejc.8 for ; Thu, 13 Apr 2023 19:55:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1681440952; x=1684032952; 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=DHrstAlFuvBvdnQ/0Vxt8Uu7m62IccmAQXS9CAYNlzM=; b=3bNWw3RQwG3KGsRG5uoDV8oTodvCsGba/sJOCcQzaUPcsMfYtwt9Rkkf3RyxByNlPy lu4hYSPiUMLPFqYb0Zs1gQqCiy2PTCPBn13hrRw2auoS8Cy8a4pEk8bSjwu9chn8i1Xb 38jAGzSVvg4MVN81seEw8epNlm6J+uankqS9DFOfgAhMTn9UmWlBsa0DxnHlsqUPr8qT Cx1NmMjmbu+dMvdRb6ZW7KFFbaxHTzMD9FYJOQDOKj8JpTquizPs4cyPkubCSEy9t6H/ ZHO1rqkxTeVBLOiOguWAUUFvix579c5A3pCW9g2uQGMUEDF8AUrQ5I8cJCu6666wlEtC pIag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681440952; x=1684032952; 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=DHrstAlFuvBvdnQ/0Vxt8Uu7m62IccmAQXS9CAYNlzM=; b=W/CAwmnqBeMizgWqveGHvex7heoVHyab3WKOZ3VkiEz6vP+/MD433B1LXQEOlcWE0v Phv2sL05Zv6AByUkqZ2eIieVAvycmnZw6kkpCIu0NgJeU+YV1GvzHZfsqy/TO7mpktNd wXyJ8VQ69Ac/9ltMXYD86e+7ReUhW0LtOKzuPHigp134B+ABaHopovb8xm/Tzfphc+nb 78oFSkUdvv34RXHGZ5QKb1kG5KkfOAyNyMCq1v7qCiWtauJdCGMYKmIH+AQsBwexgOhs vYpPPRJwZT5gxGpccdscgYKdFU7nKuiEDWb2xQh+O0Qf7fx9wRNBkzAxdxniJ3ucvCUf ORtA== X-Gm-Message-State: AAQBX9e49p/N6w3Z1L9MSVZ7B/9ZdRwnrl+Ga7AggbGEqG37u3B4vMFF yJcLIQaTBazW7b83QNm5GKLzcx3ewCk8Bg2Cbas= X-Google-Smtp-Source: AKy350a7TAaxTswK8Wxzd4zLtLV2QAy0/+dCkaj9UomTfcDz2oj+pNXScfTxuqR8Qiz9Mm+4iWBC7w== X-Received: by 2002:a17:906:ca1:b0:94a:bd17:fc40 with SMTP id k1-20020a1709060ca100b0094abd17fc40mr5151938ejh.25.1681440952095; Thu, 13 Apr 2023 19:55:52 -0700 (PDT) Received: from localhost.localdomain (178-190-180-97.adsl.highway.telekom.at. [178.190.180.97]) by smtp.gmail.com with ESMTPSA id mf21-20020a1709071a5500b00947a97a42f2sm1770189ejc.103.2023.04.13.19.55.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 13 Apr 2023 19:55:51 -0700 (PDT) Message-ID: <8486f71f9c11e98af787e15e2d2ed0ecfdbf6ee7.camel@cybertec.at> Subject: Re: "PANIC: could not open critical system index 2662" - twice From: Laurenz Albe To: Evgeny Morozov Cc: PostgreSQL General Date: Fri, 14 Apr 2023 04:55:50 +0200 In-Reply-To: <010201877c0423c8-0a35b03c-d274-4857-ba99-ff7ea51d676b-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> 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-04-13 at 19:07 +0000, Evgeny Morozov wrote: > On 13/04/2023 5:02 pm, Laurenz Albe wrote: > > It means that if the error is caused by a faulty disk changing your dat= a, > > you'll notice as soon as you touch the page. > >=20 > > That would perhaps not have made a lot of difference in your case, > > except that the error message would have been different and proof > > that the disk was the problem. >=20 > OK, but we had data checksums on the whole time. So that means that the > disk was NOT the problem in our case? Hmm, I am not certain. The block was filled with zeros from your error message, and I think such blocks don't trigger a checksum warning. So if your disk replaces a valid block with zeros (filesystem check after crash?), that could explain what you see. Yours, Laurenz Albe