missing chunk number 0 for toast value

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: missing chunk number 0 for toast value
Date: 2005-04-27 21:31:50
Message-ID: 200504271531.50285.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


This is for PostgreSQL 7.4.6 on hppa2.0w-hp-hpux11.00, compiled
by GCC 3.2.2. I'm seeing the following 2 errors:

ERROR: missing chunk number 0 for toast value 19319495
ERROR: unexpected chunk number 4 (expected 0) for toast value
19319495

It is always the same toast value. The table has 1.8M rows.
I've identified the column and the row:

$ psql -c "\d audit"
Table "public.audit"
Column | Type | Modifiers
--------+-----------------------------+-----------
value | text |
cdate | timestamp without time zone |
key | text |
Indexes:
"idx_audit_cdate" btree (cdate)
"idx_audit_key" btree ("key")

$ psql -c "select key from audit where key = '791015.o9'"
key
-----------
791015.o9
(1 row)

$ psql -c "select cdate from audit where key = '791015.o9'"
cdate
---------------------
2005-04-06 00:00:00
(1 row)

$ psql -c "select value from audit where key = '791015.o9'"
ERROR: missing chunk number 0 for toast value 19319495

It causes all dumps and any access (via SELECT, UPDATE, and
COPY/pg_dump) to audit.value to fail. I've tried to look at the
underlying toast table per some old posts, but no joy.

As usual, this is on a system with a downtime-sensitive customer.

Any ideas?

Ed

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Uwe C. Schroeder 2005-04-27 21:52:56 Re: restarting after power outage
Previous Message Typing80wpm 2005-04-27 21:27:25 Postgresql, Windows, Peer-2-Peer network