missing chunk number 0 for toast value 25693266 in pg_toast_25497233

From: Bryan Murphy <bmurphy1976(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: missing chunk number 0 for toast value 25693266 in pg_toast_25497233
Date: 2010-05-06 23:24:41
Message-ID: s2u7fd310d11005061624k965a091bg98d8e0e25f4f4d60@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running into this issue again:

psql --version
psql (PostgreSQL) 8.3.7

COPY items_extended TO '/dev/null';
ERROR: missing chunk number 0 for toast value 25693266 in pg_toast_25497233

Unfortunately, I do not know where these are coming from and I cannot
replicate the data in at least one of my tables (which has 20 million
records) because of this. I've already found 10 bad records. There
are more.

I have four tables with 20 million records (and a fifth which has even
more) that may have this problem. Right now, checking every record
one by one is going to take *DAYS* to complete, and I'm in the middle
of adding additional nodes to our cluster because we are already
stretched to the limit.

I have a few options, such as trying to check batches of records and
spinning up multiple checkers in parallel looking at different subsets
of the data on wal shipped spares (assuming the wal shipped spares
would suffer the same problem, which is a big assumption), but this is
a lot of effort to get going.

Help!

Thanks,
Bryan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenichiro Tanaka 2010-05-07 00:32:52 Re: How to deal with NULL values on dynamic queries?
Previous Message Andre Lopes 2010-05-06 23:02:57 How to deal with NULL values on dynamic queries?