pg_dumpall errors - Mailing list pgsql-admin

From Luke Clutter
Subject pg_dumpall errors
Date
Msg-id 20040130194624.92470.qmail@web9603.mail.yahoo.com
Whole thread Raw
List 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:

Previous
From: Chris Gamache
Date:
Subject: Alternative to "Money" ...
Next
From: Luke Clutter
Date:
Subject: pg_dumpall errors.