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 1kO2Jd-00013i-9x for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Oct 2020 17:24: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 1kO2Jc-0002t8-7n for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Oct 2020 17:24:24 +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 1kO2Jc-0002t1-1o for pgsql-bugs@lists.postgresql.org; Thu, 01 Oct 2020 17:24:24 +0000 Received: from forward5-smtp.messagingengine.com ([66.111.4.239]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kO2JY-0003T3-PM for pgsql-bugs@lists.postgresql.org; Thu, 01 Oct 2020 17:24:23 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailforward.nyi.internal (Postfix) with ESMTP id EBCAC1942612; Thu, 1 Oct 2020 13:24:18 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Thu, 01 Oct 2020 13:24:18 -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=sHauAwI8vr/xEA5JuEBYCliqvCMjbDQ6SQX1Qn+bz lw=; b=R6pNsgU4k7bLtPE9W2S3rLARELX59LPKBn9fMhSXfc880QNXrWz0opPy1 fWgBs0Sl4sV+cqazjyoaEO4zyV+RfFQtEw8g+nWJzL+6SAL6cQ1VpUjQDJXAYUEW ceVSTlS0gOCBhtrGydpxqBnXStlxYn+QR56E4zL3yem01LWyA+o/XAlrSWG9+yP7 j+BPOIB91th9WSHKxI91Atdc0uJ7XPfSiUEBEW3BMk7iFjO7hDFlrnyF4i6bMEfW YVOfLk6ZBHEWnDI1OnHaCh+JfWjvCWpQVdFxMPsnskQWmViWwYqUMUPqN/Ro29mm fvSYh/ha8s52v3co+mVeYgPr4qIHA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrfeeggdduudegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtjeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuggftrfgrthhtvghrnheptdevgeehtdejvdevvdel jeeuveejjedtleelgfekleefieekjeelgfektdduuedvnecuffhomhgrihhnpedvnhguqh hurggurhgrnhhtrdgtohhmnecukfhppeekjedrudejjedrieegrdduledunecuvehluhhs thgvrhfuihiivgepudenucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghish 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 F066A306467E; Thu, 1 Oct 2020 13:24:17 -0400 (EDT) Subject: Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop To: Tom Lane , Alvaro Herrera References: <20200930214216.GA5296@alvherre.pgsql> <912614.1601502758@sss.pgh.pa.us> Cc: Henry Hinze , pgsql-bugs@lists.postgresql.org From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: <61e8b017-ad50-cedd-c85e-4e6c07322ac4@2ndquadrant.com> Date: Thu, 1 Oct 2020 19:24:17 +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: <912614.1601502758@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:52, Tom Lane wrote: > One thing I noticed while trying to trace this down is that while the > initial table sync is happening, we have *both* a regular > walsender/walreceiver pair and a "sync" pair, eg > > postgres 905650 0.0 0.0 186052 11888 ? Ss 17:12 0:00 postgres: logical replication worker for subscription 16398 > postgres 905651 50.1 0.0 173704 13496 ? Ss 17:12 0:09 postgres: walsender postgres [local] idle > postgres 905652 104 0.4 186832 148608 ? Rs 17:12 0:19 postgres: logical replication worker for subscription 16398 sync 16393 > postgres 905653 12.2 0.0 174380 15524 ? Ss 17:12 0:02 postgres: walsender postgres [local] COPY That's normal. You could also have even more if tables are syncing in parallel. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services