Re: Application Error When Accessing the Table – PostgreSQL 15.18

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: loganathan P <plogandba(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Subject: Re: Application Error When Accessing the Table – PostgreSQL 15.18
Date: 2026-11-05 03:48:33
Message-ID: CANzqJaDfUhKxDA38RTpNWWjn0HMnkDeH_dTuHjm5QXVK-SAkoA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Try deleting that one row. Or exporting every row of the table *except* that
one row. (Then recreate the table and import.)

On Wed, Nov 4, 2026 at 9:53 PM loganathan P <plogandba(at)gmail(dot)com> wrote:

> Dear All,
>
> While attempting to delete the corrupted rows, I am encountering the
> following error.
>
> ERROR: tuple already updated by self.
>
>
> Thanks.
>
>
> Regards,
>
> Loganathan P
>
>
>
> On Wed, 4 Nov, 2026, 8:37 pm Tom Lane, <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> [image: Boxbe] <https://www.boxbe.com/overview> Tom Lane (
>> tgl(at)sss(dot)pgh(dot)pa(dot)us) is not on your Guest List
>> <https://www.boxbe.com/approved-list?tc_serial=61984809141&tc_rand=2014793862&utm_source=stf&utm_medium=email&utm_campaign=ANNO_MWTP&utm_content=001&&key=JQ3tI3eduxxJHzt5mWVx32Pxo0jpUjHoGr0HJMHGZ8M%3D&token=%2Fs%2FcOiPbIzNdXQbLqZPDKmB02RANtTOkdwAPYI6vKjfUfuEQcHyroNRtyvL5lr5W>
>> | Approve sender
>> <https://www.boxbe.com/anno?tc_serial=61984809141&tc_rand=2014793862&utm_source=stf&utm_medium=email&utm_campaign=ANNO_MWTP&utm_content=001&&key=JQ3tI3eduxxJHzt5mWVx32Pxo0jpUjHoGr0HJMHGZ8M%3D&token=%2Fs%2FcOiPbIzNdXQbLqZPDKmB02RANtTOkdwAPYI6vKjfUfuEQcHyroNRtyvL5lr5W>
>> | Approve domain
>> <https://www.boxbe.com/anno?tc_serial=61984809141&tc_rand=2014793862&utm_source=stf&utm_medium=email&utm_campaign=ANNO_MWTP&utm_content=001&&dom&key=JQ3tI3eduxxJHzt5mWVx32Pxo0jpUjHoGr0HJMHGZ8M%3D&token=%2Fs%2FcOiPbIzNdXQbLqZPDKmB02RANtTOkdwAPYI6vKjfUfuEQcHyroNRtyvL5lr5W>
>> Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> writes:
>> > 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.
>>
>> Indeed, but you might be able to get out of it by REINDEX'ing that
>> toast table, especially if you recently used REINDEX CONCURRENTLY
>> on it. There's a recently-fixed bug that could lead to damaged
>> toast indexes, though fortunately not to corruption of the tables
>> themselves.
>>
>> regards, tom lane
>>
>

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2026-11-05 04:48:09 Re: Return trimmed string from the query
Previous Message Igor Korot 2026-11-05 02:56:25 Re: Return trimmed string from the query