Re: Application Error When Accessing the Table – PostgreSQL 15.18

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: loganathan P <plogandba(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Application Error When Accessing the Table – PostgreSQL 15.18
Date: 2026-11-04 07:27:55
Message-ID: c989c6033ae42cade41297333ac3541af1ee1034.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2026-11-04 at 11:52 +0530, loganathan P wrote:
> While accessing the table through the application, I encountered the following error.
> ERROR - missing chunk number 0 for toast value 55195659 in pg_toast_171559.

This is data corruption.

If you have a good backup, that's the easiest solution.

Other than that, identify the row that causes the error and delete it.

After you got rid of all the visible symptoms of corruption, dump
and restore the database to a newly created cluster - that will get
rid of any lurking corruption.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message loganathan P 2026-11-04 14:04:45 Re: Application Error When Accessing the Table– PostgreSQL 15.18
Previous Message rob stone 2026-11-04 07:16:35 Re: Application Error When Accessing the Table – PostgreSQL 15.18