Re: pgbench stuck with 100% cpu usage

From: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
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-29 05:36:38
Message-ID: CABOikdOajyAz6yuvu0nsDWT2gyrBCCD_WOxM3VMcZOc=efvAbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 29, 2017 at 12:22 AM, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> wrote:

>
> While running some tests, I encountered a situation where pgbench gets
>> stuck in an infinite loop, consuming 100% cpu. The setup was:
>>
>> - Start postgres server from the master branch
>> - Initialise pgbench
>> - Run pgbench -c 10 -T 100
>> - Stop postgres with -m immediate
>>
>
> That is a strange test to run, but it would be better if the behavior was
> not that one.

Well, I think it's a very legitimate test, not for testing performance, but
testing crash recovery and I use it very often. This particular test was
run to catch another bug which will be reported separately.

Thanks,
Pavan

--
Pavan Deolasee http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavan Deolasee 2017-09-29 05:39:00 Re: pgbench stuck with 100% cpu usage
Previous Message Kyotaro HORIGUCHI 2017-09-29 05:19:17 Re: Bug with pg_basebackup and 'shared' tablespace