By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,177 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

unexpected chunk number

P: n/a
hello all

When i tried ´pg_dump -v -f dump.dmp dtbtransporte´ I got the error:

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

So I´ve ran a query to see which pg_toast from this tbdmovimento

So I shutdown de postmaster and up a standalone backend and reindexed the database (REINDEX DATABASE dtbtransporte FORCE). All this after a vacuum analyze.

How the pg_dump still returns above error, I´ve tried to REINDEX the index pg_toast_16557. Reindex ran ok, but the pg_dump still returns this error.

any ideas.

tnx

Eric
Nov 11 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Eric Anderson Vianet SAO" <er**@vianet-express.com.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 ma*******@postgresql.org)

Nov 11 '05 #2

P: n/a
sorry about dumb ´lenght´ instead ´length´.

the length of chunk_data is 255.

tnx.

Eric

----- Original Message -----
From: "Eric Anderson Vianet SAO" <er**@vianet-express.com.br>
To: "PostgreSQL general" <pg***********@postgresql.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" <tg*@sss.pgh.pa.us>
To: "Eric Anderson Vianet SAO" <er**@vianet-express.com.br>
Cc: "PostgreSQL general" <pg***********@postgresql.org>
Sent: Friday, August 08, 2003 12:43 PM
Subject: Re: [GENERAL] unexpected chunk number

"Eric Anderson Vianet SAO" <er**@vianet-express.com.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 ma*******@postgresql.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

Nov 11 '05 #3

P: n/a
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" <er**@vianet-express.com.br>
To: "PostgreSQL general" <pg***********@postgresql.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" <er**@vianet-express.com.br>
To: "PostgreSQL general" <pg***********@postgresql.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" <tg*@sss.pgh.pa.us>
To: "Eric Anderson Vianet SAO" <er**@vianet-express.com.br>
Cc: "PostgreSQL general" <pg***********@postgresql.org>
Sent: Friday, August 08, 2003 12:43 PM
Subject: Re: [GENERAL] unexpected chunk number

"Eric Anderson Vianet SAO" <er**@vianet-express.com.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

ma*******@postgresql.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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.