Re: wire protocol errors on Debian (py3/psyco 2.8) - Mailing list psycopg

From Adrian Klaver
Subject Re: wire protocol errors on Debian (py3/psyco 2.8)
Date
Msg-id adad228f-4f9f-6b82-b780-d89a1901984b@aklaver.com
Whole thread Raw
In response to Re: wire protocol errors on Debian (py3/psyco 2.8)  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
Responses Re: wire protocol errors on Debian (py3/psyco 2.8)  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List psycopg
On 3/14/20 12:35 PM, Daniele Varrazzo wrote:
> 
> 

> 
> The error comes from the libpq failing to parse messages from the server 
> (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 want 
> 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 
(Tom Lane)

These errors could result in dropping data (usually leading to 
subsequent wire-protocol-violation errors) or in a “livelock” situation 
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, creating 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?


> 
> My wild guess is either faulty network or faulty memory on the machine, 
> most likely the latter.
> 
> -- Daniele


-- 
Adrian Klaver
adrian.klaver@aklaver.com



psycopg by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: wire protocol errors on Debian (py3/psyco 2.8)
Next
From: Karsten Hilbert
Date:
Subject: Re: wire protocol errors on Debian (py3/psyco 2.8)