Postgres Pro
Downloads
Home   >   mailing lists

Re: FW: query pg_stat_ssl hang 100%cpu - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: FW: query pg_stat_ssl hang 100%cpu
Date
Msg-id CA+hUKGKSQEewukGjw6o2FJeN9mkO29pCzmeXHnuPms=VXtjyuA@mail.gmail.com
Whole thread Raw
In response to Re: FW: query pg_stat_ssl hang 100%cpu  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: FW: query pg_stat_ssl hang 100%cpu
List pgsql-bugs
Tree view 
On Thu, Sep 7, 2023 at 10:59 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> On Thu, Sep 7, 2023 at 10:39 PM James Pang (chaolpan)
> <chaolpan@cisco.com> wrote:
> > (gdb) p RecordCacheArray
> > $1 = (TupleDesc *) 0x7f5fac365d90
> > (gdb) p RecordIdentifierArray
> > $2 = (uint64 *) 0x0
>
> Hah, yeah that's it, and you've been extremely unlucky to hit it.
> ensure_record_cache_typmod_slot_exists() should be more careful about
> cleaning up on allocation failure, to avoid this state.

I think the lazy fix would be to re-order those allocations.  A
marginally more elegant fix would be to merge the arrays, as in the
attached.  Thoughts?
Attachment

pgsql-bugs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: BUG #18095: Unintended non-SSL connection attempt by psql cli command after a failed password authentication
Next
From: PG Bug reporting form
Date:
Subject: BUG #18096: In edge-triggered epoll and kqueue, PQconsumeInput/PQisBusy are insufficient for correct async ops.