473,699 Members | 2,693 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 "tbdmovimen to" failed: PQendcopy() failed.

pg_dump: Error message from server: pg_dump: The command was: COPY "tbdmovimen to" 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 7407
"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,lengt h(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_indexsca n 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 YourEmailAddres sHere" to ma*******@postg resql.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,lengt h(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_indexsca n 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 YourEmailAddres sHere" to ma*******@postg resql.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 "tbdmovimen to" failed:
PQendcopy() failed.

pg_dump: Error message from server: pg_dump: The command was: COPY
"tbdmovimen to" 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,lengt h(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_indexsca n 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 YourEmailAddres sHere" to

ma*******@postg resql.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*******@postg resql.org

Nov 11 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
34701
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'); ?> <?php $DateTime = date("Y/n/j");
2
2165
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 virtual method calls. To further complicate (or perhaps simplify) matters, some compilers (GCC and MingW) produce the expected behaviour, while others (MSVS 7.1) do not. I can only offer two explanations for my observations: 1. The Microsoft...
10
1793
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 below. #include <stdio.h> #include <stdlib.h> int main(int argc, char *argv) {
1
4252
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
1900
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 >>> getattr(Parrot, "__dict__") is Parrot.__dict__ False
11
1862
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
2234
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 similar group of tags everytime. I tried it out with XML::Twig. But not able to get it as I am new to Perl. Can anybody help me out in this please..... Eg: <tsip:dataFeed=....>
6
2106
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> struct record {
10
2382
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, int bs, int nb) {FILE *fp;
0
8686
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8615
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8911
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8882
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7748
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6533
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5872
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3057
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2009
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.