| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | S Bob <sbob(at)quadratum-braccas(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Disconnection errors |
| Date: | 2021-02-05 13:19:47 |
| Message-ID: | fe8ab49e827a9e18a2ec34fadc296a3ba2ac5825.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2021-02-05 13:21:55 | Re: Partitioning existing table issue - Help needed! |
| Previous Message | John Scalia | 2021-02-05 13:12:35 | Re: Partitioning existing table issue - Help needed! |