Re: Backend with closed connection at 99% CPU

Guy Thornley <guy@esphion.com> writes:
> Postgres 7.4.1. (Yes I know, we _should_ upgrade).

Yup.

> As the subject says, it is spinning at 99% CPU. ...
> This backend has recently lost its client connection, ...
> You can even have a backtrace, how about that:

>         (gdb) bt
>         #0  0x0811cf40 in enlargeStringInfo ()
>         #1  0x081249b8 in pq_getmessage ()
>         #2  0x0817bdfe in HandleFunctionRequest ()
>         #3  0x0817bfda in HandleFunctionRequest ()
>         #4  0x0817eacc in PostgresMain ()

I'm betting this is this bug:

2004-05-11 16:07  tgl

    * src/backend/lib/stringinfo.c (REL7_4_STABLE): Add tests to
    enlargeStringInfo() to avoid possible buffer-overrun or
    infinite-loop problems if a bogus data length is passed.

Somehow the dying client injected a few bogus bytes into the
communication channel, and managed to trigger the infinite-loop
variant of this bug.

            regards, tom lane