Re: unexpected chunk number

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
Cc: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: unexpected chunk number
Date: 2003-08-08 15:43:36
Message-ID: 27509.1060357416@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br> writes:
> pg_dump: dumping out the contents of table tbdmovimento
> pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value 6935=
> 693

Hm. Could we see the results of

select chunk_seq,length(chunk_data) from <tbdmovimento's toast table>
where chunk_id = 6935693;

If you are not trusting the index then it might be good to try this
with enable_indexscan turned off and see if you get the same answers.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenéz Attila 2003-08-08 16:07:33 FATAL: The database system is in recovery mode
Previous Message Eric Anderson Vianet SAO 2003-08-08 15:22:43 unexpected chunk number