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 <[email protected]> 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, <[email protected]> wrote: > >> [image: Boxbe] <https://www.boxbe.com/overview> Tom Lane ( >> [email protected]) 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 <[email protected]> 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!
