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

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(dot)(dot)(dot)(dot)N(at)(dot)@.......
> > 0x0010: 7f00 0001 cc40 1538 d9b9 44bb fcd1 afb7 (dot)(dot)(dot)(dot)(dot)(at)(dot)8(dot)(dot)D(dot)(dot)(dot)(dot)(dot)
> > 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