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

On Mon, Aug 30, 2021 at 11:04:33AM -0400, Joe Conway wrote: > src/backend/utils/hash/dynahash.c:1448 is in the middle of a while loop, > which is apparently not exiting. > There is no check for interrupts in there and it is a fairly tight loop > which would explain both symptoms. > As to how it got

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

On 8/30/21 10:36 AM, hubert depesz lubaczewski Anyway - it's 12.6 on aarm64. Couple of days there was replication slot started, and now it seems to be stuck. #0 hash_seq_search (status=status@entry=0xdd90f380) at ./build/../src/backend/utils/hash/dynahash.c:1448 #1 0xc3042060 in

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

On Mon, Aug 30, 2021 at 07:57:26PM +0530, Vijaykumar Jain wrote: > related? i was kind of expecting debezium when i saw cdc and java, but > DBZ-1596 Fix open resources while initializing publication by Naros · Pull > Request #1120 · debezium/debezium (github.com) >

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

On Mon, 30 Aug 2021 at 19:15, hubert depesz lubaczewski wrote: > Hi, > We hit a problem with Pg 12.6 (I know, we should upgrade, but that will > take long time to prepare). > > > The other end of the connection was something in kubernetes, and it no > longer exists. > > related? i was kind of exp