| From: | Matthias Apitz <guru(at)unixarea(dot)de> |
|---|---|
| To: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: client waits for end of update operation and server proc is idle |
| Date: | 2021-04-25 21:38:29 |
| Message-ID: | YIXhVUsZP4UaJopA@c720-r368166.fritz.box |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El día domingo, abril 25, 2021 a las 08:05:21p. m. +0200, Karsten Hilbert escribió:
> > > > The serverlog has around this time (sorry for German):
> > > >
> > > > 2021-04-23 05:55:23.591 CEST [2317] LOG: unvollständige Message vom Client
>
> "incomplete message from client"
>
> > > > 2021-04-23 05:55:23.593 CEST [2317] FEHLER: Speicher aufgebraucht
>
> "memory exhausted"
>
> > > > 2021-04-23 05:55:23.593 CEST [2317] DETAIL: Kann Zeichenkettenpuffer mit 0 Bytes nicht um 1380986158 Bytes vergrößern.
>
> "cannot extend 0-byte string buffer by 1380986158 bytes"
>
> > > > 2021-04-23 05:55:23.593 CEST [2317] LOG: konnte Daten nicht an den Client senden: Datenübergabe unterbrochen (broken pipe)
>
These messages at 05:55:xx are caused by our automatic deployment of the
software every day which starts at 05:55:00 by cron and short after installing all
software all servers (the PostgreSQL clients) get stopped (i.e. killed)
and restarted. The hung appears a few minutes later at 05:57:xx.
matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias Apitz | 2021-04-26 05:38:40 | Re: client waits for end of update operation and server proc is idle |
| Previous Message | Robert Treat | 2021-04-25 19:32:33 | Re: impact of version upgrade on fts |