Re: BUG #15577: Query returns different results when executed multiple times

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Bartosz Polnik <bartoszpolnik(at)gmail(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15577: Query returns different results when executed multiple times
Date: 2019-01-09 20:31:57
Message-ID: CAEepm=2R5mcsBX5bJ2ZefT3x_V2az+zc2O+waeqrX_nOJKUPFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Jan 9, 2019 at 8:48 PM Bartosz Polnik <bartoszpolnik(at)gmail(dot)com> wrote:
> Thomas, I tried to reproduce this case with changes you listed, but failed to do that - the number of results was the same on each run. Could you post an updated script in an attachment?

Probably due to timing of parallel worker startup. Different
computers, operating systems, alignment of the stars etc. Debugging
parallel query problems is fun like that.

--
Thomas Munro
http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2019-01-09 21:04:05 Re: BUG #15577: Query returns different results when executed multiple times
Previous Message Thomas Munro 2019-01-09 20:20:42 Re: BUG #15577: Query returns different results when executed multiple times