VACUUM FULL missing chunk number 0 for toast value

[Yi Sun <yinan81@xxxxxxxxx>]

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