Re: Disconnection errors - Mailing list pgsql-admin

From MARIANE K
Subject Re: Disconnection errors
Date
Msg-id CANBd27KQAfMMieR1vWQmXPk4zBn3BkOQHi1jLWKa7c85nMyvJQ@mail.gmail.com
Whole thread Raw
In response to Re: Disconnection errors  (Mariane Kiesewetter <mskiesewetter@gmail.com>)
List 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 by date:

Previous
From: Victor Sudakov
Date:
Subject: Re: wal-g (https://github.com/wal-g/wal-g) reliability
Next
From: VV
Date:
Subject: name and password for pgadmin4