Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mg61u-0003kc-Ke for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Oct 2021 14:05:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mg61s-0001mf-Bh for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Oct 2021 14:05:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mg61r-0001mW-Sl for pgsql-bugs@lists.postgresql.org; Thu, 28 Oct 2021 14:05:16 +0000 Received: from mail-qk1-x72c.google.com ([2607:f8b0:4864:20::72c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mg61l-00074T-3H for pgsql-bugs@lists.postgresql.org; Thu, 28 Oct 2021 14:05:15 +0000 Received: by mail-qk1-x72c.google.com with SMTP id bi29so5858551qkb.5 for ; Thu, 28 Oct 2021 07:05:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=wTTxU6HB8pj6ms4nNMVfZvKMd3RkXySZkFdFXbOvoyY=; b=Y7d0s15eOOAp8ZPaZ0ibYF7TuprVlBeEtsUVx2nYWaKr3mf7kXS1kKZnrHyUYK2k+P rCvWmbpDNRApqxqLiXL0o4C1Z1HC3yZ3OVz1BtUA+5SvNwW/gGNG3yLeTnKBUuWYO/Pe hbHylXS7JYlszPvTK9drbnR/qUPb8SHZV3Q0s= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=wTTxU6HB8pj6ms4nNMVfZvKMd3RkXySZkFdFXbOvoyY=; b=EhZ1yRTcfB/3eblm4TQTN95kTSi20XMNKxNO3FpxX8OmUnuFGkHdppBvAMDA2zY5ps ZDaHXs/hQVnNf9RL2/nSWFq5aXDdkqJ5qINabs/3pVIT56UHz1F+u2G69rNrJRY+moMQ vjQCaSl6In9LWRDtjNqniRG444F6XzRNuIIQ8RYxYUoh28QCiqnxbhEkUhSs+GySOZU6 N8YD0ivfkoK2tPvcqZazrMyumAno13lAadYLO1vIeEyvWSfsEAtQyP+f7yV4OWyG0vKF y1LC4fReTsAQ/vpSCdGIZif84tCq/ZDtoBeTwvc9u8MTkahEwsQvK/A2Te8QWutoeF5a 6LQw== X-Gm-Message-State: AOAM5325ZlpulJ+MO0cz9/MkkM4Xmzp+lrUyoiXgGx+VZ9zJajO9MXPU L9GHX4KqLsJ+1AtleQaolRYIhA== X-Google-Smtp-Source: ABdhPJyJ0pa8iNlgd5Bl9NigHhyNZ+8Bk+4e44FwXCO9uJMK9Fe/C3+XfoWiWLBAS41k5wExoP3XqQ== X-Received: by 2002:a05:620a:430a:: with SMTP id u10mr3617451qko.53.1635429907299; Thu, 28 Oct 2021 07:05:07 -0700 (PDT) Received: from rfd.leadboat.com ([2600:1702:a20:5750::46]) by smtp.gmail.com with ESMTPSA id x15sm2059902qkp.113.2021.10.28.07.05.02 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 28 Oct 2021 07:05:03 -0700 (PDT) Date: Thu, 28 Oct 2021 07:04:59 -0700 From: Noah Misch To: cm@enterprisedb.com Cc: PostgreSQL mailing lists , Michael Paquier , Tom Lane , Peter Geoghegan , Andres Freund , Andrey Borodin Subject: Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data Message-ID: <20211028140459.GA284584@rfd.leadboat.com> References: <364BAA98-1A3F-4C39-B0D9-ED8C40EA902D@yandex-team.ru> <20210908064515.GA2496820@rfd.leadboat.com> <20210920044143.GA3414844@rfd.leadboat.com> <593C6C66-F19E-412A-9896-F1F5B272424A@yandex-team.ru> <20210925201012.GC4134968@rfd.leadboat.com> <20211017151205.GA2384251@rfd.leadboat.com> <9BA43784-E4A7-4638-900C-FC9868C388FA@yandex-team.ru> <20211019030212.GB3403374@rfd.leadboat.com> <20211024050028.GA3310519@rfd.leadboat.com> <20211024233502.GA3960658@rfd.leadboat.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20211024233502.GA3960658@rfd.leadboat.com> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, Oct 24, 2021 at 04:35:02PM -0700, Noah Misch wrote: > On Sat, Oct 23, 2021 at 10:00:28PM -0700, Noah Misch wrote: > > Pushed. > > cm@enterprisedb.com, could you post a stack trace from buildfarm member > gharial failing in "make check"? I'm looking for a trace from a SIGSEGV like > those seen today: > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=gharial&dt=2021-10-24%2016%3A19%3A05 > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=gharial&dt=2021-10-24%2020%3A38%3A39 > > Those SIGSEGV are all in ALTER TABLE. My commits from this thread probably > broke something, but I've run out of ideas, and my hpux boxes died. cm@enterprisedb.com, is this still in your queue, or not? I am somewhat concerned that the 2021-11-11 releases will contain a regression if the gharial failures remain undiagnosed. I don't know how to diagnose them without your help. (I currently can't justify reverting the suspect bug fix on the basis of two master-branch-only failures in one buildfarm member.)