Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iB7JH-0008IS-OL for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2019 01:02:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iB7JF-0000bz-FF for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2019 01:02:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iB7JE-0000bf-Rr for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2019 01:02:04 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iB7JC-0003iD-Ke for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2019 01:02:03 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 8E08744B; Thu, 19 Sep 2019 21:02:00 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 19 Sep 2019 21:02:01 -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=fm2; bh=UhbCNtA2XkL3Sp82+aGcR8q/ecA qDEc0zgy3nvZrvgo=; b=C+JHgXm3Ib81WYM1rCRc8dm75/t2XTXwvPfQGoT6pnD MD+RLXTd9xGZvB7rhGEFlhAqfHZKr+hAYA1RP6bLPU39wReZRCG7UfJnXTgDWe/Z 0h1ssLv1LZM8T5ax6yWN6mw23NLSq+LOFBcOCV/UCpR8ROa/3QjxyHa5bsvBq0nX tvvxQVtf+8Wo2p7D6NFZAOEvtzOrzpRaD3EVIzmMra63PHQLSOE7resLuBOoFQ13 fHhz3aVJ0vXEaQt6uDQXOGlF9O8m07GTTLJ2uCumnsXlezHcoreeX6XBU03uMxKB LaUx1KwYb6MZhNKNDwXIp7rCHfvROcjoWJGuS8Z89YQ== 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=fm3; bh=UhbCNt A2XkL3Sp82+aGcR8q/ecAqDEc0zgy3nvZrvgo=; b=ER2wxysnQaSyriJJygV1d6 HTZG4x9eZMoERcnj6aFjWRqQLkDpAB4Ni2sdUIdPcof8DlEzV8x3SrIfzGvb5Mye DBpf0HmjI8JDJlNoUGxE7NUq+AK1kKBotJ8ziSRs1OAVK6vY44Mgb097aKo9AQ3a 7OgHrBb1uKRDR2lNA5JoRV/F+WpTkGcwQwYDIfM2Q7+lPlmmKos6nJKMEH4J79xr Xqqx3q9t5b+Gv7gAOF0cl06lU0fl+bLNAS2djpbN36pt1bvoDGSh6dbpgEsLL0Fh yfP/lXfzMsbjZl/rWZ62w4Kp9geb9dWsKTrNaZvJ+sga1r9YgzzAq/K4GpAqG5fQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrvddugdegudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduuddurddutddvrddukedtrddukeehnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluh hsthgvrhfuihiivgeptd 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 9B585D6005F; Thu, 19 Sep 2019 21:01:57 -0400 (EDT) Date: Fri, 20 Sep 2019 10:01:55 +0900 From: Michael Paquier To: Kuntal Ghosh Cc: Tomas Vondra , Tom Lane , Robert Haas , Andres Freund , Thomas Munro , PostgreSQL Hackers Subject: Re: subscriptionCheck failures on nightjar Message-ID: <20190920010155.GC1844@paquier.xyz> References: <20190813080435.GL2551@paquier.xyz> <20190826132904.3ayuw36qzl2c4ktr@development> <7361.1568738373@sss.pgh.pa.us> <20190917194510.iqwyl3be62pz7l27@development> <20190918005815.GB8909@paquier.xyz> <20190918215808.yonxqgycme6pbctp@development> <20190919042305.GA21144@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="c3bfwLpm8qysLVxt" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --c3bfwLpm8qysLVxt Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Sep 19, 2019 at 05:20:15PM +0530, Kuntal Ghosh wrote: > While subscription 3 is created, it eventually reaches to a consistent > snapshot point and prints the WAL location corresponding to it. It > seems sub1/sub2 immediately fails to serialize the snapshot to the > .snap file having the same WAL location. >=20 > Is this helpful? It looks like you are pointing to something here. -- Michael --c3bfwLpm8qysLVxt Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl2EJQIACgkQnvQgOdby QH0gtQ/9HwYI1BQi5h0HH61FYu9uEHDYFE08+2smcxycQi71RG8EXy93uKE7FQp8 vI3ZvYXTlbxe1+S6vcH8CV+unEJCgIXW6gKZuK3yByUyn2ZtWtkjxhOgPE6Kg801 qPzGyTskd4qtTTH/hTumm/QELvqYjdKS3woAXkCjzip7wxq9YaLYt7LJhlIl+P9V 0/HzAavv4otKfradPrv2HggYK5Zbzp5l+AEH8o399ip2rrhbUpSdTk43j7yoE2R6 pOURhSgNb59Io6Z7m/3B+dmAbAqbwwJURqHNUvJ3Qez294v8CCUbvX0kK7kNb8kx wgZl23810tz1WII/EuuRejRXV4fdrIuszOOo7Pebl/9RRu6fLGM+j5/0fLq0P+Vo 21kfBqNQGsdzmc80BpVHAVemKaHVxt5dhxxT74vZQRrVXMIJBgXjSS4H9DUtGUDr XL7Z3+xVNf2CI5A5L89futnQK8GxxNJzA1Jz17K3t7RQxxYiKsZ+13Lzjhqm3kLV PWvsHa7myEypV4tRzuwUGLr+TrS5S0vpX4UvyA6AHafOoCTipf/Ts0PttpoMNFzF yUoO/thsFxfd8ICKPsmxZfMMfzhoXVpyBqEJld4pgBu9rRuHH1J6n/xYswgYQsYF JApsJXbgEnrxCiBE2SOzcJ/9Jthlqri6xZRAOJJPM6a/Ffq/U68= =oi6R -----END PGP SIGNATURE----- --c3bfwLpm8qysLVxt--