| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Kamigishi Rei <iijima(dot)yun(at)koumakan(dot)jp> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
| Subject: | Re: BUG #17245: Index corruption involving deduplicated entries |
| Date: | 2021-10-29 19:20:01 |
| Message-ID: | CAH2-Wz=tFJQMQZniu0=XWEqY3Ae2kXu+RByM1QzLsefEgBOLzg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Oct 29, 2021 at 11:45 AM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
>
> On Fri, Oct 29, 2021 at 11:36 AM Kamigishi Rei <iijima(dot)yun(at)koumakan(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David M. Calascibetta | 2021-10-29 19:32:48 | FW: BUG #17258: Unexpected results in CHAR(1) data type |
| Previous Message | Kamigishi Rei | 2021-10-29 19:19:06 | Re: BUG #17245: Index corruption involving deduplicated entries |