Re: [HACKERS] pgbench stuck with 100% cpu usage

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: [HACKERS] pgbench stuck with 100% cpu usage
Дата
Msg-id
alpine.DEB.2.20.1709282114330.12902@lancre
Ответ на
Список
Дерево обсуждения
[HACKERS] pgbench stuck with 100% cpu usage Pavan Deolasee <pavan.deolasee@gmail.com>
Re: [HACKERS] pgbench stuck with 100% cpu usage Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench stuck with 100% cpu usage Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench stuck with 100% cpu usage Pavan Deolasee <pavan.deolasee@gmail.com>
Re: [HACKERS] pgbench stuck with 100% cpu usage Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pgbench stuck with 100% cpu usage Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench stuck with 100% cpu usage Pavan Deolasee <pavan.deolasee@gmail.com>
Re: [HACKERS] pgbench stuck with 100% cpu usage Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench stuck with 100% cpu usage Peter Geoghegan <pg@bowt.ie>

>> 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?

-- 
Fabien.
-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Jesper Pedersen
Дата:
Сообщение: [HACKERS] initdb w/ restart
FAQ