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 1jMoZn-00053f-NU for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Apr 2020 07:59:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jMoZm-0007CP-8d for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Apr 2020 07:59:46 +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 1jMoZk-0007Ag-Jg for pgsql-bugs@lists.postgresql.org; Fri, 10 Apr 2020 07:59:46 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jMoZf-0002oN-7Q for pgsql-bugs@postgresql.org; Fri, 10 Apr 2020 07:59:43 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 0AF025C01EA; Fri, 10 Apr 2020 03:59:38 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Fri, 10 Apr 2020 03:59:38 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=OPQZiIqOad6mKNoVqKmQZWqe8Hu U5IUlo7xOJInoNU0=; b=bPCCjYmyKRkMgcLOqmn1h0K1GO38k80+8rUHMcnnper pK7XBb4yTFHqaJLtUabUldq/ikIorSr1YvWZmPObNy0TuzMmuu17XZrKXAo+IpeH SbIvRRMufpD8djmBiondbZYyiM0Yu2zOpc+qOU+CLwg6nltKOnmynnRR08HDDDJP tV1KbfeStrofHw5MONWTw5H6/OcM8xfpv6gv0idCvgLb5CfU1t4N4y7LhzTsJn2g 6Bab1sBNSBblUERIdCfZJym6ESePM5lUI8ngZjzt+utVQIFHX7Nty4noVI8JuGo6 exAVRPea6nWuEAld8Eii3YJ9Y6iWhV7epjBFzGrptuQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc: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=fm2; bh=OPQZiI qOad6mKNoVqKmQZWqe8HuU5IUlo7xOJInoNU0=; b=Q5nqVKCpIFGaDei99a/kXF usqWA3tOej9RrNzV2EBmRbZGHQFycKAX0M0loN4S78WbNum3y/ZvbsZJbgahEfC1 7xenpbacJ9eVrhej6Z9T81nfUStjBzPW7Z8IH2Q9Dg74RAFchl59qKhI73zU7Q1Z NIrf4tqp4ZWEKIxn9tvR6eW2YEdZr+Pk70OOulfwCIXpYDA477HWJXG2K5YVGIRo 8HROIDJ4CxTdkqGymfzLAyD0907/hcZArwJPZo3eQ7MvSypmIaywke7xTYRMYIo3 iUNVHDi2JX1wucxthbt+jP4JmNsRPtSbQ0FF6cpxh2oLVfPbms7goDbn3bsd+3Lw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrvddugdduvdegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucevlhhu shhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlse hprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id ABFBF306005C; Fri, 10 Apr 2020 03:59:35 -0400 (EDT) Date: Fri, 10 Apr 2020 16:59:32 +0900 From: Michael Paquier To: hubert depesz lubaczewski Cc: Victor Yegorov , Andrew Gierth , pgsql-bugs mailing list Subject: Re: Loss of replication after simple misconfiguration Message-ID: <20200410075932.GY1606@paquier.xyz> References: <20200409140836.GA5990@depesz.com> <878sj4skmj.fsf@news-spur.riddles.org.uk> <20200410041434.GU1606@paquier.xyz> <20200410072651.GA16098@depesz.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="j6zkAHxOZJkiczrA" Content-Disposition: inline In-Reply-To: <20200410072651.GA16098@depesz.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --j6zkAHxOZJkiczrA Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Apr 10, 2020 at 09:26:51AM +0200, hubert depesz lubaczewski wrote: > In our case it was *at least* this scenario: >=20 > 1. master and slave both with max_worker_processes and > track_commit_timestamp off. > 2. config files get changed on both to include track_commit_timestamp on > 3. slave gets restarted > 4. config files get changed on both to include max_worker_processes =3D 50 > 5. master gets stopped by "power outage" > 6. after master re-starts, replication to slave dies. Without the standby restarted here, its configuration remains at the former value of max_worker_processes, which is lower than the setting of the primary, so it would logically stop in this case if not restarted once it replays the XLOG_PARAMETER_CHANGE record generated =66rom the primary. > Andrew suggested yesterday on IRC that it could be timing issue, so > testing for it might be complicated - hence my inability to replicate > the problem in test environment. I am actually wondering if we may not be putting our finger on another issue related to the minimum consistency LSN here. > I will try to do the tests using extended scenarios with slave2 and > slave3, but I'm not overly optimistic about replicating this particular > case. Thanks. -- Michael --j6zkAHxOZJkiczrA Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl6QJ2QACgkQnvQgOdby QH12Rw//ZMBTExdxdgnjkU7XtjpKf7O5MrH8hUqLbH/zKv63ZbtojHj9V/sJpD1b TTURH6wm6AsgyVxP0bmSIos8R8sbqsA2puiqzMVHq/wY6V9xiS+8HAz7mTMtCOyj vNQ4n5x6ShuVk6sefQbD4vua4Y5Jq32vMg7wx8TC1ctO2JEcfAOv8W4AzKSs8Lgg 3k6wiJw37/avZCDJny2hSkmnBLr44Z3Xsjzp85bgjvMb+l3/kn3HFdyQoUCYEey4 dclfzIo5BrQd30BnoJK2EqKP71mODq6yZMMfl2KaggCXQvCa3bX1wycF1UZytYH1 7M+YlFU3AbP6+fc8WLAbaBm2JaNEL6eYYseww9DJ3pLaJyfEmkjIIBBRGBs46sTy HWaGPkceHhtk1HfJeQcHTTbsGwmRn6tMyNP/ym2HrgyZ2PkN2y61XhC3XH5HQpVW TnBgMxPpj/J7KiYNgNsQulvDcsh53ymSECIFcvaWyH4RIbCxfgA/O8sPiZxTV9gv 3L+HOnsVIswmh+XIeTuBAEYpI7JDWJp2WZOrEa8RPz/vxkot4laqe7FAr53lhhWL O/ZkWxtOFnck/LW3lAcXgnBrBhuUeuw3bHo1ttK0LwcGhL/KrrnMtWKwEOIbolNO 3CVAmTypNBEJSo3uBfYDHVKwyazDkL8uxQw3yawa1sviXBII0/s= =wjfc -----END PGP SIGNATURE----- --j6zkAHxOZJkiczrA--