Обсуждение: Re: [HACKERS] major flaw in 6.5beta1??? (UPDATE/INSERT waiting)
Re: [HACKERS] major flaw in 6.5beta1??? (UPDATE/INSERT waiting)
От
Michael.Davis@tvguide.com (Michael Davis)
Дата:
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 AMTo: Tom Lane <tgl @ sss.pgh.pa.us>@SMTP@EXCHANGEcc: 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 theenvelope field, and if so is > it being used for this query? (Use EXPLAIN to check.) My guess > is that the index iscorrupted. 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 thereis 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 for6.4.2? I probably switch back then. Thanks, Dirk