Thread: Fwd: Postgres update

Any comments?
This is vacuum... And it happends several time.
PostgreSQL 7.0.2

----------  Пересланное сообщение  ----------
Subject: Postgres update
Date: Fri, 27 Oct 2000 23:00:01 -0500 (EST)
From: webmail@webmailstation.com (WebmailStation User)
To: dyp@perchine.com


psql:/home/www/www.webmailstation.com/sql/vacuum.limits.sql:1: NOTICE:
 --Relation limits--
 psql:/home/www/www.webmailstation.com/sql/vacuum.limits.sql:1: NOTICE:
 Pages 72: Changed 55, reaped 10, Empty 0, New 0; Tup 9404: Vac 279, Keep/VTL
 1658/1658, Crash 0, UnUsed 0, MinLen 56, MaxLen 56; Re-using: Free/Avail.
 Space 15864/15864; EndEmpty/Avail. Pages 0/10. CPU 0.03s/0.00u sec.
 psql:/home/www/www.webmailstation.com/sql/vacuum.limits.sql:1: NOTICE:
 Index limits_id_key: Pages 63; Tuples 9404: Deleted 279. CPU 0.01s/0.02u
 sec. psql:/home/www/www.webmailstation.com/sql/vacuum.limits.sql:1: NOTICE:
 Index ix_limits_sid_type: Pages 81; Tuples 9404: Deleted 279. CPU
 0.01s/0.02u sec.
 psql:/home/www/www.webmailstation.com/sql/vacuum.limits.sql:1: ERROR:
 Parent tuple was not found

-------------------------------------------------------

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

Denis Perchine <dyp@perchine.com> writes:
> PostgreSQL 7.0.2
>  psql:/home/www/www.webmailstation.com/sql/vacuum.limits.sql:1: ERROR:
>  Parent tuple was not found

This could be related to the VACUUM problem Alfred Perlstein was seeing;
it's coming out of the same bit of code, anyway.  Can you try it with
current REL7_0_PATCHES branch (7.0.3-to-be) and see if the error is
still there?

            regards, tom lane