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@Yahoo.com #



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


Tue, 27 Nov 2001 19:45:29 -0500 (EST)
Jan Wieck <janwieck@yahoo.com>
Possible bug in new VACUUM code
Jan Wieck <janwieck@yahoo.com> writes:
>     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.

Urgh.  But I am not sure that you should be pointing the finger at
VACUUM.  It doesn't move any tuples around (at least not in ctid
terms), so how could it possibly produce multiple tuple images in
another scan?  My early bet is that the problem is not directly
related to VACUUM.

Post as soon as you have any more info ... remember there are lots
of eyeballs out here ...

			regards, tom lane

Tue, 27 Nov 2001 23:27:37 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Possible bug in new VACUUM code 
Jan Wieck wrote:
> 
> 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.

Can you post an explain plan for the query along with a "\d" of the table?

Wed, 28 Nov 2001 06:58:25 -0500
mlw <markw@mohawksoft.com>
Re: Possible bug in new VACUUM code