Обсуждение: 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