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 1oNbx9-0007J3-Hh for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Aug 2022 15:24:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oNbx7-0002b6-Em for pgsql-bugs@arkaria.postgresql.org; Mon, 15 Aug 2022 15:24:29 +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 1oNbx6-0002ak-GW for pgsql-bugs@lists.postgresql.org; Mon, 15 Aug 2022 15:24:29 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oNbwx-0006lg-VH for pgsql-bugs@postgresql.org; Mon, 15 Aug 2022 15:24:28 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 0AAFD5C004F; Mon, 15 Aug 2022 11:24:13 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Mon, 15 Aug 2022 11:24:13 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to:sender :subject:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1660577053; x=1660663453; bh=4 WAW+ld/0hLoAh1NmL2pK7EaxvHyMKqOsZ5abOouYqw=; b=vR1UAHy/RSUnb7W1G KrbNw9oWnuEFZH3E5yD3mRoMgzzlDsxeNTj3r4rtkOebJ37PNOKrJlzl+jcOtZAH hqAmqEK9f6YYWVCveDgmEBtSR41d3FvX/ivaIp+JS6lFaT83om+KKsy6c+TbaRg5 YM9UE5LbgakrbDI4g1bTpLDZG1QxhEFPezDjpHEcBgQ5YHtqjPpi6qRnkpO9c2wn ANqY3UQruG0g+B3dtbpu+KZgf2eKt+SBfM/jTP4ZTH/bG7tHaPKVZ15Ii5Pb/p5c 9GdSyxWStFvD3ESgcgKWXB74/ifl7hNQVfTiYay5QmG4PpO0fkV5CEslZq68gXRA pvreQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrvdehvddgkeelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepvdektdffudfftdffffehfffhjeejhffgieeuueekjeek fffgudffhfduffffueevnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhv hhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 15 Aug 2022 11:24:11 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 0E9D3372; Mon, 15 Aug 2022 17:24:37 +0200 (CEST) Date: Mon, 15 Aug 2022 17:24:37 +0200 From: Alvaro Herrera To: Daniele Varrazzo Cc: pgsql-bugs Subject: Re: Regression in pipeline mode in libpq 14.5 Message-ID: <20220815152437.sg64tinuamfukbhz@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2022-Aug-14, Daniele Varrazzo wrote: > The execute() runs an implicit BEGIN, which is also executed in > pipeline mode. Exiting the pipeline() block causes a Sync. So we > expect 3 results in the pipeline (a COMMAND_OK after BEGIN, a > TUPLES_OK after SELECT, a PIPELINE_SYNC). Hmm, it seems (judging only from comparing your two traces) that the problem stems from the newly added hack to handle CloseComplete. I'll have a look later in the week. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "No hay ausente sin culpa ni presente sin disculpa" (Prov. francés)