Re: [HACKERS] pgbench stuck with 100% cpu usage - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: [HACKERS] pgbench stuck with 100% cpu usage
Date
Msg-id CABOikdOajyAz6yuvu0nsDWT2gyrBCCD_WOxM3VMcZOc=efvAbA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] pgbench stuck with 100% cpu usage  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: [HACKERS] pgbench stuck with 100% cpu usage
Re: [HACKERS] pgbench stuck with 100% cpu usage
List pgsql-hackers


On Fri, Sep 29, 2017 at 12:22 AM, Fabien COELHO <coelho@cri.ensmp.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

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] Bug with pg_basebackup and 'shared' tablespace
Next
From: Pavan Deolasee
Date:
Subject: Re: [HACKERS] pgbench stuck with 100% cpu usage