Re: Disconnection errors

Поиск
Список
Период
Сортировка
От MARIANE K
Тема Re: Disconnection errors
Дата
Msg-id CANBd27KQAfMMieR1vWQmXPk4zBn3BkOQHi1jLWKa7c85nMyvJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Disconnection errors  (Mariane Kiesewetter <mskiesewetter@gmail.com>)
Список pgsql-admin
Hi,
I checked my notes and it was the tcp_keepalive_time setting on RHEL6.
Don't know on which OS you're running.
Check this setting on you OS and ask the network team to check the setting on the FW, maybe there is a mismatch in values.

Regards,
Mariane 

Op zo 7 feb. 2021 om 22:36 schreef Mariane Kiesewetter <mskiesewetter@gmail.com>:
Hi
I have seen such messages when connections were dropped by the firewall after a certain time. I can’t remember the setting but will check if I can find it tomorrow if you still need the info.

Regards
Mariane

> On 5 Feb 2021, at 14:19, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> On Thu, 2021-02-04 at 17:12 -0700, S Bob wrote:
>> I see lots of errors like this in the log:
>>
>> 2021-02-04 23:58:50.135 UTC [32591] ERROR:  canceling statement due to user request
>> 2021-02-04 23:58:50.135 UTC [32591] STATEMENT:
>> 2021-02-04 23:58:50.135 UTC [32591] LOG:  could not send data to client: Broken pipe
>> 2021-02-04 23:58:50.135 UTC [32591] FATAL:  connection to client lost
>>
>> Is this due to the end user or app disconnecting? Are there other areas
>> / details I should be looking at to debug?
>
> That looks like the client sent a cancel request and then terminated
> without closing the database connection.
>
> What seems weird is the empty STATEMENT.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
>

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

Предыдущее
От: Victor Sudakov
Дата:
Сообщение: Re: wal-g (https://github.com/wal-g/wal-g) reliability
Следующее
От: VV
Дата:
Сообщение: name and password for pgadmin4