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
Ответ на
Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock (Peter Geoghegan)
Список
Дерево обсуждения
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 по дате отправления