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 1ipf7M-00052J-WC for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2020 21:13:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ipf7K-0003JQ-A4 for pgsql-general@arkaria.postgresql.org; Thu, 09 Jan 2020 21:13:22 +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 1ipf7J-0003JJ-U0 for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2020 21:13:22 +0000 Received: from uucp.dinoex.sub.de ([2001:1440:5001:1::2] helo=uucp.dinoex.org) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ipf7G-0002pM-Va for pgsql-general@lists.postgresql.org; Thu, 09 Jan 2020 21:13:20 +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 009LD4t0026964 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NO); Thu, 9 Jan 2020 22: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 009LD4P0026963; Thu, 9 Jan 2020 22: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 009KsfiW087288; Thu, 9 Jan 2020 21:54:42 +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 009KrKn2087203; Thu, 9 Jan 2020 21:53:20 +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 009KrJX9087202; Thu, 9 Jan 2020 21:53:19 +0100 (CET) (envelope-from peter) Date: Thu, 9 Jan 2020 21:53:19 +0100 From: Peter To: Tom Lane Cc: pgsql-general@lists.postgresql.org Subject: Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?) Message-ID: <20200109205319.GA85142@gate.oper.dinoex.org> References: <20200109181822.GA74698@gate.oper.dinoex.org> <7042.1578595681@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7042.1578595681@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]); Thu, 09 Jan 2020 22:13:08 +0100 (CET) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Jan 09, 2020 at 01:48:01PM -0500, Tom Lane wrote: ! Peter writes: ! > with 12.1, after a couple of queries, at a random place, the clientlib ! > does produce a failed query without giving reason or error-message [1]. ! > Then when retrying, the clientlib switches off signal handling and ! > sits inactive in memory (needs kill -9). ! ! Seems like you'd better raise this with the author(s) of the "pg" ! Ruby gem. Perhaps they read this mailing list, but more likely ! they have a specific bug reporting mechanism somewhere. Tom, I don't think this has anything to do with "pg". Just checked: I get garbage and misbehaviour on the "psql" command line tool also: $ psql -h myhost flowmdev psql (12.1) GSSAPI-encrypted connection Type "help" for help. flowmdev=> select * from flows; message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle flowmdev=> select * from flows; server sent data ("D" message) without prior row description ("T" message) flowmdev=> select * from flows; message type 0x54 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle message type 0x44 arrived from server while idle id | name | ... To the contrary: $ PGGSSENCMODE="disable" psql -h myhost flowmdev psql (12.1) Type "help" for help. flowmdev=> select * from flows; id | name | ... rgds, PMc