pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Repeated crashes in GENERATED ... AS IDENTITY tests
Date: Thu, 19 Apr 2018 17:23:07 -0400
Message-ID: <10345.1524172987@sss.pgh.pa.us> (raw)
In-Reply-To: <20180419204946.5ujino6w4dy7biuc@alvherre.pgsql>
References: <20180419204946.5ujino6w4dy7biuc@alvherre.pgsql>

Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Of the machines you listed, conchuela has gdb installed, which gives us
> a nice backtrace of the crash, pasted below, which seems to blame event
> triggers.  Of the tests in the same parallel group as identity, the test
> fast_default seems to be the only one with an event trigger and was
> added on March 28th by 16828d5c0273.  That combination seems to explain
> why the crashes appeared late ...

Hm.  Our past policy has been that tests involving event triggers must not
run in parallel with any other test, precisely because the event triggers
interact with anything else happening at the same time, and will
inevitably create irreproducible test failures.

I'm inclined to say that whether or not there's a bug here (and there
well may be, it doesn't seem like a crash is a good thing), this is
bad test design and we need to change it.

			regards, tom lane




view thread (4+ messages)  latest in thread

Message-ID: <10345.1524172987@sss.pgh.pa.us>
Permalink:  ../10345.1524172987@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/10345.1524172987@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, alvherre@alvh.no-ip.org, pgsql-hackers@lists.postgresql.org
  Subject: Re: Repeated crashes in GENERATED ... AS IDENTITY tests
  In-Reply-To: <10345.1524172987@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox