Horton

Re: FW: query pg_stat_ssl hang 100%cpu

Thomas Munro <thomas.munro@gmail.com>

View thread View on postgr.es
From: Thomas Munro <thomas.munro@gmail.com>
To: "James Pang (chaolpan)" <chaolpan@cisco.com>
Cc: Michael Paquier <michael@paquier.xyz>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2023-09-07T10:36:07Z
Lists: pgsql-bugs, pgsql-performance 
On Thu, Sep 7, 2023 at 10:31 PM James Pang (chaolpan)
<chaolpan@cisco.com> wrote:
>    Yes, checked the server history logs, we found when the backend starting hang there, operating system has out of memory that may lead to the allocation of RecordIdentierArray failed.

Can you please print out RecordCacheArray and RecordIdentifierArray?
For that theory, the first one must be non-NULL and the second one
NULL.  That would lead to the infinite loop, I think.

Commits

  1. Fix exception safety bug in typcache.c.