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 1kALhR-0001WX-Gd for pgsql-admin@arkaria.postgresql.org; Mon, 24 Aug 2020 23:16:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kALhQ-0002yY-F1 for pgsql-admin@arkaria.postgresql.org; Mon, 24 Aug 2020 23:16:24 +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 1kALhQ-0002yR-6p for pgsql-admin@lists.postgresql.org; Mon, 24 Aug 2020 23:16:24 +0000 Received: from tamriel.snowman.net ([96.255.250.162]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kALhO-0005bI-4e for pgsql-admin@postgresql.org; Mon, 24 Aug 2020 23:16:23 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 44B3C5F79F; Mon, 24 Aug 2020 19:16:21 -0400 (EDT) Date: Mon, 24 Aug 2020 19:16:21 -0400 From: Stephen Frost To: Alvaro Herrera Cc: Wells Oliver , pgsql-admin Subject: Re: Odd pg dump error: cache lookup failure Message-ID: <20200824231621.GA29590@tamriel.snowman.net> References: <20200824231338.GA30623@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="dn4iaw7gNQO9SGk8" Content-Disposition: inline In-Reply-To: <20200824231338.GA30623@alvherre.pgsql> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --dn4iaw7gNQO9SGk8 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Alvaro Herrera (alvherre@2ndquadrant.com) wrote: > On 2020-Aug-24, Wells Oliver wrote: > > 12.4. Both of those queries return no rows, with and without those opti= ons > > set. > >=20 > > We do do some nightly processing of data during the same window, in whi= ch > > views are re-materialized: would that cause this issue? No non-temporary > > tables are dropped or re-created, though. >=20 > Oh, so this could be some kind of relation that exists when pg_dump > starts but is dropped before it reaches the point where it dumps the > data for that relation. >=20 > Hmm. That'd be cute since pg_dump should be locking all the relations that it's going to export the data from... Thanks, Stephen --dn4iaw7gNQO9SGk8 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJfREpEAAoJEO1sijiDR2RV0UoP/1hIbSzWYA54gLCvx13b2fHC a5uPX7UgHplwKptTRtH8fks3aj2kBOhIWq+JxITxjfonrMK7cwcStYZWA+fkclI+ If6NGH1qJWKcTkyIVIO+UONbsvUauDCpcDpGtzg5DScyVHMh/lJPQKVMkxQ25/QM YRas8WWxvVJHQVcRtg/dlMYyr/ePPvFGCF4OddFZXH+7Wxf7UIFfCW1dlc41BMtq 1dCmBjzlIq+IYj43wvJZY6e/7pZh6sDtDjiR28IvvN1IoYtyaZT3ToBORX9hlDOH +XB9FplcpZP09jbOUYaQjOmzv9Qbxfj0an/PON4Cg6xBSfSmxGWJbbj7J8WuFo4F 0XHphy8ViREwKRTRB30HG8TvzQcqh34b5SPDxXxLxeoqaL1QUthJXCMDUuatgkpe Rhs6JIsWDhLYF8+THrmoGoGD1fkX21T+mKi/0idaTZolu5K1dND8T2w5JrUTYmHN s6I6LRKxVvFHwmBTVsT2y66eRTTrX7XrFxbTx9PVMNL6BWBGtGA3W3tkLcPMRWKM Yqb2waz3Che3sBtKaVb7PZXEEm7ayMg/2BAYo6mUYtW2oqaNDr2Vv56kde16C+R3 KY9KV8no2n3N/fReMw1Ul0Jgmo7rj1AcFb+V3AZ1pKW7q+NNH5JY+Ai9eoderhLD FZkrGmGFGt2Xj4vMcLm6 =/rWD -----END PGP SIGNATURE----- --dn4iaw7gNQO9SGk8--