Home Postgres log file contains: missing chunk number 0 for toast value 815441 in pg_toast_2619
Reply: 1

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

Raghavendra
1#
Raghavendra Published in 2017-11-28 14:12:01Z

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.

Michel Milezzi
2#
Michel Milezzi Reply to 2017-12-07 10:12:26Z

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.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.383131 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO