Postgres Pro
Downloads
Home   >   mailing lists

ERROR: unexpected chunk number 452 (expected 0) for toast value94674063 in pg_toast_56980977 - Mailing list pgsql-admin

From Naveen Kumar
Subject ERROR: unexpected chunk number 452 (expected 0) for toast value94674063 in pg_toast_56980977
Date
Msg-id CADk76joUrW0c3nBWbuHUbmEZbTUBOuwLAE65gRDat0yBQ2=xHA@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: unexpected chunk number 452 (expected 0) for toast value94674063 in pg_toast_56980977  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: ERROR: unexpected chunk number 452 (expected 0) for toast value94674063 in pg_toast_56980977  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-admin
Tree view
Hello Experts,

What could be the reason for bellow errors. Can one help me to fix this?

PostgreSQL Database: [~rptdb~] Data Backup Failed with PostgreSQL Error: [~pg_dump: Dumping the contents of table "document" failed: PQgetResult() failed.pg_dump: Error message from server: ERROR: unexpected chunk number 452 (expected 0) for toast value 94674063 in pg_toast_56980977pg_dump: The command was: COPY reports_extended.document (document_id, access_key, created_date, document_name, document_size, document_status, document_type, encryption_type, external_system_storage_id, external_system_storage_url, last_updated_date, md5_hash, source_system_name, storage_type, created_by, customer_org_id, content_type, tags, file, ownedby) TO stdout;~].

Thanks & Regards,

Naveen Kumar .M,
Sr. PostgreSQL Database Administrator,
Mobile: 7755929449.

My attitude will always be based on how you treat me. 

pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: [Admin] Reclaim Space from 4 TB Database
Next
From: Shreeyansh Dba
Date:
Subject: Re: ERROR: unexpected chunk number 452 (expected 0) for toast value94674063 in pg_toast_56980977