Re: Pg stuck at 100% cpu, for multiple days

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, depesz(at)depesz(dot)com, pgsql-hackers mailing list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pg stuck at 100% cpu, for multiple days
Date: 2021-08-31 00:22:24
Message-ID: 1485222.1630369344@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joe Conway <mail(at)joeconway(dot)com> writes:
> It would be interesting to step through a few times to see if it is
> really stuck in that loop.

Yeah, this single data point is not enough justification to blame
dynahash.c (which is *extremely* battle-tested code, you'll recall).
I'm inclined to guess that the looping is happening a few stack levels
further up, in the logical-decoding code (which is, um, not so much).

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2021-08-31 01:16:51 Re: Pg stuck at 100% cpu, for multiple days
Previous Message Joe Conway 2021-08-31 00:15:24 Re: Pg stuck at 100% cpu, for multiple days