Re: BUG #17245: Index corruption involving deduplicated entries

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: BUG #17245: Index corruption involving deduplicated entries
Дата
Msg-id CAH2-Wz=tFJQMQZniu0=XWEqY3Ae2kXu+RByM1QzLsefEgBOLzg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17245: Index corruption involving deduplicated entries  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: BUG #17245: Index corruption involving deduplicated entries  (Kamigishi Rei <iijima.yun@koumakan.jp>)
Список pgsql-bugs
On Fri, Oct 29, 2021 at 11:45 AM Peter Geoghegan <pg@bowt.ie> wrote:
>
> On Fri, Oct 29, 2021 at 11:36 AM Kamigishi Rei <iijima.yun@koumakan.jp> wrote:
> > The newly manifested issue is caught by pg_amcheck:
> >
> > btree index "azurlane_wiki.mediawiki.page_main_title":
> >      ERROR:  item order invariant violated for index "page_main_title"
> >      DETAIL:  Lower index tid=(17,157) (points to heap tid=(540,5))
> > higher index tid=(17,158) (points to heap tid=(540,5)) page lsn=2/A019DD78.

> I'm not surprised to see that it's the page table, once again. It's
> not particularly big, right? Are there other tables that are much
> larger?

BTW, can you look for autovacuum log output for the "page" table from
the logs? Then share it with the list, or at least share it with me
privately?

Thanks
-- 
Peter Geoghegan



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

Предыдущее
От: Kamigishi Rei
Дата:
Сообщение: Re: BUG #17245: Index corruption involving deduplicated entries
Следующее
От: "David M. Calascibetta"
Дата:
Сообщение: FW: BUG #17258: Unexpected results in CHAR(1) data type