Re: Improving the isolationtester: fewer failures, less delay

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2021-06-15T19:14:24Z
Lists: pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2021-06-14 22:57:08 -0400, Tom Lane wrote:
>> This is still WIP to some extent, as I've not spent much time looking at
>> specfiles other than the ones with big delays; there may be additional
>> improvements possible in some places.  Also, I've not worried about
>> whether the tests pass in serializable mode, since we have problems there
>> already [4].  But this seemed like a good point at which to solicit
>> feedback and see what the cfbot thinks of it.

> Are there spec output changes / new failures, if you apply the patch,
> but do not apply the changes to the spec files?

If you make only the code changes, there are a bunch of diffs stemming
from the removal of the 'error in steps' message prefix.  If you just
mechanically remove those from the .out files without touching the .spec
files, most tests pass, but I don't recall whether that's 100% the case.

> Will look at the patch itself in a bit.

I'll have a v2 in a little bit --- the cfbot pointed out that there
were some contrib tests I'd missed fixing, and I found a couple of
other improvements.

			regards, tom lane



Commits

  1. Use annotations to reduce instability of isolation-test results.