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
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 |