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 1pudVa-0004sT-52 for pgsql-general@arkaria.postgresql.org; Thu, 04 May 2023 18:16:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pudVY-0007vz-Jb for pgsql-general@arkaria.postgresql.org; Thu, 04 May 2023 18:16:48 +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 1pudVY-0007vq-7L for pgsql-general@lists.postgresql.org; Thu, 04 May 2023 18:16:48 +0000 Received: from mail-yb1-xb2d.google.com ([2607:f8b0:4864:20::b2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pudVR-000ZxR-7N for pgsql-general@lists.postgresql.org; Thu, 04 May 2023 18:16:47 +0000 Received: by mail-yb1-xb2d.google.com with SMTP id 3f1490d57ef6-b9a6869dd3cso1169484276.2 for ; Thu, 04 May 2023 11:16:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1683224198; x=1685816198; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=flrqIwSg2lfGneuqTm48gffM93NIpIdjxDJ3tCAzNcI=; b=oi7rcmMV+OeE2FLNzWfJeZ2Z+o/JkVmAATHtPe3KXRkLqOZkycegGY+W1VyvolPnVz Y6xtze9PH0lwtGPJRth9uT24rLMy1IU5V9k4uW7ezl3mpD9nJFRsQ5ZMrSGIQcHlEcJs r3DC5VOur4F2ymxNM/BaucZmXZCiPIUtLALqvbsi/RoKkXziAKEzAgj4m1qlybPrs+0N JT5sFortGSfWhKCe63t6oyRWwp2JWuMWItiT/GtjkFs4qYvYV8f9q2/KY1zTplgyQHaB oabC7F79by0j2+I5l0C0McISxasJOZXd2Q0es6mbFptp1i41BQM7OY5GqbIGZ1Xk8SEp 8f1Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1683224198; x=1685816198; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=flrqIwSg2lfGneuqTm48gffM93NIpIdjxDJ3tCAzNcI=; b=ZaOEnCCC2V3ePL1PudetbFA+4JoYWlBDYrUYwl5NEYFwM3eJ2J/xd0uplDJP/deFkw SKQFknQRVoX/a4oe9dBiZyJza+EJE01Cvnsidnfeqx57lnL4XvDteua7Of0RNk9kp/8w d1kD6CPj1b2m0zf3MJR2RIeqt3FHQE5NaxyAuRXPy0bp1Zk4ZLjHk2pigaFh8w6ZAoNH Gck69IoeYR3gYRpIM6PMLzUb4zQZa0IgZ/jVHSm7xi7X4TRbO9ZMr7mihDF4LAcpBouo eHg3j318bzh6t+uhtaFPbJrXVX4yToRYC5uahAoGEacpC8M9Nxm6NsoDAddyG05se6Oq hu0Q== X-Gm-Message-State: AC+VfDyl0PLe/k3t8SZFWgsClGHEXpLF+zNZ1RazaZj7I1gk/53P/xhn 4CEmPwo78R4Ryizwj4i8G/V83zoH4Oo= X-Google-Smtp-Source: ACHHUZ4GoeMhmWANYs1Vj0DI0rfOKjnfHVhONdX58lhYZvAAV1XW5IdM9hat9Laecboi/FRE8meWcw== X-Received: by 2002:a05:6902:110a:b0:b9a:5fd8:770b with SMTP id o10-20020a056902110a00b00b9a5fd8770bmr985495ybu.52.1683224198469; Thu, 04 May 2023 11:16:38 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:2d44:5ae8:5b2e:785a? ([2600:1700:bd2c:b810:2d44:5ae8:5b2e:785a]) by smtp.googlemail.com with ESMTPSA id c198-20020a814ecf000000b0054fa9e39be0sm545453ywb.56.2023.05.04.11.16.38 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 04 May 2023 11:16:38 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------dTuvqTfl8DtXHMgiINNQviR5" Message-ID: Date: Thu, 4 May 2023 13:16:37 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: "PANIC: could not open critical system index 2662" - twice Content-Language: en-US To: pgsql-general@lists.postgresql.org 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> <01020187e7f5a96c-9bd4497c-abff-4c91-8a3f-e751a1f7d4b4-000000@eu-west-1.amazonses.com> From: Ron In-Reply-To: <01020187e7f5a96c-9bd4497c-abff-4c91-8a3f-e751a1f7d4b4-000000@eu-west-1.amazonses.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------dTuvqTfl8DtXHMgiINNQviR5 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 5/4/23 13:10, Evgeny Morozov wrote: [snip] > I'm now thinking of setting up a dedicated AWS EC2 instance just for > these little DBs that get created by our automated tests. If the problem > happens there as well then that would strongly point towards a bug in > PostgreSQL, wouldn't it? Many other people besides you would have noticed regular corruption of system catalogs. > Meanwhile, what do I do with the existing server, though? Just try to > drop the problematic DBs again manually? *"Fix the hardware"* is what you do. -- Born in Arizona, moved to Babylonia. --------------dTuvqTfl8DtXHMgiINNQviR5 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit On 5/4/23 13:10, Evgeny Morozov wrote:
[snip]
I'm now thinking of setting up a dedicated AWS EC2 instance just for
these little DBs that get created by our automated tests. If the problem
happens there as well then that would strongly point towards a bug in
PostgreSQL, wouldn't it?

Many other people besides you would have noticed regular corruption of system catalogs.

Meanwhile, what do I do with the existing server, though? Just try to
drop the problematic DBs again manually?

"Fix the hardware" is what you do.

--
Born in Arizona, moved to Babylonia.
--------------dTuvqTfl8DtXHMgiINNQviR5--