Corrupted btree index on HEAD because of covering indexes
От
Michael Paquier
Тема
Corrupted btree index on HEAD because of covering indexes
Дата
Msg-id
20180419052436.GA16000@paquier.xyz
Список
Дерево обсуждения
Corrupted btree index on HEAD because of covering indexes Michael Paquier <michael@paquier.xyz>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Michael Paquier <michael@paquier.xyz>
Re: Corrupted btree index on HEAD because of covering indexes Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: Corrupted btree index on HEAD because of covering indexes Teodor Sigaev <teodor@sigaev.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Re: Corrupted btree index on HEAD because of covering indexes Peter Geoghegan <pg@bowt.ie>
Hi all, I was just testing the VACUUM truncation logic, and bumped into what looks like a corrupted btree index. Here is a reproducer: create table aa (a int primary key, b bool); insert into aa values (generate_series(1,1000000), false); checkpoint; update aa set b = false where a > 500000; -- Dirties a set of shared buffers delete from aa where a > 750000; -- Delete a set of rows vacuum aa; delete from aa where a > 10; vacuum aa; -- error on btree with right sibling And here is the actual failure when the second vacuum: ERROR: XX000: right sibling 4132 of block 2128 is not next child 5396 of block 412 in index "aa_pkey" LOCATION: _bt_mark_page_halfdead, nbtpage.c:1564 This works on REL_10_STABLE, so I am adding an open item. I have not investigated the exact problem yet, but bisect is showing me covering indexes as the culprit (8224de4). Thanks, -- Michael
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Teodor Sigaev
Дата: