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