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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
Дата
Msg-id 17437.1587995934@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPAREsid_sisisinst FROM :select_anw;'  (Matthias Apitz <guru@unixarea.de>)
Список pgsql-general
Matthias Apitz <guru@unixarea.de> writes:
> As the client seems to be waiting on the server and the server on the
> client... could it have been caused by this in /etc/hosts (what our IT
> department configured):

Doubt it.  Your connection evidently got through (at least) the
authentication exchange, so basic data transmission seems to be
working.  I speculate that there's something data-dependent about
the command that's failing.

As an example, it would not be terribly surprising to get a behavior
like this if there were something deciding to do an LF -> CRLF or
similar transformation on the data stream.  The substitution might
accidentally not trigger during authentication, only to break some
actual query a bit later.  But there really shouldn't be anything
making such changes in our data stream.

Still, looking at recent network-level configuration changes wouldn't
be a bad idea.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'
Следующее
От: Mahendra Singh Thalor
Дата:
Сообщение: Re: How to debug "background worker "parallel worker" (PID 32152) wasterminated by signal 11: Segmentation fault"