From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Strange vacuum error Was: No long-lived transaction, still can't delete tuples |
Date: | 2002-04-25 16:38:49 |
Message-ID: | 5.1.0.14.1.20020426000655.0304c030@192.228.128.13 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
At 09:56 AM 4/25/02 -0400, Tom Lane wrote:
> > BEGIN followed by select
> > (1), causes vacuum to stop with:
> > ERROR: Parent tuple was not found
>
>Oh? If you have a repeatable example of that, I'd like to see it.
OK just got a different error:
VACUUM verbose arch_ranks_arch4;
NOTICE: --Relation arch_ranks_arch4--
NOTICE: Pages 136: Changed 0, reaped 134, Empty 0, New 0; Tup 6861: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed 4206, MinLen 88, MaxLen 1138; Re-using:
Free/Avail. Space 6364/2564; EndEmpty/Avail. Pages 0/23. CPU 0.01s/0.00u sec.
ERROR: No one parent tuple was found
select version();
version
---------------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
Regards,
Link.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-04-25 16:42:46 | Re: Performance Issues |
Previous Message | Andrey | 2002-04-25 16:23:10 | Re: How to deal with crashes? |