Re: pgsql: Fix deadlock hazard in CREATE INDEX CONCURRENTLY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Fix deadlock hazard in CREATE INDEX CONCURRENTLY
Date: 2018-01-03 14:53:31
Message-ID: 11104.1514991211@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> Alvaro Herrera wrote:
>> However this means that the test will get removed in 9.4 and 9.5 because
>> isolationtester is not smart enough there.
>>
>> I suppose the other option would be to add an alternate expected file
>> for the test.

> Actually, so far only 9.6 and up have failed. Maybe the old
> isolationtester is different enough that the other thing doesn't happen.

> I'm more inclined now to add the alternate file instead of the other
> patch.

Meh. I'd rather have the more stable test going forward; I think
alternate expected-files too easily hide unexpected behavior. We could
try leaving 9.4/9.5 alone and see if it's true that it doesn't fail
there. If not, I wouldn't mind losing the test in those branches
--- it's mainly intended to catch future breakage, after all.

regards, tom lane

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2018-01-03 15:09:21 pgsql: Fix isolation test to be less timing-dependent
Previous Message Alvaro Herrera 2018-01-03 14:47:49 Re: pgsql: Fix deadlock hazard in CREATE INDEX CONCURRENTLY