Postgres Pro
Downloads
Home   >   mailing lists

Thread: Disconnection errors

Disconnection errors

From
S Bob
Date:
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

Re: Disconnection errors

From
Laurenz Albe
Date:
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

Re: Disconnection errors

From
Mariane Kiesewetter
Date:
Hi
I have seen such messages when connections were dropped by the firewall after a certain time. I can’t remember the
settingbut 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
>
>
>

Re: Disconnection errors

From
MARIANE K
Date:
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
>
>
>