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.92) (envelope-from ) id 1jDDj0-0000Dj-D2 for psycopg@arkaria.postgresql.org; Sat, 14 Mar 2020 20:49:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jDDiy-00058r-LO for psycopg@arkaria.postgresql.org; Sat, 14 Mar 2020 20:49:36 +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 1jDDiy-00058k-C8; Sat, 14 Mar 2020 20:49:36 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jDDiu-0000he-7X; Sat, 14 Mar 2020 20:49:35 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1584218967; bh=qVWkJ5+N4mRCk0o9CZ/knsXD5qpOle2tKoWPu9qGm70=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=csr7Sq3Kk8FnS+71Nt4f413881t6GJY2uO/S2IHknGBOc0scjqTyPxBIJPPZaTlH0 wHIdumD3AB9s8fNVEvkFvQCguCLQ1XcpyHE1RFuVb+/PwvZu6KHO4EZQGTthVG5Vfh +2LS0qI6o8nem2f8B8Goc5NGJowZKJMuwjmfV79c= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from hermes ([77.13.192.245]) by mail.gmx.com (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MuUnK-1jVR5x2RUY-00rYav; Sat, 14 Mar 2020 21:49:27 +0100 Received: from ncq by hermes with local (Exim 4.92) (envelope-from ) id 1jDDim-0004MY-SX; Sat, 14 Mar 2020 21:49:24 +0100 Date: Sat, 14 Mar 2020 21:49:24 +0100 From: Karsten Hilbert To: psycopg@lists.postgresql.org, psycopg@postgresql.org Subject: Re: wire protocol errors on Debian (py3/psyco 2.8) Message-ID: <20200314204924.GI1104@hermes.hilbert.loc> Mail-Followup-To: psycopg@lists.postgresql.org, psycopg@postgresql.org References: <20200314153421.GC1104@hermes.hilbert.loc> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) User-Agent: Mutt/1.10.1 (2018-07-13) Sender: X-Provags-ID: V03:K1:J9cD9dHwW9/jfb9ThXwJhIUUj+VhqWLBH8ctim8QtmlD5qzFOZO ijiTMkQOXvRwthfeITnNE1EIljS6/KZGPRTjCAF5ZI4jS2QDbkHTLEf8GB3+B9TUENKenZD o79PYJ8rezaWAY5/msUt4T9Vovumqm09Svp9HqM5mXJnycjmx1rPgY/ecF8RZtTuFl9klhb E1nfmIfdPTG67A2x46EsQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:S8HFv3Nd0Xw=:96nG1wO0B6t7xtdf8iuq0M b/ftk23hiIySlA8ynl9rtq2T3yfN7qLXaB39i638bz7A/Pozj9NpkDItkuogZA4ZGQcTUG2VY hXT3XXJSBz7EPVLxoltlKg6VsmK7vBW+Xp5uqYie4EMX9OzRprbgkzhQFOO038FgidvXmhohB 3F2EyeUMdUXrIG9IcFH6eaU7i7bdc/n2ys2dEMsn9x2RHsweRQJj2LHUFe+1gON7cj0NibdeC 6ZQqMc+HqSOOrbNNP0tm7Gym99uucmmivEDjC8IEuo6XuIAZSPxxpEJmXEkjvL3MgECUG0sRK NlTq5jUHIukLOybIoPPs9IoXbNOZ5823Mk5r9LJ/+Lcr1OK9BL5YUjZfdzWZdyOIjaGeQ4jMH rF0hlTm3z1nzz9YyEYymA0SLfds9aBiaVhTQef78UZ4/AX9S6tn2QcsbgXw2/adTMePZOTn0f vgpSg8KfUiAwQ7siBW/UnrNP3CdUj9pMLJc65ezU/pzU0aTQeDcPK30AaK594gzhQ0l31NXq+ RRZi+u8zP1/Up5zNSs6atDPS9TNdXQwDA/1ad/XwVAZvWFa/+am6Y+MLnbW2sRKKufGx6hg7g rJk5BHke/80UtnD/3JcyWmXa2yzi2IsHWXH9+1Fvj1lq5zkRKnxkcv/x+r6PMPXO80Lq+5ZzG CDA0YTbaY7mkPe17Hb8jK6dniRXA7c87u2FfomRe8xSeIBXFhiSkgCfNHEVsOmf+U6OxYO/52 6YdLu4wbrYLpo8YEVkiw7goHOnAWcxIBnq4qOIn78j7tvMwJ8maVci3iVh1cVc3KQxWKpwmNa SgEyL7k/OPC1nLeUc9SbuoDyMZohQEar5HmRHJpqMvbx/25YOi1uUpdXsCGSMkKNx3Sa57TsJ zHrnrmOshgJXdw7QpxFoWalPTQ6O7WbfIVACKdFQ9yX253hPZoBmjd8xplKEteEm3QKqn5yZF Jm0ovbT/MdsgI9MouJs3EbAlSeKKZqmwHd51XPQ4qTwxs7VU3RushMDFUEy4TA3XDavdgm5ga eGnW2QdX3kCAOlMsUfSu3258Tjbs8nqKWjSo9bWl9fOqDRD/7sCnF83RLk55h7vYEMZYsJ+mC haLQoDtxixj0pj0oCsuiQfi0XE/2lGxXcCO5/1yf3sarPO0Ro/0o79HbRKws4N4TXKjNYr29f 1E5Jygv9wAg04tSrV349cpMTBj4YUkMAi5+vR/RKzbaC0R6Vi2DWdRj5IlkHA0KOmd2b1tFY1 YukpPP1+abuoUCH9j List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sat, Mar 14, 2020 at 01:29:58PM -0700, Adrian Klaver wrote: > > The error comes from the libpq failing to parse messages from the serv= er > > (at a glance CommandComplete and RowDescription - see > > https://www.postgresql.org/docs/current/protocol-message-formats.html) > > which are probably just the most common ones. > > > > I doubt it's a bug with libpq 12.2 or whatever server is on the other > > side of the wire: we would have seen this error more often. If you wan= t > > to investigate in that direction you may ask core devs if there have > > been changes in that area for those versions. > > I did run across this: > > https://www.postgresql.org/docs/12/release-12-2.html > > " > > Fix bugs in handling of non-blocking I/O when using GSSAPI encryption (T= om > Lane) > > These errors could result in dropping data (usually leading to subsequen= t > wire-protocol-violation errors) or in a =E2=80=9Clivelock=E2=80=9D situa= tion where a sending > process goes to sleep although not all its data has been sent. Moreover, > libpq failed to keep separate encryption state for each connection, crea= ting > the possibility for failures in applications using multiple encrypted > database connections. > " > > Would be nice to know what actual Postgres version is and how it is > configured? As long as OP doesn't get back in touch we probably can't do much more. Many thanks for providing insights. I'll post more if more info becomes available. Thanks, Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B