473,289 Members | 2,106 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

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
Nov 11 '05 #1
3 7328
"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: James Campbell | last post by:
ok, I am totally new to php and come from an asp background. I basically want to do an If > then > else > end if statement: my page is: <?php require_once('Connections/carresa.php'); ?>...
2
by: Gerhard Esterhuizen | last post by:
Hi, I am observing unexpected behaviour, in the form of a corrupted class member access, from a simple C++ program that accesses an attribute declared in a virtual base class via a chain of...
10
by: sindica | last post by:
I am using DevC++ 4.0 lately, which uses Mingw port of GCC, on a WinXP. I am surprised to see the malloc behaviour which is not consistent with the documentation. See the program and its output...
1
by: Diogo Biazus | last post by:
Hi, can anyone help me with this error: ERROR: missing chunk number 0 for toast value 14227980 Is there a solution? -- Diogo Biazus diogob@gmail.com http://www.postgresql.org.br
8
by: Steven D'Aprano | last post by:
I came across this unexpected behaviour of getattr for new style classes. Example: >>> class Parrot(object): .... thing = .... >>> getattr(Parrot, "thing") is Parrot.thing True >>>...
11
by: Vaibhav87 | last post by:
i write void main() { int j; j - = 0; printf("%d",y); } & i got the answer as 842. i tried it on various computers but the answer is same. pls help me how is this answer is?
7
by: rellaboyina | last post by:
Need to process an XML Chunk by Chunk..... I had an XML. It will consist of a number of similar type of tags and what I want to do is to process a certaing group of methods on each of these...
6
by: ehabaziz2001 | last post by:
My Program turned a char variable into string using null character but unexpected character displayed infront of the variable after using printf . Syntax : ------------- #include <stdio.h> ...
10
by: Bill Cunningham | last post by:
My compiler gives me a syntax error on line 13 and I don't see. Here's the code. #include <stdio.h> int chunk (char *n1, char *n2, int bs, int nb); main(){ int chunk (char *n1, char *n2,...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.