Re: VACUUM FULL missing chunk number 0 for toast value

2022-01-03 Thread Tom Lane
Yi Sun writes: > 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, Hmm, "SELECT *" doesn't throw any error? That suggests that the missing-toast-data pro

VACUUM FULL missing chunk number 0 for toast value

2022-01-03 Thread Yi Sun
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://newbie