From: | Yi Sun <yinan81(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | VACUUM FULL missing chunk number 0 for toast value |
Date: | 2022-01-03 09:28:49 |
Message-ID: | CABWY_HCozA7UfD-TDS4tA5y50rpiUR+jR4iVS_qyq6X2LVya0w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
OS: CentOS 7.6
PG: 11.11
Once we tried to vacuum full a table, got the error msg "ERROR: missing
chunk number 0 for toast value", there is a doc as below for the select
issue, but for our case select is no issue,
what's the reason caused and how to fix this please? Thanks
https://newbiedba.wordpress.com/2015/07/07/postgresql-missing-chunk-0-for-toast-value-in-pg_toast/
1. vacuum full output:
VACUUM FULL VERBOSE ANALYZE application.notes;
INFO: vacuuming "application.notes"
ERROR: missing chunk number 0 for toast value 183500290 in pg_toast_16977
2. explain select output:
explain select * from application.notes;
QUERY PLAN
------------------------------------------------------------------
Seq Scan on notes (cost=0.00..430924.43 rows=412443 width=767)
Thanks and regards
Sun Yi
From | Date | Subject | |
---|---|---|---|
Next Message | Hasan Marzooq | 2022-01-03 14:58:17 | Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 |
Previous Message | Francisco Olarte | 2022-01-03 08:04:22 | Re: Visibility of data from table inherits function |