Search Postgresql Archives

Re: client waits for end of update operation and server proc is idle

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Am Sun, Apr 25, 2021 at 01:21:25PM -0400 schrieb Tom Lane:

> > 10:57:16.051326 IP 127.0.0.1.52288 > 127.0.0.1.5432: Flags [P.], seq 14280:14407, ack 120304, win 512, options [nop,nop,TS val 3424445708 ecr 3424445708], length 127
> >         0x0000:  4500 00b3 b84e 4000 4006 83f4 7f00 0001  E....N@.@.......
> >         0x0010:  7f00 0001 cc40 1538 d9b9 44bb fcd1 afb7  .....@.8..D.....
> >         0x0020:  8018 0200 fea7 0000 0101 080a cc1c e50c  ................
> >         0x0030:  cc1c e50c 5352 502d 3236 3937 363a 2072  ....SRP-26976:.r
> >         0x0040:  6573 746f 7265 6420 7374 7275 6374 206b  estored.struct.k
> >         0x0050:  6574 7465 7361 747a 2066 6f72 2073 6574  ettesatz.for.set
> >         0x0060:  6964 3a32 2c20 6465 736b 3a33 3831 3832  id:2,.desk:38182
> >         0x0070:  3038 302c 2066 656c 646e 723a 362c 206b  080,.feldnr:6,.k
> >         0x0080:  6174 6b65 793a 3136 3839 3532 3937 392c  atkey:168952979,
> >         0x0090:  206b 6574 7465 7361 747a 2e66 7265 693a  .kettesatz.frei:
> >         0x00a0:  302c 206b 6574 7465 7361 747a 2e61 6e7a  0,.kettesatz.anz
> >         0x00b0:  3235 0a                                  25.
>
> Ah.  On looking at the server code, I see there *is* some validation
> on the message type code --- but here, the first byte is 'S' which
> happens to be a legal message type, so you got past that check.
> Still, the apparent message length is then "RP-2" (0x52502d32)
> which is bigger than 1GB so I don't quite understand why you didn't
> get an "out of memory" error.

But he did, didn't he ?

> > > 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)

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux