mising chunk

I had this problem a few weeks ago.

What I did was isolate it into an individual row that was causing the
problem, then going over the fields one by one, till I located the free
text field that was responsible.

Then I repopulated it with the value in the latest backup I could find.

I wasn't able to find any better techniques on the web.

For locating the faulty row, you might want to write a procedural
routine that will query rows sequentially.

I did it in a very crude way by using LIMIT statements till I hit the
mark.

As to why this happens, the suggestion I got here was faulty hardware.

Good luck

_____

From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrzej Folek
Sent: Saturday, August 26, 2006 3:47 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] mising chunk

I've got a problem with conversion.
Database is running on pg8.1.3
I've 2 tables, in one there is mediabinary collumn of bytea type. And
during conversion to another table / conversion only move data from
timestamp type to timestamptz but mediabinary in botha are the same. And
during query which move data I recieve ' MISSING CHUNK NUMBER 0 FOR
TOAST VALUE .. I've re-index this table, vacumed and nothing. Everytime
I get this info.
Please give me some advice how to fix this or even drop data to file I
don't know, any suggestion????

Hello , thanks for answer. i've also serach goole to find any answer but nowhere have found that. But how to find it - can you send me some queries that you have used???It would be very glad

Thanks very much
Andrzej
----- Original Message -----
From: Silvela, Jaime (Exchange)
To: Andrzej Folek ; pgsql-general@postgresql.org
Sent: Saturday, August 26, 2006 10:03 PM
Subject: RE: [GENERAL] mising chunk

I had this problem a few weeks ago.

What I did was isolate it into an individual row that was causing the problem, then going over the fields one by one, till I located the free text field that was responsible.

Then I repopulated it with the value in the latest backup I could find.

I wasn't able to find any better techniques on the web.

For locating the faulty row, you might want to write a procedural routine that will query rows sequentially.

I did it in a very crude way by using LIMIT statements till I hit the mark.

As to why this happens, the suggestion I got here was faulty hardware.

Good luck

------------------------------------------------------------------------------

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrzej Folek
Sent: Saturday, August 26, 2006 3:47 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] mising chunk

I've got a problem with conversion.
Database is running on pg8.1.3
I've 2 tables, in one there is mediabinary collumn of bytea type. And during conversion to another table / conversion only move data from timestamp type to timestamptz but mediabinary in botha are the same. And during query which move data I recieve ' MISSING CHUNK NUMBER 0 FOR TOAST VALUE .. I've re-index this table, vacumed and nothing. Everytime I get this info.
Please give me some advice how to fix this or even drop data to file I don't know, any suggestion????

------------------------------------------------------------------------------

***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.

Bear Stearns does not provide tax, legal or accounting advice. You
should consult your own tax, legal and accounting advisors before
engaging in any transaction. In order for Bear Stearns to comply with
Internal Revenue Service Circular 230 (if applicable), you are notified
that any discussion of U.S. federal tax issues contained or referred to
herein is not intended or written to be used, and cannot be used, for
the purpose of: (A) avoiding penalties that may be imposed under the
Internal Revenue Code; nor (B) promoting, marketing or recommending to
another party any transaction or matter addressed herein.
***********************************************************************