Re: Disconnection errors - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Disconnection errors
Date
Msg-id fe8ab49e827a9e18a2ec34fadc296a3ba2ac5825.camel@cybertec.at
Whole thread Raw
In response to Disconnection errors  (S Bob <sbob@quadratum-braccas.com>)
Responses Re: Disconnection errors  (Mariane Kiesewetter <mskiesewetter@gmail.com>)
List pgsql-admin
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: John Scalia
Date:
Subject: Re: Partitioning existing table issue - Help needed!
Next
From: Magnus Hagander
Date:
Subject: Re: Partitioning existing table issue - Help needed!