> 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.
In response to
pgsql-bugs by date
|Next:||From: Leszek Trenkner||Date: 2007-05-24 17:06:02|
|Subject: Re: BUG #3301: explain crashes server on simple (?) query|
|Previous:||From: Tom Lane||Date: 2007-05-24 15:27:49|
|Subject: Re: BUG #3301: explain crashes server on simple (?) query |