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 1kO2I9-0000zp-AV for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Oct 2020 17:22:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kO2I7-0001E5-DZ for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Oct 2020 17:22:51 +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 1kO2I6-0001Dy-Ll for pgsql-bugs@lists.postgresql.org; Thu, 01 Oct 2020 17:22:51 +0000 Received: from forward5-smtp.messagingengine.com ([66.111.4.239]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kO2I3-0007sc-SN for pgsql-bugs@lists.postgresql.org; Thu, 01 Oct 2020 17:22:49 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailforward.nyi.internal (Postfix) with ESMTP id CA9C01942524; Thu, 1 Oct 2020 13:22:46 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Thu, 01 Oct 2020 13:22:46 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; bh=aSBJ5+trR+6YekS48IG9x1q5dd2vVfAh1ABVbBa8V Dw=; b=jcTp8V9FE1dfe9XBJZdv+QSAZj3PHWs7sTGCspMN2AAUrNbeGJUVWa3hL kU30N8u/mpNltLnOHfH22Utcvt+48KeO8GEDFftYAtYI5ameAi5kHpY0aOrZi9c5 535u1BxKS8RhQwjdI8jGwX0bbWBbL27b61RCwU2XoH7g/QBQ2JcoywtXdjpKWTVD Jo1YtXwW9X9EBA7LyDCOkn2zSN5zrmda4Hq3E+no4gkzU8fWK/5POz7PI28j5+Mk XlKSr7OLd9Y1nXNDuHWvjQs70UOk0CPZUX+955jwd1PX1093DnSqnpJFYT3Sw2uw Wz9Yf2UatYoH4NsgPJ5fSqThxIHmw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrfeeggdduudegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuggftrfgrthhtvghrnheptdevgeehtdejvdevvdel jeeuveejjedtleelgfekleefieekjeelgfektdduuedvnecuffhomhgrihhnpedvnhguqh hurggurhgrnhhtrdgtohhmnecukfhppeekjedrudejjedrieegrdduledunecuvehluhhs thgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghish gvnhhtrhgruhhtsedvnhguqhhurggurhgrnhhtrdgtohhm X-ME-Proxy: Received: from april.pezone.net (p57b140bf.dip0.t-ipconnect.de [87.177.64.191]) by mail.messagingengine.com (Postfix) with ESMTPA id 73A643064680; Thu, 1 Oct 2020 13:22:45 -0400 (EDT) Subject: Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop To: Tom Lane , Henry Hinze References: <16643-eaadeb2a1a58d28c@postgresql.org> <718213.1601410160@sss.pgh.pa.us> <911656.1601501524@sss.pgh.pa.us> Cc: pgsql-bugs@lists.postgresql.org, Alvaro Herrera From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Thu, 1 Oct 2020 19:22:44 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <911656.1601501524@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-09-30 23:32, Tom Lane wrote: > The question that this raises is how the heck did that get past > our test suites? It seems like the error should have been obvious > to even the most minimal testing. What's the difference between this case and what the test suite is testing? Is it that it replicates between two databases on the same instance? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services