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

Поиск
Список
Период
Сортировка
От Matthias Apitz
Тема Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPAREsid_sisisinst FROM :select_anw;'
Дата
Msg-id 20200512054934.GF5413@sh4-5.1blu.de
обсуждение исходный текст
Ответ на Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
El día Montag, Mai 11, 2020 a las 02:41:29 -0400, Tom Lane escribió:

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



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Is there a significant difference in Memory settings between 9.5 and 12
Следующее
От: Tory M Blue
Дата:
Сообщение: Re: Is there a significant difference in Memory settings between 9.5and 12