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 1pmySt-0006SY-3m for pgsql-general@arkaria.postgresql.org; Thu, 13 Apr 2023 15:02:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pmySr-00050n-Gc for pgsql-general@arkaria.postgresql.org; Thu, 13 Apr 2023 15:02:21 +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 1pmySr-00050d-37 for pgsql-general@lists.postgresql.org; Thu, 13 Apr 2023 15:02:21 +0000 Received: from mail-lf1-x12d.google.com ([2a00:1450:4864:20::12d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pmySj-002f8W-Hm for pgsql-general@postgresql.org; Thu, 13 Apr 2023 15:02:20 +0000 Received: by mail-lf1-x12d.google.com with SMTP id i26so19907831lfc.6 for ; Thu, 13 Apr 2023 08:02:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1681398132; x=1683990132; 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=AHOKe1swkqrGvAYZKcmmDGFE/rjkUU+xrZyxh9lU4Ws=; b=kgeoVBhGj8/ZRUnUDzxb9kec6nzh4r9S10UExVBUu2D88pGwIWEcsOaFvku6WDPlfj rMN2v+m/W/16qV67oFbPrKo8SU7j0O1PjMotcaP9+JIs0wFMW/faa9/jpNtmwJvVdEA4 rLKqADQ3I0BW+Hyuvq+MI8//H2H6lS94ntIPagQs/QqJVZo1xe2NZ97MAc9OoItTyfZM ccIHeSvaAzROsoI6Yk6rPgoK1H9YlMTeswU2caP+40uoxaQv7l3yJxKR6TrtRmhzRSMa 5xR+Vex5hJSNlgQ7noHL64lW1sZUp1T8UK3ClafCEyWGXlo+SF9Xu+KoqDYaWViRZl+O 4SZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681398132; x=1683990132; 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=AHOKe1swkqrGvAYZKcmmDGFE/rjkUU+xrZyxh9lU4Ws=; b=dsFLbMEW79u+rvd57GpoJLyKOznZgPGEBWrEWcbBroGT/yJYJBiZbKyPOHnJrGXtEw F2qQS9j8EAKvzieb3hTohzXOSVtsYpA9ArBxNVuFHqPu+34F1eJebiKz2UyH2zD2h4w4 Hw/1QJNje7o+zqVTB9ekMN3qeODfv5j0KjG9pqiBTGpr3bgNQZ9O7lzUrye5b55eGzmR fk0yuO4+NcR3rZSFACXwnSGFsLW4sgphMgJjmbEAugk0MGipOkyJZXJhEbRiff2RAup/ XCgkp5rg2LBieSgcpM2E5luGJMzDEtWmPSC98hpDnRRT8XaHrUTyJmH35HBjocEoK4YE +X+w== X-Gm-Message-State: AAQBX9ddPhcKX75Qwgs6mjVXuaJlX5LrL37Cn2oNeu7ORZY3oGfExQSq rneJ1N3mfPGAb6dUP16m5O5A0fhg6rGpPLuWq9Q= X-Google-Smtp-Source: AKy350YkEt6qFxWP1UO8yfo4LjSSv9U8CFyMS7SUQCzNeK67vi/ZDOj/4iNr5N0IwKCKHy94Qdw3+A== X-Received: by 2002:ac2:4c25:0:b0:4eb:44da:e85d with SMTP id u5-20020ac24c25000000b004eb44dae85dmr907983lfq.57.1681398132135; Thu, 13 Apr 2023 08:02:12 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:ce71:d665:1f23:b3f6:2db2]) by smtp.gmail.com with ESMTPSA id nd23-20020a170907629700b0094e9f87c6d4sm1071653ejc.192.2023.04.13.08.02.11 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 13 Apr 2023 08:02:11 -0700 (PDT) Message-ID: Subject: Re: "PANIC: could not open critical system index 2662" - twice From: Laurenz Albe To: Evgeny Morozov , Michael Paquier Cc: PostgreSQL General , "Peter J. Holzer" Date: Thu, 13 Apr 2023 17:02:11 +0200 In-Reply-To: <010201877966fc0d-e09f5a0b-e846-417b-b30a-b8d57ac61fa3-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> 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 06:56 +0000, Evgeny Morozov wrote: > On 12/04/2023 2:35 am, Michael Paquier wrote: > > initdb does not enable checksums by default, requiring a > > -k/--data-checksums, so likely this addition comes from from your > > environment. >=20 > OK, so then what does that mean for the error in the subject? At what > point should that problem have been detected by the data checksums? It means that if the error is caused by a faulty disk changing your data, you'll notice as soon as you touch the page. 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. Yours, Laurenz Albe --=20 Cybertec | https://www.cybertec-postgresql.com