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 1iqig9-0000E2-4O for pgsql-hackers@arkaria.postgresql.org; Sun, 12 Jan 2020 19:13:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iqig8-0005qi-0A for pgsql-hackers@arkaria.postgresql.org; Sun, 12 Jan 2020 19:13:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iqig7-0005qb-NQ for pgsql-hackers@lists.postgresql.org; Sun, 12 Jan 2020 19:13:39 +0000 Received: from uucp.dinoex.org ([2a0b:f840::12]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iqig5-00035Q-JM for pgsql-hackers@lists.postgresql.org; Sun, 12 Jan 2020 19:13:39 +0000 Received: from uucp.dinoex.sub.de (uucp.dinoex.org [185.220.148.12]) by uucp.dinoex.org (8.16.0.41/8.16.0.41) with ESMTPS id 00CJD4TL022349 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NO); Sun, 12 Jan 2020 20:13:05 +0100 (CET) (envelope-from pmc@citylink.dinoex.sub.org) X-Authentication-Warning: uucp.dinoex.sub.de: Host uucp.dinoex.org [185.220.148.12] claimed to be uucp.dinoex.sub.de Received: from citylink.dinoex.sub.org (uucp@localhost) by uucp.dinoex.sub.de (8.16.0.41/8.16.0.41/Submit) with UUCP id 00CJD43t022348; Sun, 12 Jan 2020 20:13:04 +0100 (CET) (envelope-from pmc@citylink.dinoex.sub.org) Received: from gate.oper.dinoex.org (gate-e [192.168.98.2]) by citylink.dinoex.sub.de (8.15.2/8.15.2) with ESMTP id 00CIaq0s042393; Sun, 12 Jan 2020 19:36:52 +0100 (CET) (envelope-from peter@gate.oper.dinoex.org) Received: from gate.oper.dinoex.org (gate-e [192.168.98.2]) by gate.oper.dinoex.org (8.15.2/8.15.2) with ESMTP id 00CIaX13042386; Sun, 12 Jan 2020 19:36:34 +0100 (CET) (envelope-from peter@gate.oper.dinoex.org) Received: (from peter@localhost) by gate.oper.dinoex.org (8.15.2/8.15.2/Submit) id 00CIaXRl042385; Sun, 12 Jan 2020 19:36:33 +0100 (CET) (envelope-from peter) Date: Sun, 12 Jan 2020 19:36:33 +0100 From: Peter To: Tom Lane Cc: pgsql-hackers@lists.postgresql.org, Stephen Frost Subject: Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) Message-ID: <20200112183633.GA93629@gate.oper.dinoex.org> References: <20200109181822.GA74698@gate.oper.dinoex.org> <7042.1578595681@sss.pgh.pa.us> <20200109205319.GA85142@gate.oper.dinoex.org> <15232.1578605504@sss.pgh.pa.us> <20200110022342.GA92515@gate.oper.dinoex.org> <12348.1578679149@sss.pgh.pa.us> <20200110210337.GA9580@gate.oper.dinoex.org> <26433.1578714710@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <26433.1578714710@sss.pgh.pa.us> User-Agent: Mutt/1.12.2 (2019-09-21) X-Milter: Spamilter (Reciever: uucp.dinoex.sub.de; Sender-ip: 185.220.148.12; Sender-helo: uucp.dinoex.sub.de;) X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.6.2 (uucp.dinoex.org [185.220.148.12]); Sun, 12 Jan 2020 20:13:08 +0100 (CET) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Jan 10, 2020 at 10:51:50PM -0500, Tom Lane wrote: ! Here's a draft patch that cleans up all the logic errors I could find. Okiee, thank You! Let's see (was a bit busy yesterday trying to upgrade pgadmin3 - difficult matter), now lets sort this out: With the first patch applied (as from Friday - applied only on the client side), the application did appear to work well. But then, when engaging bandwidth-limiting to some modem-speed, it did not work: psql would receive all (or most of) the data from a SELECT, but then somehow not recognize the end of it and sit there and wait for whatever: > flowmdev=> select * from flows; > ^CCancel request sent > ^CCancel request sent Now with the new patches 0001+0003 applied, on both server & client, all now running 12.1 release, on a first run I did not perceive a malfunction, bandwidth limited or not. I'll leave them applied, but this here will not experience serious loads; You'll need somebody else to test for that... rgds, PMc