postgresql - Postgres log file contains: missing chunk number 0 for toast value 815441 in pg_toast_2619

Question

Below log message is available in postgres log file several thousand times. How to resolve.

missing chunk number 0 for toast value 815441 in pg_toast_2619.

pg_toast_2619 is the pg_statistic table. it (pg_statistic) contains duplicated records also. How to resolve this situation. What is the reason behind this.

Answer 1

Something went wrong with you server. Server crashed? Disk failure? Anyway you could do:

1. Stop your server and make a physical copy of your data directory to a secure place;
2. Since pg_statistic is populated by ANALYZE, just clean it DELETE FROM pg_catalog.pg_statistic; and issue an ANALYZE afterwards.

If the error persists:

1. Enable allow_system_table_mods and then restart your server: ALTER SYSTEM SET allow_system_table_mods = ON; (Postgres 9.4+)
2. Truncate pg_statistic of the database you're getting the error: TRUNCATE TABLE pg_catalog.pg_statistic;
3. Analyze entire database again: ANALYZE VERBOSE;
4. Disable allow_system_table_mods: ALTER SYSTEM RESET allow_system_table_mods;

You may need to REINDEX SYSTEM after doing this.

More info about allow_system_table_mods here.