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 1krywc-000075-1Y for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Dec 2020 07:52:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krywa-0006UR-M4 for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Dec 2020 07:52: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 1krywa-0006UJ-Dh for pgsql-bugs@lists.postgresql.org; Wed, 23 Dec 2020 07:52:24 +0000 Received: from [66.111.4.26] (helo=out2-smtp.messagingengine.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krywT-0006Qp-Uq for pgsql-bugs@lists.postgresql.org; Wed, 23 Dec 2020 07:52:23 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 35F8D5C0143; Wed, 23 Dec 2020 02:52:07 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 23 Dec 2020 02:52:07 -0500 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=fm3; bh=Lel24vpSUb6tmY76eJkoZynTsTh oQwvrCamxqiDeEtU=; b=b2yt16JhG7THm8//q91gUr8Fi/V4FES8mvKggiMAI35 u9d8DFh3tIGmWhtBaUHo1cuVntZ2+KCUmg8HAM2Glgfbd4V/vRV5NpF728R8aZr9 WLgS/wNQlRVKRmMiMK2Ja5pJUX6PiENR61xNOEJFG3l+nSQ2sVTMc8R5a07QCe07 PptUgrrpwytmqMjIZrdUJBEOoGtM3t72X4caO1/rwXI5ZGZkg6jXXqwYrsDG1rpx J+Xg9Kv//s5EXjS7/YyBx2DHikJIjEUs4qJBYZ59I3lstHlBAHmojTD1UC1eaLPR Le5IWuj4tn82kwehW2XqtZS1YelFNOz48v9XpXnB3hg== 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=fm1; bh=Lel24v pSUb6tmY76eJkoZynTsThoQwvrCamxqiDeEtU=; b=L3G5U0xYcrzkMX+CEcLkea WRIX2FiWgL9Ih8RzqyJsCTA/kLpgyLSersMShWLNVoZanQvEtukJtVwb3+s4Jz4C IyuvJNiEX0ulOrcWiXrdQOidSHa2A72ERVpc+4NHUyjs7TOs3O5WbDaQ13KnwUKP 2QA3HDaJceh3VAw9RXsPE85+vSMPWHNdg1oUEFGP5TFn9pifQpWMX88W33tZJSym vMqO5vXvkMAnAR9wjvAW/jKUfClvHaGVBh8YAFnSZhCk3hnKc+rJcXdew26hoxNh DYDIsy8mMqBOQvQB4apIX6b/4vykjQ7qjzIJJe6H8/ABTqNPbVJbOrERMBy/K4Ug == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrvddtiedgjeeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrh hnpedvgeduuefhtdeuleettdevjeehheeiveeuieegleetgeeljeelieeuieehgeevhfen ucfkphepudduuddruddtvddrudektddrudekheenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii 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 8EBF924005E; Wed, 23 Dec 2020 02:52:05 -0500 (EST) Date: Wed, 23 Dec 2020 16:52:02 +0900 From: Michael Paquier To: Andrey Borodin Cc: Tom Lane , pgsql-bugs@lists.postgresql.org Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data Message-ID: References: <2E712143-97F7-4890-B470-4A35142ABC82@yandex-team.ru> <273957.1608400661@sss.pgh.pa.us> <9B4656B3-A404-4644-9D2C-79782F5E8E9E@yandex-team.ru> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="oXb/OhZcgj20jcrj" Content-Disposition: inline In-Reply-To: <9B4656B3-A404-4644-9D2C-79782F5E8E9E@yandex-team.ru> X-Host-Lookup-Failed: Reverse DNS lookup failed for 66.111.4.26 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --oXb/OhZcgj20jcrj Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Dec 23, 2020 at 12:23:28PM +0500, Andrey Borodin wrote: > Do I understand correctly that check-world tests on buildfarm 'make > check-prepared-txns' and the problem is somewhere in my machines? Or > something is actually broken\outdated? The buildfarm code has no trace of check-prepared-txns. And, FWIW, I see no failures at the top of REL9_6_STABLE. Do you mean that this happens only with your patch? Or do you mean that you see failures using the stable branch of upstream? I have not tested the former, but the latter works fine on my end. -- Michael --oXb/OhZcgj20jcrj Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl/i9yIACgkQnvQgOdby QH2n2w//ScU9JtPIb8m/GtwxhMw+UnjF9GkGIWX17Ghi4cviVkMh/O3cswHHmTwu FZbowc7osjCMpA8WYhMK3DMabZD8Q5mKjJIlnzY9gNie1CY7lAgBTR6iGojBbdd9 bXJGOvVffdfkS5Kq+cFZW+/Q7yJ642OpJgurf3wV3bI7DX3Tv2yc/zAKGB1KC3om arv9LXswhU820TuymaxFdUqzSZG2Fvp/G+4/G+PVld8YEeFGVj3sOhZ6eZljD+KS pmyEjAMKEHw/X0fqtB0v2Q4xioKlyGeahYgyG/KAOBaqU0wlQdur2Ju1uaMXtKGl umOiahHeVYCW6DWXooIaPKNzJBHOy+DVpLWMQgBQPps49EohWEFICSSPMF5i13Sy QVVlmd9CHM4qziI/nX3vvcBoyqGTIzHIEin31ndZNPbflaGYOPZIUNpUr7je3A3X nUOY1osb7G4Y2vlFFBCO8kFIK9YmdLsxVsZoW1Q+D+ix8lHLyl1ecHigGsW4w75Y XoFOGi1F7CzvkY92AtCktEBkMbAZyWroDBfkqYcWFlYYrduSR7cS39owvGxjhRBr XpEGUsIG9A1tkYPDYKNYv06MbI3yMAOtLoh+fGI3uEY8b0vAdtWXFhLIRXb58S8x sKpQf1D72xk5i9TGGtQgrCN7/9FCNDlhzVHFYkIquGHkN95+DjA= =AC+V -----END PGP SIGNATURE----- --oXb/OhZcgj20jcrj--