Обсуждение: Unexpected chunk size when doing dump
Good day!
I have an error, when doing database dump:
psql -U postgres -p 56432 postgres > postgres.sql
pg_dump: [archiver (db)] query failed: ERROR: unexpected chunk size 384 (expected 389) in final chunk 1 for toast value 11589 in pg_toast_2619
pg_dump: [archiver (db)] query was: SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid
Postgresql version is 9.0. There was not any problems with hard drives. The same error I get, when I am trying to dump db at slave server (replic).
Reindex doesn't help me :(
What can I do with this error?
Thank you!
--
Vasiliy I Ozerov
Vasiliy I Ozerov <vozerov@2reallife.com> writes: > I have an error, when doing database dump: > pg_dump: [archiver (db)] query failed: ERROR: unexpected chunk size 384 (expected 389) in final chunk 1 for toast value11589 in pg_toast_2619 That looks like a data corruption problem :-(. You might want to check into whether your disks/filesystems are properly configured to honor fsync. Assuming this is the only problem, you're in luck as far as recovery goes, because pg_toast_2619 is the toast table for pg_statistic, which means there's no irreplaceable data in there. I'd suggest truncating pg_statistic (as superuser) and then doing a database-wide ANALYZE to rebuild the content. regards, tom lane