vacuum is failing

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuum is failing
Date: 2005-01-04 22:26:12
Message-ID: 7c1574a9050104142628973c0b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've got a server running PostgreSQL-7.2.3 on RHAS-2.1. The version
of Postgresql is *not* my choice, I would have gone with something
much more current, but i digress.

Running 'vacuumdb -a -z -v -f' has started failing:

NOTICE: Index pg_toast_218644531_idx: Pages 1; Tuples 0.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE: Analyzing doc2_review_comments
NOTICE: --Relation groups--
NOTICE: Pages 28: Changed 0, reaped 2, Empty 0, New 0; Tup 331: Vac
2, Keep/VTL 0/0, UnUsed 1, MinLen 160, MaxLen 1988; Re-using:
Free/Avail. Space 13360/12448; EndEmpty/Avail. Pages 0/17.
CPU 0.01s/0.00u sec elapsed 0.07 sec.
NOTICE: Index grps: Pages 2; Tuples 331: Deleted 2.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE: Index groups_public: Pages 2; Tuples 331: Deleted 2.
CPU 0.00s/0.00u sec elapsed 0.02 sec.
NOTICE: Index groups_status: Pages 2; Tuples 331: Deleted 2.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE: Index groups_type: Pages 2; Tuples 331: Deleted 2.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE: Index group_unix_uniq: Pages 4; Tuples 331: Deleted 2.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
ERROR: No one parent tuple was found

Anyone have any suggestions on how to correct this? This DB serves a
web based PHP application, and right now there isn't any end user
noticable problems, and i'd like to keep it that way :)

thanks in advance!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2005-01-04 23:10:51 Re: PostgreSQL 8.0.0 Release Candidate 3
Previous Message Tom Lane 2005-01-04 21:36:36 Re: hundreds of millions row dBs