From: | "Utsav Turray" <utsav(dot)turray(at)newgen(dot)co(dot)in> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | missing chunk number 497 for toast value 504723663 |
Date: | 2010-09-16 12:20:22 |
Message-ID: | 001a01cb5599$897bcba0$9c7362e0$@turray@newgen.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear All ,
I am using postgres 7.3.2 on RHEL 4.0.
I know the version is too old but I have no option upgrading the postgres
version.
I have a table with a column type "text". The column consists large data
ranging from 500 kb to 900 kb.
Total there are 50000 records approximately. There are large number of
updates occurring on this table.
Few days ago on another installation an error was generated during pg_dump
"missing chunk number 0 for toast value xxx" or "missing chunk number 0 for
toast value xxx". This problem was resolved by re-indexing the toast table.
But this time there are total 422 records which are giving error of both
"missing chunk number" and "unexpected chunk number" on the "text column
type" and even re-indexing toast table is not resolving the issue. The only
option I am left is to delete these records.
Is there any other way to resolve this issue as deleting the records will
lead to loss of information and the backup I am having also consists of
corrupted records.
Secondly what are probable reasons behind corruption and what can we do to
prevent this error.
Thanks And Regards,
Utsav Turray
Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.
From | Date | Subject | |
---|---|---|---|
Next Message | Gissur Þórhallsson | 2010-09-16 12:47:17 | Re: value |
Previous Message | Sam Mason | 2010-09-16 11:18:52 | Re: Need magic for identifieing double adresses |