Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg4Dz-007SDg-Ro for pgsql-bugs@arkaria.postgresql.org; Thu, 06 Feb 2025 15:55:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tg4Dx-008w6E-Vu for pgsql-bugs@arkaria.postgresql.org; Thu, 06 Feb 2025 15:55:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tg4Dx-008w66-Lt for pgsql-bugs@lists.postgresql.org; Thu, 06 Feb 2025 15:55:29 +0000 Received: from rusty.tulip.relay.mailchannels.net ([23.83.218.252]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tg4Du-003Ybe-1p for pgsql-bugs@lists.postgresql.org; Thu, 06 Feb 2025 15:55:28 +0000 X-Sender-Id: hostingeremail|x-authuser|david@pgbackrest.org Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id D11258C3117 for ; Thu, 6 Feb 2025 15:55:24 +0000 (UTC) Received: from fr-int-smtpout7.hostinger.io (trex-4.trex.outbound.svc.cluster.local [100.122.220.145]) (Authenticated sender: hostingeremail) by relay.mailchannels.net (Postfix) with ESMTPA id B61C78C3F3D for ; Thu, 6 Feb 2025 15:55:23 +0000 (UTC) ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1738857324; a=rsa-sha256; cv=none; b=rsviDhkZRLIlAPBIS+LU9NMicgl5WvEtjOsDyUhPeX4quvbK1ewRmDu50XmV1VeG+Z8BxX Hu2eeYLAJvsR/cpksUmxlWnF/hwb5fV68H7PeqxnlKS35w5mwj7NYZoiuBAt6OS7eZtztu yNdhI/EULqFwMYhmllNp5fQwBmS6NNLDn/QD+ryHVxI09gs4uHd7elJEvDNFz1C0Nl9BAt P774BMNFGnq520RewzpEQfJ8lMQirmk8SQWejzS8bmJiBS5enDPD8RQobNUc+XD6VqX2gq wxizNWz9s8NIlr4P5gNc6s6z3fOQporSOiRX76WD++SgRJdHrhwA+P5UOhhjrw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1738857324; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:dkim-signature; bh=OqGJ65Osf3QRBcn+OstodRaBPW5Lll77slHLqxpOPyI=; b=BzkXJQoxmPADPlgTvy/UtBHr2/rnNnctINUMhrdngwtXlhOLujEqPf0M6B4sDEhmWrHNSn 77w/aPdQ+UUL/iy7ln5D2/kBay6ZZ26TVUKwWge32Pi03Rg4o0FfhWp9+h8i20yeXMQhM+ FqcQXvv12aABNP+cuwkQBuS9zxuCI/nKY+oq0XCSuMR3z0aArv/a5ASPnXCeQWBUUbjsmy Z4/7uzAiPag+PkaSsQL895l+WQ/lHsq6DEZ9RtwzDlKIHWHLCWDNj5W+B/YH8CIn4Tfqgr ZKo4S9Sbq8ZIenhxBwnkc/JW2cVTfMuXnmprkRfudWyzxC9q1JqZ7ZcI1TnK1Q== ARC-Authentication-Results: i=1; rspamd-854f7f575d-hnm7x; auth=pass smtp.auth=hostingeremail smtp.mailfrom=david@pgbackrest.org X-Sender-Id: hostingeremail|x-authuser|david@pgbackrest.org X-MC-Relay: Neutral X-MailChannels-SenderId: hostingeremail|x-authuser|david@pgbackrest.org X-MailChannels-Auth-Id: hostingeremail X-Eight-Tasty: 60f263e179096644_1738857324373_2134863019 X-MC-Loop-Signature: 1738857324373:41174314 X-MC-Ingress-Time: 1738857324373 Received: from fr-int-smtpout7.hostinger.io (fr-int-smtpout7.hostinger.io [89.116.146.203]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.122.220.145 (trex/7.0.2); Thu, 06 Feb 2025 15:55:24 +0000 Message-ID: <73f2e462-d767-4248-98ed-9c0fcdac10bf@pgbackrest.org> DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgbackrest.org; s=hostingermail1; t=1738857321; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=OqGJ65Osf3QRBcn+OstodRaBPW5Lll77slHLqxpOPyI=; b=ku7XDicZcDrPY1DKA0mgI3qDf3tGS2FZ8OpJZ2xNJ0xH2r8OncMyHhMbzspROcSuca8zQc nPjuD+0le0QRehmsDxLcMCFRztLl7dUtERESSMqRof66neA6xvgggbkfBygjkwtCcmciQd UwddjFMUl7gnL4PpYmZl0m3xqMFZwisyFnPVrHT8dfbYQ4mh7WFXoV1lZ5aZ+FfFcf/V6l rIGsl7ecS/HeYb4ePyQ/x5VsqBRpsCcFWGgJEr73d7lzeAWpZNCt1Pdh2q/0PmKab5vVXf Pvw/w8vH/AteWmIeDyAGHKyTetDkekq1KG10SGXpNHC987rxEko/jGbii5yY5Q== MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Bug in recovery of drop database? From: David Steele To: "pgsql-bugs@lists.postgresql.org" References: <43f0c3df-a23c-4159-9610-934d3dceb80c@pgbackrest.org> Content-Language: en-US In-Reply-To: <43f0c3df-a23c-4159-9610-934d3dceb80c@pgbackrest.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Date: Thu, 06 Feb 2025 15:55:21 +0000 (UTC) X-CM-Analysis: v=2.4 cv=PMNd+uqC c=1 sm=1 tr=0 ts=67a4db69 a=d3+0EILdtfgUD8LTxdsywg==:117 a=d3+0EILdtfgUD8LTxdsywg==:17 a=IkcTkHD0fZMA:10 a=yGXLiA1v5bLKWRnEVNwA:9 a=3ZKOabzyN94A:10 a=QEXdDO2ut3YA:10 X-CM-Envelope: MS4xfCsI6U6UAR31LftXV8dOkG649GuvvJO0YMSGbKmqjj+xzPx70JVcRp9amD2NKF4mJ7MeR2l2zM7h+KMsdCebdTurrcLoqGrOTdwEaxdMvvc1zKW4lbpu BRSfHfupwKLTT9uWzKjNwq5JoM2xAQbGX5fC2AwWQTc2xroGcbj15u0+u2G6tokEvoxolF9SZVBZlxxXr419s5mPCT735LgbKu4= X-AuthUser: david@pgbackrest.org List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/5/25 15:24, David Steele wrote: > > psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: > FATAL:  cannot connect to invalid database "mytest" > HINT:  Use DROP DATABASE to drop invalid databases. Since this error message started cropping up fairly recently I had a look at related commits and found this: c66a7d75 Handle DROP DATABASE getting interrupted This commit changed the error message so it is more obvious that something has gone wrong, but the underlying issue appears the same for recovery. Before c66a7d75 it looked like this: FATAL: database "mytest" does not exist DETAIL: The database subdirectory "base/16384" is missing. Which seems reasonable when just looking at the error and not the detail. Regards, -David