[6.5.2] potentially major bug?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Cc: bright(at)ns1(dot)wintelcom(dot)net
Subject: [6.5.2] potentially major bug?
Date: 2000-01-28 03:28:43
Message-ID: Pine.BSF.4.21.0001272322010.555-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Okay, I don't know if this has been fixed in 7.0, but:

webcounter=> drop index webhit_referer_raw_url;
DROP
webcounter=> create index webhit_referer_raw_url on webhit_referer_raw using btree ( referrer_url );
CREATE
webcounter=> vacuum verbose webhit_referer_raw;
NOTICE: --Relation webhit_referer_raw--
NOTICE: Pages 7910: Changed 3, Reapped 2192, Empty 0, New 0; Tup 547520: Vac 43402, Keep/VTL 0/0, Crash 0, UnUsed 4871, MinLen 60, MaxLen 312; Re-using: Free/Avail. Space 4388524/4361716; EndEmpty/Avail. Pages 0/915. Elapsed 0/0 sec.
NOTICE: Index webhit_referer_raw_url: Pages 5048; Tuples 547400: Deleted 0. Elapsed 0/2 sec.
NOTICE: Index webhit_referer_raw_url: NUMBER OF INDEX' TUPLES (547400) IS NOT THE SAME AS HEAP' (547520)
ERROR: Invalid XID in t_cmin

Thoughts? Is this something that is fixed in 7.0 right now? This is a
semi-production system right now, so the loss of information would be most
unfortunate :(

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-01-28 03:35:49 Re: [HACKERS] [6.5.3] 'attribute not found'
Previous Message Jeff MacDonald <jeff@pgsql.com> 2000-01-28 03:07:59 Re: [HACKERS] Spinlock error