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=
Show quoted text
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
Show quoted text
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 value6935=
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 numberit 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)
Show quoted text
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?