Hi Corruption in Postgres

From: Pär Mattsson <par(dot)x(dot)mattsson(at)gmail(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Hi Corruption in Postgres
Date: 2024-11-07 18:06:58
Message-ID: AM6PR03MB55589D8CDAA42888E971C1D7A25C2@AM6PR03MB5558.eurprd03.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Har någon typ av korruptionsproblematik sen 1/10 på lfv produktion :

pg_dump: error: Dumping the contents of table "aim_notam_originalpart" failed: PQgetResult() failed.
pg_dump: error: Error message from server: ERROR: unexpected chunk size 1408 (expected 1661) in chunk 0 of 1 for toast value 18918695 in pg_toast_18194
pg_dump: error: The command was: COPY aim.aim_notam_originalpart (notam_id, part_num, created_at, e_details, canonical_filing_dtg, canonical_orig_addr, canonical_text) TO stdout;
aimdb_dump: pg_dump failed

1500000 rows

Mvh Pär

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Evan Rempel 2024-11-07 18:13:07 Re: Running rsync backups in pg15
Previous Message Ron Johnson 2024-11-07 18:02:25 Re: Running rsync backups in pg15