VACUUM FULL missing chunk number 0 for toast value

Поиск
Список
Период
Сортировка
От Yi Sun
Тема VACUUM FULL missing chunk number 0 for toast value
Дата
Msg-id CABWY_HCozA7UfD-TDS4tA5y50rpiUR+jR4iVS_qyq6X2LVya0w@mail.gmail.com
обсуждение исходный текст
Ответы Re: VACUUM FULL missing chunk number 0 for toast value
Список 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


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

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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Visibility of data from table inherits function
Следующее
От: Hasan Marzooq
Дата:
Сообщение: Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2