ERROR: missing chunk number 0 for toast value

From: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: ERROR: missing chunk number 0 for toast value
Date: 2007-02-23 17:54:06
Message-ID: a97c77030702230954o481f8740ud1096258f02b6929@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I get the above error while selecting data from a table.
i have reindexed the table and possibly toast table
but it does not seems to help. result of vacuum full is also
attached. can anyone please help. even pg_dump is not able to dump
the table.

pg_dump: ERROR: missing chunk number 0 for toast value 697890392
pg_dump: SQL command to dump the contents of table "bad_emails"
failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR: missing chunk number
0 for toast value 697890392

regds
mallah.

tradein_clients=# VACUUM full verbose ANALYZE email_handling.bad_emails;
INFO: vacuuming "email_handling.bad_emails"
INFO: "bad_emails": found 0 removable, 253598 nonremovable row
versions in 15920 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 91 to 2036 bytes long.
There were 16060 unused item pointers.
Total free space (including removable row versions) is 5180436 bytes.
0 pages are or will become empty, including 0 at the end of the table.
7059 pages containing 4848956 free bytes are potential move destinations.
CPU 0.23s/0.08u sec elapsed 0.93 sec.
INFO: index "bad_emails_code" now contains 253598 row versions in 558 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.01s/0.06u sec elapsed 0.08 sec.
INFO: index "bad_emails_code_pending" now contains 177762 row
versions in 588 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.05u sec elapsed 0.06 sec.
INFO: index "bad_emails_date_id" now contains 253598 row versions in 558 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.01s/0.06u sec elapsed 0.08 sec.
INFO: index "bad_emails_email_key" now contains 253598 row versions
in 558 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.01s/0.09u sec elapsed 0.11 sec.
INFO: index "bad_emails_pkey" now contains 253598 row versions in 558 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.01s/0.06u sec elapsed 0.10 sec.
INFO: "bad_emails": moved 24 row versions, truncated 15920 to 15915 pages
DETAIL: CPU 0.48s/0.31u sec elapsed 22.59 sec.
INFO: index "bad_emails_code" now contains 253598 row versions in 558 pages
DETAIL: 24 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.09 sec.
INFO: index "bad_emails_code_pending" now contains 177762 row
versions in 588 pages
DETAIL: 10 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.02 sec.
INFO: index "bad_emails_date_id" now contains 253598 row versions in 558 pages
DETAIL: 24 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.07 sec.
INFO: index "bad_emails_email_key" now contains 253598 row versions
in 558 pages
DETAIL: 24 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.01s/0.01u sec elapsed 0.04 sec.
INFO: index "bad_emails_pkey" now contains 253598 row versions in 558 pages
DETAIL: 24 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.11 sec.
INFO: vacuuming "pg_toast.pg_toast_555824297"
INFO: "pg_toast_555824297": found 0 removable, 901381 nonremovable
row versions in 213818 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 41 to 2034 bytes long.
There were 4574 unused item pointers.
Total free space (including removable row versions) is 67493772 bytes.
0 pages are or will become empty, including 0 at the end of the table.
71284 pages containing 65771412 free bytes are potential move destinations.
CPU 4.49s/1.28u sec elapsed 172.29 sec.
INFO: index "pg_toast_555824297_index" now contains 901381 row
versions in 2474 pages
DETAIL: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.06s/0.20u sec elapsed 1.53 sec.

INFO: "pg_toast_555824297": moved 0 row versions, truncated 213818 to
213818 pages
DETAIL: CPU 0.44s/0.24u sec elapsed 11.25 sec.
INFO: analyzing "email_handling.bad_emails"
INFO: "bad_emails": scanned 3000 of 15915 pages, containing 47417
live rows and 1 dead rows; 3000 rows in sample, 251547 estimated total
rows
VACUUM

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Mayer 2007-02-23 20:07:56 Re: Priorities for users or queries?
Previous Message Tore Halset 2007-02-23 17:31:38 Re: invalid byte sequence for encoding "UTF8": 0x00