Hi, I get the above error while selecting data from a table. i have reindexed the table and possibly toast table but it does not seems to help. result of vacuum full is also attached. can anyone please help. even pg_dump is not able to dump the table. pg_dump: ERROR: missing chunk number 0 for toast value 697890392 pg_dump: SQL command to dump the contents of table "bad_emails" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 697890392 regds mallah. tradein_clients=# VACUUM full verbose ANALYZE email_handling.bad_emails; INFO: vacuuming "email_handling.bad_emails" INFO: "bad_emails": found 0 removable, 253598 nonremovable row versions in 15920 pages DETAIL: 0 dead row versions cannot be removed yet. Nonremovable row versions range from 91 to 2036 bytes long. There were 16060 unused item pointers. Total free space (including removable row versions) is 5180436 bytes. 0 pages are or will become empty, including 0 at the end of the table. 7059 pages containing 4848956 free bytes are potential move destinations. CPU 0.23s/0.08u sec elapsed 0.93 sec. INFO: index "bad_emails_code" now contains 253598 row versions in 558 pages DETAIL: 0 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.01s/0.06u sec elapsed 0.08 sec. INFO: index "bad_emails_code_pending" now contains 177762 row versions in 588 pages DETAIL: 0 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.00s/0.05u sec elapsed 0.06 sec. INFO: index "bad_emails_date_id" now contains 253598 row versions in 558 pages DETAIL: 0 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.01s/0.06u sec elapsed 0.08 sec. INFO: index "bad_emails_email_key" now contains 253598 row versions in 558 pages DETAIL: 0 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.01s/0.09u sec elapsed 0.11 sec. INFO: index "bad_emails_pkey" now contains 253598 row versions in 558 pages DETAIL: 0 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.01s/0.06u sec elapsed 0.10 sec. INFO: "bad_emails": moved 24 row versions, truncated 15920 to 15915 pages DETAIL: CPU 0.48s/0.31u sec elapsed 22.59 sec. INFO: index "bad_emails_code" now contains 253598 row versions in 558 pages DETAIL: 24 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.00s/0.01u sec elapsed 0.09 sec. INFO: index "bad_emails_code_pending" now contains 177762 row versions in 588 pages DETAIL: 10 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.00s/0.01u sec elapsed 0.02 sec. INFO: index "bad_emails_date_id" now contains 253598 row versions in 558 pages DETAIL: 24 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.00s/0.01u sec elapsed 0.07 sec. INFO: index "bad_emails_email_key" now contains 253598 row versions in 558 pages DETAIL: 24 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.01s/0.01u sec elapsed 0.04 sec. INFO: index "bad_emails_pkey" now contains 253598 row versions in 558 pages DETAIL: 24 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.01s/0.00u sec elapsed 0.11 sec. INFO: vacuuming "pg_toast.pg_toast_555824297" INFO: "pg_toast_555824297": found 0 removable, 901381 nonremovable row versions in 213818 pages DETAIL: 0 dead row versions cannot be removed yet. Nonremovable row versions range from 41 to 2034 bytes long. There were 4574 unused item pointers. Total free space (including removable row versions) is 67493772 bytes. 0 pages are or will become empty, including 0 at the end of the table. 71284 pages containing 65771412 free bytes are potential move destinations. CPU 4.49s/1.28u sec elapsed 172.29 sec. INFO: index "pg_toast_555824297_index" now contains 901381 row versions in 2474 pages DETAIL: 0 index row versions were removed. 0 index pages have been deleted, 0 are currently reusable. CPU 0.06s/0.20u sec elapsed 1.53 sec. INFO: "pg_toast_555824297": moved 0 row versions, truncated 213818 to 213818 pages DETAIL: CPU 0.44s/0.24u sec elapsed 11.25 sec. INFO: analyzing "email_handling.bad_emails" INFO: "bad_emails": scanned 3000 of 15915 pages, containing 47417 live rows and 1 dead rows; 3000 rows in sample, 251547 estimated total rows VACUUM
