Possible bug in new VACUUM code

From: Jan Wieck <janwieck(at)yahoo(dot)com>
To: PostgreSQL HACKERS <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Possible bug in new VACUUM code
Date: 2001-11-28 00:45:29
Message-ID: 200111280045.fAS0jTt03091@saturn.jw.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I just stumbled over a very hard to reproduce error. Running
a "VACUUM ANALYZE <table>" concurrently to a database heavy
under load caused a SELECT ... FOR UPDATE with full primary
key qualification to return multiple results from that table.
The table contains only a few rows which receive ton's of
updates.

System is 7.2B3 under Linux.

Will try to produce a test case, just to let ppl know early.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2001-11-28 01:31:22 FW: [ppa-dev] Severe bug in debian - phppgadmin opens up databases for anyone!
Previous Message Bruce Momjian 2001-11-28 00:32:40 Re: Developers FAQ (was:Re: Packaging 7.1.1)