From: | Lonni Friedman <lfriedman(at)vasoftware(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: unable to dump database, toast errors |
Date: | 2003-04-06 19:58:40 |
Message-ID: | 3E9086F0.2050508@vasoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/04/03 14:32, Tom Lane wrote:
>> i'm positive that there is a much more recent release. this server is
>> sadly, very poorly maintained by the customer. do you feel that the
>> segfaults generated in psql are blocking any possible solution to the
>> pg_dump failures, or can you/I work on a solution for that indpendently of
>> resolving the segfaults?
>
> Assuming that I've correctly diagnosed the segfault, it will only occur
> if you try to print an extremely wide value in psql. It's pretty easy
> to avoid doing so, though. For example, you could query for
> LENGTH(bin_data) or a SUBSTRING() of it, instead of printing the whole
> field value. AFAIR, 7.2 does not have any optimizations that would
> skip fetching the whole toasted value when it is the argument of one of
> these functions, so "select length(bin_data) ..." should be just as
> useful for checking for brokenness as "select bin_data ...".
Hi Tom,
Following your suggestion, i pinned down the following:
sfee=# select LENGTH(bin_data) from artifact_file LIMIT 1 OFFSET 693;
ERROR: missing chunk number 1 for toast value 7685119
However, what is very odd, is that I can view the entire contents of
that row's particular bin_data column if i do a normal select:
select bin_data from artifact_file LIMIT 1 OFFSET 693;
and it completes with no errors. After more testing, it appears that
the 'select LENGTH(bin_data) ...' for any offset greater than or equal
to 693 dies with the same 'missing chunk...' error.
any suggestions on where to go from here?
thanks
-Lonni
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2003-04-06 20:23:04 | Consecutive queries |
Previous Message | Rod Kreisler | 2003-04-06 17:23:37 | Re: PHP as PL |