Skip site navigation (1) Skip section navigation (2)

pg_dumpall errors

From: Luke Clutter <clutterl(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dumpall errors
Date: 2004-01-30 19:46:24
Message-ID: 20040130194624.92470.qmail@web9603.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
We recently had an unexpected san outage which caused
our postgresql to stop pg_dumpall'ing properly.  As a
unix admin, not a db person, i'm short on ideas for
what I should try next.

some base info:
RHAS2.1 box

postgresql-libs-7.1.3-4bp.2
postgresql-jdbc-7.1.3-4bp.2
postgresql-tk-7.1.3-4bp.2
postgresql-7.1.3-4bp.2
postgresql-contrib-7.1.3-4bp.2
postgresql-perl-7.1.3-4bp.2
postgresql-docs-7.1.3-4bp.2
postgresql-python-7.1.3-4bp.2
postgresql-server-7.1.3-4bp.2
postgresql-tcl-7.1.3-4bp.2
postgresql-odbc-7.1.3-4bp.2

#pg_dumpall > pg_dumpall.txt 
ERROR:  not all toast chunks found for value 12660184
PQendcopy: resetting connection
SQL query to dump the contents of Table 'inmail_' did
not execute correctly.  After we read all the table
contents from the backend, PQendcopy() failed. 
Explanation from backend: ''.
The query was: 'COPY "inmail_" TO stdout;
'.
pg_dump failed on lmpg, exiting


#vacuumdb -z -v lmpg 
NOTICE:  --Relation pg_type--
NOTICE:  Pages 3: Changed 0, reaped 0, Empty 0, New 0;
Tup 202: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0,
MinLen 106, MaxLen 109; Re-using: Free/Avail. Space
0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
....
....
NOTICE:  --Relation pg_toast_18779--
NOTICE:  Pages 3745: Changed 0, reaped 437, Empty 0,
New 0; Tup 16223: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed
539, MinLen 46, MaxLen 2034; Re-using: Free/Avail.
Space 33756/31020; EndEmpty/Avail. Pages 0/64. CPU
0.09s/0.01u sec.
NOTICE:  Index pg_toast_18779_idx: Pages 222; Tuples
16223: Deleted 0. CPU 0.02s/0.03u sec.
NOTICE:  Rel pg_toast_18779: Pages: 3745 --> 3745;
Tuple(s) moved: 0. CPU 0.05s/0.01u sec.
NOTICE:  Analyzing...
ERROR:  not all toast chunks found for value 12660184
vacuumdb: vacuum  lmpg failed

Thanks in advance,
and if anyone wants more info, please let me know...

Luke


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

pgsql-admin by date

Next:From: Bruno Wolff IIIDate: 2004-01-30 20:31:22
Subject: Re: Alternative to "Money" ...
Previous:From: Luke ClutterDate: 2004-01-30 19:39:04
Subject: pg_dumpall errors.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group