Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock
Дата
Msg-id
20181204170104.kh3rnocd7tz7ntpz@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock chenhj <chjischj@163.com>
Re:Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock chenhj <chjischj@163.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Peter Geoghegan <pg@bowt.ie>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Peter Geoghegan <pg@bowt.ie>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Peter Geoghegan <pg@bowt.ie>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Peter Geoghegan <pg@bowt.ie>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andres Freund <andres@anarazel.de>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Peter Geoghegan <pg@bowt.ie>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andrey Borodin <x4mmm@yandex-team.ru>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andrey Borodin <x4mmm@yandex-team.ru>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andrey Borodin <x4mmm@yandex-team.ru>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andrey Borodin <x4mmm@yandex-team.ru>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andrey Borodin <x4mmm@yandex-team.ru>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andrey Borodin <x4mmm@yandex-team.ru>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Bruce Momjian <bruce@momjian.us>
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock Tom Lane <tgl@sss.pgh.pa.us>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andrey Borodin <x4mmm@yandex-team.ru>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Andres Freund <andres@anarazel.de>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Simon Riggs <simon@2ndquadrant.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Simon Riggs <simon@2ndquadrant.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Bruce Momjian <bruce@momjian.us>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Alexander Korotkov <aekorotkov@gmail.com>
Re:Re: Connections hang indefinitely while taking a gin index'sLWLock buffer_content lock chenhj <chjischj@163.com>
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock Peter Geoghegan <pg@bowt.ie>
Hi,

On 2018-11-10 17:42:16 -0800, Peter Geoghegan wrote:
> On Wed, Nov 7, 2018 at 5:46 PM Peter Geoghegan  wrote:
> > Teodor: Do you think that the issue is fixable? It looks like there
> > are serious issues with the design of 218f51584d5 to me. I don't think
> > the general "there can't be any inserters at this subtree" thing works
> > given that we have to couple buffer locks when moving right for other
> > reasons. We call ginStepRight() within ginFinishSplit(), for reasons
> > that date back to bug fix commit ac4ab97e from 2013 -- that detail is
> > probably important, because it seems to be what breaks the subtree
> > design (we don't delete in two phases or anything in GIN).
> 
> Ping?
> 
> This is a thorny problem, and I'd like to get your input soon. I
> suspect that reverting 218f51584d5 may be the ultimate outcome, even
> though it's a v10 feature.

Teodor, any chance for a response here?  It's not OK to commit something
and then just not respond to bug-reports, especially when they're well
diagnose and clearly point towards issues in a commit of yours.

Alexander, CCing you, perhaps you could point the thread out to Teodor?

Greetings,

Andres Freund

В списке pgsql-hackers по дате отправления
От: Stephen Frost
Дата:
Сообщение: Re: Minor typo
От: Pavel Stehule
Дата:
FAQ