From: Luke Clutter <clutterl@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: pg_dumpall errors.
Date: Fri, 30 Jan 2004 11:39:04 -0800 (PST)
Message-ID: <20040130193904.61715.qmail@web9606.mail.yahoo.com> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: clutterl@yahoo.com
Subject: Re: pg_dumpall errors.
In-Reply-To: <20040130193904.61715.qmail@web9606.mail.yahoo.com>
References: <20040130193904.61715.qmail@web9606.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox