Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

> Matthias Apitz <guru@xxxxxxxxxxx> 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@xxxxxxxxxxx, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux