Re: Reproducible GIST index corruption under concurrent updates

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Reproducible GIST index corruption under concurrent updates
Дата
Msg-id b9cee27d-0ce9-7708-d197-580f62e5dab7@iki.fi
обсуждение исходный текст
Ответ на Reproducible GIST index corruption under concurrent updates  (Duncan Sands <duncan.sands@deepbluecap.com>)
Ответы Re: Reproducible GIST index corruption under concurrent updates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On 20/01/2021 10:23, Duncan Sands wrote:
>> The comment change was correct, but the condition used &&. Should've been ||.
>> There is another copy of basically the same condition earlier in the function
>> that was changed correctly, but I blundered this one. Oops.
>>
>> The attached patch fixes this. I also added an assertion to the
>> gistplacetopage() function, to check that we never try to insert on a deleted
>> page. This bug could've made that happen too, although in this case the problem
>> was a concurrent split, not a deletion. I'll backpatch and push this tomorrow.
>>
>> Many thanks for the easy reproducer script, Duncan!
> 
> No problem Heikki, thanks for the quick fix.

Pushed as commit 6b4d3046f4, and backpatched down to version 12, where 
this bug was introduced. It will appear in the next minor release.

- Heikki



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Duncan Sands
Дата:
Сообщение: Re: Reproducible GIST index corruption under concurrent updates
Следующее
От:
Дата:
Сообщение: Bug Report | Using ts_headline with the <-> operator