Re: unexpected chunk number

From: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
To: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: unexpected chunk number
Date: 2003-08-08 17:14:06
Message-ID: 012b01c35dd0$797690a0$0701a8c0@netterm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I tried setting enable_indexcan off

and got same error:

dump the contents of table tbdmovimento

pg_dump: dumping out triggers

pg_dump: dumping out rules

pg_dump: creating TABLE tbdmovimento

pg_dump: restoring data for table tbdmovimento

pg_dump: dumping out the contents of table tbdmovimento

pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value
6935693

pg_dump: lost synchronization with server, resetting connection

pg_dump: SQL command to dump the contents of table "tbdmovimento" failed:
PQendcopy() failed.

pg_dump: Error message from server: pg_dump: The command was: COPY
"tbdmovimento" TO stdout;

pg_dump: *** aborted because of error

why can´t I simply update chunk_seq from 8 to 0?

tnx

----- Original Message -----
From: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
To: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, August 08, 2003 1:44 PM
Subject: Re: [GENERAL] unexpected chunk number

> sorry about dumb ´lenght´ instead ´length´.
>
> the length of chunk_data is 255.
>
> tnx.
>
> Eric
>
> ----- Original Message -----
> From: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
> To: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
> Sent: Friday, August 08, 2003 1:14 PM
> Subject: Re: [GENERAL] unexpected chunk number
>
>
> > it generates following error:
> >
> > ERROR: Function 'lenght(bytea)' does not exist
> >
> > Unable to identify a function that satisfies the given argument types
> >
> > You may need to add explicit typecasts
> >
> >
> >
> > this row is only which has chunk_seq = 8.
> >
> > why couldn´t I simply UPDATE it?
> >
> > tnx
> >
> > Eric
> >
> >
> >
> >
> > ----- Original Message -----
> > 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>
> > Sent: Friday, August 08, 2003 12:43 PM
> > Subject: Re: [GENERAL] unexpected chunk number
> >
> >
> > > "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
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 2: you can get off all lists at once with the unregister command
> > > (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Colm Dobbs 2003-08-08 17:29:21 postgesql-7.3.3 lo_create/lo_open fails
Previous Message Eric Anderson Vianet SAO 2003-08-08 16:44:43 Re: unexpected chunk number