Re: Disconnection errors

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(at)gmail(dot)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(dot)albe(at)cybertec(dot)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
> >
> >
> >
>