Re: Disconnection errors

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