vacuum is failing
От | Lonni J Friedman |
---|---|
Тема | vacuum is failing |
Дата | |
Msg-id | 7c1574a9050104142628973c0b@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: vacuum is failing
|
Список | 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@gmail.com LlamaLand http://netllama.linux-sxs.org
В списке pgsql-general по дате отправления: