ERROR: unexpected chunk number 452 (expected 0) for toast value 94674063 in pg_toast_56980977

From: Naveen Kumar <naveenchowdaryon(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: ERROR: unexpected chunk number 452 (expected 0) for toast value 94674063 in pg_toast_56980977
Date: 2018-07-18 15:45:52
Message-ID: CADk76joUrW0c3nBWbuHUbmEZbTUBOuwLAE65gRDat0yBQ2=xHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-07-18 16:01:49 Re: ERROR: unexpected chunk number 452 (expected 0) for toast value 94674063 in pg_toast_56980977
Previous Message Rui DeSousa 2018-07-18 15:30:51 Re: [Admin] Reclaim Space from 4 TB Database