Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'

El día Montag, Mai 11, 2020 a las 02:41:29 -0400, Tom Lane escribió:

> Matthias Apitz <guru(at)unixarea(dot)de> writes:
> > Below is the exchange. The visible strings are: 'sisis' (the PG user),
> > 'sisis123' (its password in PG, a dummy password used for testing) and
> > 'srap32dxr1' the hostname. The server is terminating the connection with
> > a F-pkg:
>
> [ squint... ] That looks nothing like a Postgres-protocol exchange
> to me. If it weren't for the runs of zeroes, I'd wonder if the
> connection had SSL encryption turned on. Perhaps you captured the
> wrong session?

It turned out, that the messages:

2020-05-12 05:33:06.828 CEST [6271] LOG: invalid length 33554940 of startup packet
2020-05-12 05:33:08.305 CEST [6291] LOG: invalid length 33554940 of startup packet
2020-05-12 05:34:07.495 CEST [6596] LOG: invalid length 33554940 of startup packet
2020-05-12 05:34:09.710 CEST [6927] LOG: invalid length 33554940 of startup packet

have been caused by a misconfiguration of the component in question: the
application used the Sybase JDBC driver to talk to the PostgreSQL server
:-(

This part of the thread is hereby solved.

Remaining is still:

2020-04-30 15:14:03.367 CEST [3843] LOG: bogus received message length: 1650422894
2020-04-30 15:57:48.926 CEST [10380] LOG: bogus received message length: 1650422894
2020-04-30 15:58:31.851 CEST [10380] LOG: incomplete message from client
2020-04-30 15:58:53.578 CEST [10439] LOG: bogus received message length: 1650422894
2020-04-30 16:00:13.500 CEST [10439] LOG: incomplete message from client

matthias

--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub