Re: BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page - Mailing list pgsql-bugs

From Teodor Sigaev
Subject Re: BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page
Date
Msg-id 4655B2FE.1010807@sigaev.ru
Whole thread Raw
In response to BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page  ("Cstdenis" <cstdenis@ctgameinfo.com>)
List pgsql-bugs
> I haven't been able to reproduce it. I think its a race condition
> between some of the other processes running at the time. I'm not sure
> what else was running on it, but the error suggests an insert to me and
> there may have been a vacuum running (plus there are always plenty of
> selects running).

I don't believe in that:  INSERT/UPDATE/DELETE acquire ROW EXCLUSIVE
lock and vacuum - SHARE UPDATE EXCLUSIVE. They are conflicted with SHARE
lock mode acquired by CREATE INDEX command.

It seems to me tat we have bug in defining free space at page.

>
> It is not reasonable for me to send you an ltree dump since the talbe is
> about 2 million rows, but I'll send a small sample and describe it.
You can put dump somewhere in www and send just a link. But you say that
you can't reproduce the bug,  so it isn't needed. But I should some
digger the code.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3301: explain crashes server on simple (?) query
Next
From: Cstdenis
Date:
Subject: Re: BUG #3302: Crash on gist ltree - PANIC: failed to add item to index page