ERROR: attempted to delete invisible tuple

From: Bryan Murphy <bmurphy1976(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: attempted to delete invisible tuple
Date: 2009-08-17 15:23:58
Message-ID: 7fd310d10908170823x749e2cb6k296b24794061f2e7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We had a hardware failure last week and had to switch over to our spare.
Unfortunately, at some point we managed to get some data corruption. I've
been going through the database table by table, record by record, trying to
find the problems and fix them.

This one has me stumped. We have one table with about 13 million records in
it. I've identified 82 bad records. When I try to query for the records,
we get the following:

ERROR: missing chunk number 0 for toast value 25692661 in pg_toast_25497233

That's fine. I've run into that in a few other tables and have just been
deleting the offending records. However, in this particular table, when I
try and delete the records, I get the following error message:

ERROR: attempted to delete invisible tuple

I'm at a loss what to do next.

Thanks,
Bryan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-08-17 15:42:14 Re: design, plpgsql and sql injection in dynamically generated sql
Previous Message Sam Mason 2009-08-17 15:20:31 Re: Generating random unique alphanumeric IDs