pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDisconnection errors
4+ messages / 4 participants
[nested] [flat]
* Disconnection errors
@ 2021-02-05 00:12 S Bob <sbob@quadratum-braccas.com>
0 siblings, 1 reply; 4+ messages in thread
From: S Bob @ 2021-02-05 00:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
All;
I have a client running PostgreSQL v10
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?
Thanks in advance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Disconnection errors
@ 2021-02-05 13:19 Laurenz Albe <laurenz.albe@cybertec.at>
parent: S Bob <sbob@quadratum-braccas.com>
0 siblings, 1 reply; 4+ messages in thread
From: Laurenz Albe @ 2021-02-05 13:19 UTC (permalink / raw)
To: S Bob <sbob@quadratum-braccas.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Disconnection errors
@ 2021-02-07 21:36 Mariane Kiesewetter <mskiesewetter@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 4+ messages in thread
From: Mariane Kiesewetter @ 2021-02-07 21:36 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: S Bob <sbob@quadratum-braccas.com>; pgsql-admin@lists.postgresql.org
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
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Disconnection errors
@ 2021-02-08 12:21 MARIANE K <mskiesewetter@gmail.com>
parent: Mariane Kiesewetter <mskiesewetter@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: MARIANE K @ 2021-02-08 12:21 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: S Bob <sbob@quadratum-braccas.com>; pgsql-admin@lists.postgresql.org
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
> >
> >
> >
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-02-08 12:21 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-02-05 00:12 Disconnection errors S Bob <sbob@quadratum-braccas.com>
2021-02-05 13:19 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-02-07 21:36 ` Mariane Kiesewetter <mskiesewetter@gmail.com>
2021-02-08 12:21 ` MARIANE K <mskiesewetter@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox