	Your e-mail did not arrive at its intended destination. You need to
send it to Michael J. Davis, not Michael Davis


	From:	Dirk Lutzebaeck <lutzeb @ aeccom.com> on 05/05/99 03:30 AM
	To:	Tom Lane <tgl @ sss.pgh.pa.us>@SMTP@EXCHANGE
	cc:	hackers @ postgreSQL.org@SMTP@EXCHANGE 
	Subject:	Re: [HACKERS] major flaw in 6.5beta1???
(UPDATE/INSERT waiting) 

	Tom Lane writes:
	 > Dirk Lutzebaeck <lutzeb@aeccom.com> writes:
	 > > cs=> select envelope from recipient where envelope=510349;
	 > > [ returns a tuple that obviously fails the WHERE condition ]
	 > 
	 > Yipes.  Do you have an index on the envelope field, and if so is
	 > it being used for this query?  (Use EXPLAIN to check.)  My guess
	 > is that the index is corrupted.  Dropping and recreating the
index
	 > would probably set things right.

	Yes, thanks, recreating the index cures the problem.

	 > Of course the real issue is how it got corrupted.  Hiroshi found
	 > an important bug in btree a few days ago, and there is a
discussion
	 > going on right now about lock-manager bugs that might possibly
allow
	 > multiple backends to corrupt data that they're concurrently
updating.
	 > But I have no idea if either of those explains your problem.

	Does this mean they can deadlock themselves?  Is this also true for
	6.4.2? I probably switch back then.

	Thanks, Dirk




Wed, 5 May 1999 09:20:40 -0500 
Michael Davis <Michael.Davis@tvguide.com>
Re: [HACKERS] major flaw in 6.5beta1??? (UPDATE/INSERT waiting)