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-07T09:31:00Z
Lists: pgsql-bugs, pgsql-performance 
> #0  ensure_record_cache_typmod_slot_exists (typmod=0) at typcache.c:1714

Are you able to print out the value of global variable
RecordCacheArrayLen?  I wonder if this loop in
ensure_record_cache_typmod_slot_exists() is not terminating:

        int32       newlen = RecordCacheArrayLen * 2;

        while (typmod >= newlen)
            newlen *= 2;

Commits

  1. Fix exception safety bug in typcache.c.