| From: | Kamigishi Rei <iijima(dot)yun(at)koumakan(dot)jp> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| 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:19:06 |
| Message-ID: | 2c2c70e7-359c-6923-85e8-714d27ec3534@koumakan.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 29.10.2021 21:45, Peter Geoghegan wrote:
>> 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?
This table is 15 MB in size and it contains wiki page titles along with
their namespace IDs and such. The largest table is mediawiki.text, which
is 807 MB and holds article text. Here are some of the largest tables:
log_search | 11 MB
imagelinks | 11 MB
revision_comment_temp | 13 MB
page | 15 MB
content | 15 MB
slots | 19 MB
watchlist | 24 MB
revision_actor_temp | 25 MB
image | 33 MB
revision | 37 MB
logging | 39 MB
pagelinks | 56 MB
text | 807 MB
--
K. R.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2021-10-29 19:20:01 | Re: BUG #17245: Index corruption involving deduplicated entries |
| Previous Message | Peter Geoghegan | 2021-10-29 19:08:19 | Re: BUG #17245: Index corruption involving deduplicated entries |