Обсуждение: unexpected chunk number
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
"Eric Anderson Vianet SAO" <eric@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
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@sss.pgh.pa.us> To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> Cc: "PostgreSQL general" <pgsql-general@postgresql.org> Sent: Friday, August 08, 2003 12:43 PM Subject: Re: [GENERAL] unexpected chunk number > "Eric Anderson Vianet SAO" <eric@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 majordomo@postgresql.org)
sorry about dumb ´lenght´ instead ´length´. the length of chunk_data is 255. tnx. Eric ----- Original Message ----- From: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> To: "PostgreSQL general" <pgsql-general@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" <tgl@sss.pgh.pa.us> > To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> > Cc: "PostgreSQL general" <pgsql-general@postgresql.org> > Sent: Friday, August 08, 2003 12:43 PM > Subject: Re: [GENERAL] unexpected chunk number > > > > "Eric Anderson Vianet SAO" <eric@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 majordomo@postgresql.org) > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
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@vianet-express.com.br> To: "PostgreSQL general" <pgsql-general@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" <eric@vianet-express.com.br> > To: "PostgreSQL general" <pgsql-general@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" <tgl@sss.pgh.pa.us> > > To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> > > Cc: "PostgreSQL general" <pgsql-general@postgresql.org> > > Sent: Friday, August 08, 2003 12:43 PM > > Subject: Re: [GENERAL] unexpected chunk number > > > > > > > "Eric Anderson Vianet SAO" <eric@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 majordomo@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