X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7256AD1B481 for ; Fri, 30 Jan 2004 19:46:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 78197-08 for ; Fri, 30 Jan 2004 15:46:26 -0400 (AST) Received: from web9603.mail.yahoo.com (web9603.mail.yahoo.com [216.136.129.182]) by svr1.postgresql.org (Postfix) with SMTP id 98000D1B444 for ; Fri, 30 Jan 2004 15:46:24 -0400 (AST) Message-ID: <20040130194624.92470.qmail@web9603.mail.yahoo.com> Received: from [136.223.19.43] by web9603.mail.yahoo.com via HTTP; Fri, 30 Jan 2004 11:46:24 PST Date: Fri, 30 Jan 2004 11:46:24 -0800 (PST) From: Luke Clutter Subject: pg_dumpall errors To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/302 X-Sequence-Number: 12165 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/