From: Noah Misch <noah@leadboat.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Semab Tariq <semab.tariq@enterprisedb.com>
Cc: Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Andres Freund <andres@anarazel.de>
Cc: CM Team <cm@enterprisedb.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Geoghegan <pg@bowt.ie>
Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
Date: Tue, 9 Nov 2021 19:53:41 -0800
Message-ID: <20211110035341.GC968057@rfd.leadboat.com> (raw)
In-Reply-To: <CA+hUKGJK5R0S1LL_W4vEzKxNQGY_xGAQ1XknR-WN9jqQeQtB_w@mail.gmail.com>
References: <20211106230846.GA790288@rfd.leadboat.com>
<CABimMB4dQXvhB2Ja93BAWJzpM89RDzF-vdpM+=s4W7EbN+jKDw@mail.gmail.com>
<20211107232202.GA882747@rfd.leadboat.com>
<CABimMB5S-+-B5yU3g37qOg3b6+VqKKHygf0DUpG2J3WH=rd+Qg@mail.gmail.com>
<20211108070950.GB882747@rfd.leadboat.com>
<CABimMB4Z_qfkNrbYGXp=+oO6WPdGkVm35s9Zm+0r8gVxz_=sog@mail.gmail.com>
<20211108144639.GA919568@rfd.leadboat.com>
<CABimMB7kek5OKfNG53BW_tnM=EU=75_F80xvBjYEpUXQ+3Yuvw@mail.gmail.com>
<20211109144021.GD940092@rfd.leadboat.com>
<CA+hUKGJK5R0S1LL_W4vEzKxNQGY_xGAQ1XknR-WN9jqQeQtB_w@mail.gmail.com>
On Wed, Nov 10, 2021 at 10:55:13AM +1300, Thomas Munro wrote:
> On Wed, Nov 10, 2021 at 3:40 AM Noah Misch <noah@leadboat.com> wrote:
> > $ diff -U0 <(cut -b47- disasm/70bef49/equalTupleDescs) <(cut -b47- disasm/166f943/equalTupleDescs)
> > --- /dev/fd/63 2021-11-09 06:11:20.927444437 -0800
> > +++ /dev/fd/62 2021-11-09 06:11:20.926444428 -0800
> > @@ -100 +100 @@
> > - br.call.sptk.many rp=0x40000000003cdc20
> > + br.call.sptk.many rp=0x40000000003cde20
> > @@ -658 +658 @@
> > - br.call.sptk.many rp=0x40000000003cdc20
> > + br.call.sptk.many rp=0x40000000003cde20
> > @@ -817 +817 @@
> > - br.call.sptk.many rp=0x3fffffffff3fdc30
> > + br.call.sptk.many rp=0x4000000000400c30
> > @@ -949 +949 @@
> > - br.call.sptk.many rp=0x40000000003cdc20
> > + br.call.sptk.many rp=0x40000000003cde20
> > @@ -970 +970 @@
> > - br.call.sptk.many rp=0x40000000003cdc20
> > + br.call.sptk.many rp=0x40000000003cde20
> >
> > Since "git diff 70bef49 166f943" contains nothing that correlates with such a
> > change, I'm concluding that this is a bug in gharial's toolchain.
>
> Excellent detective work.
Thanks.
> > It looks like gharial's automatic buildfarm runs have been paused for nine
> > days. Feel free to unpause it. Also, I recommend using the buildfarm client
> > setnotes.pl to add a note like 'Rare signal 11 from toolchain bug'. Months or
> > years pass between these events. Here are all gharial "signal 11" failures,
> > likely some of which have other causes:
>
> Yeah I spent time investigating some of these at the time and I know
> others did too.
>
> IMHO we should hunt down dead toolchains and gently see if we can get
> them updated. There is no point in testing PostgreSQL on every
> commit on a compiler someone built from a tarball many years ago and
> never updated with bug fixes.
+1 for "gently see if". It's good that we have a few old-gcc animals, but
having versions of intermediate age is less important. Some owners will
decline, and that's okay.
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-bugs@postgresql.org
Cc: noah@leadboat.com, thomas.munro@gmail.com, semab.tariq@enterprisedb.com, sandeep.thakkar@enterprisedb.com, robertmhaas@gmail.com, x4mmm@yandex-team.ru, andres@anarazel.de, cm@enterprisedb.com, pgsql-bugs@lists.postgresql.org, michael@paquier.xyz, tgl@sss.pgh.pa.us, pg@bowt.ie
Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
In-Reply-To: <20211110035341.GC968057@rfd.leadboat.com>
* 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