Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Missing chunk number" error messages

Status
Not open for further replies.
pgosse

pgosse

Programmer
Sep 26, 2001
42
CA
Hi folks. We seem to have a corrupted database, or at least that's what I'm assuming. I noticed some very strange errors on Friday, and noticed some records had been randomly deleted, and then when attempting to dump the database this morning I got the following error:

Code: 
/usr/local/pgsql/bin/pg_dump -D -f CMS.EMERGENCY_DUMP.sql cms
pg_dump: dumpClasses(): SQL command failed
pg_dump: Error message from server: ERROR:  missing chunk number 0 for toast value 470723
pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor

Can anyone give me any advice as to what the problem is, or point me somewhere that explains it in detail?

Cheers and TIA,

Pablo
 
Status
Not open for further replies.

Similar threads

MrCBofBCinTX
  • Locked
  • Question
public."returns"
Replies
1
Views
70
feherke
feherke
SirChasm
  • Locked
  • Question
"server closed the connection unexpectedly"
Replies
0
Views
60
SirChasm
SirChasm
theshaner6
  • Locked
  • Question
Relation "<table>" Does Not Exist
Replies
5
Views
122
theshaner6
theshaner6
Tore
  • Locked
  • Question
ERROR: invalid byte sequence for encoding "UTF8": 0xe3a520 ' .. help?
Replies
0
Views
52
Tore
Tore
paulb1988
  • Locked
  • Question
Cannot get "WHERE" clause in query to work
Replies
2
Views
64
ceco
ceco

Part and Inventory Search

Sponsor

Back
Top