Re: pgbench stuck with 100% cpu usage

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: pgbench stuck with 100% cpu usage
Date: 2017-09-28 19:33:18
Message-ID: alpine.DEB.2.20.1709282114330.12902@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

>> The commit that introduced this code is 12788ae49e1933f463bc. So I amn
>> copying Heikki.
> AFAICR the commit was mostly a heavy restructuring of previous unmaintainable
> spaghetti code. I'm not sure the problem was not there before under one form
> or another.
> I agree that it should error out & stop the client in this case at least.

Here is a probable "fix", which does was the comment said should be done.

I could not trigger an infinite loop with various kill -9 and other quick
stops. Could you try it on your side?


Attachment Content-Type Size
pgbench-send-fail-1.patch text/x-diff 627 bytes

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Jesper Pedersen 2017-09-28 19:40:35 initdb w/ restart
Previous Message Robert Haas 2017-09-28 19:10:40 Re: Surjective functional indexes