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 1kF7vr-0001nW-74 for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Sep 2020 03:35:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kF7vq-00018c-2B for pgsql-hackers@arkaria.postgresql.org; Mon, 07 Sep 2020 03:35:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kF7vp-00017m-RY for pgsql-hackers@lists.postgresql.org; Mon, 07 Sep 2020 03:35:01 +0000 Received: from mail-io1-xd2a.google.com ([2607:f8b0:4864:20::d2a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kF7vj-0001OR-2n for pgsql-hackers@postgresql.org; Mon, 07 Sep 2020 03:35:00 +0000 Received: by mail-io1-xd2a.google.com with SMTP id m17so12649905ioo.1 for ; Sun, 06 Sep 2020 20:34:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=wQuy+afixhXYeGDPc3fXhxa+DUFnM1i47GbbuGK/SeA=; b=EwQ4qMyVPE1Ey6Qm1F6oSbR6yijL1IOhzozV+kLXPsYjLWUMRdI7P774gveiA2C/is BhlnYWNfaZt7LJLZKzaYzQafJjAI8/N1UsBzgtpl+5DEtdY+sAmNI06YwKZ9UdSRqFH0 Qd/vVfDZziXIuj5cWGJyhrcOUURHGsityV0m2nqjPYm61nXLxUEAVxGapuWfmO/Lr67K BsVhxvNVJwGKWmM+XT9DhBD0vWg6yQDu03xv4WiuBxFAvuAsiemLZxoADRlFFLu3fQcA vdmPWtx8sLkVmp61SNKK8z9n8OKLFPCDx93WlHH3/riDWwp/EryH9BWW7VA+7pvf6k9y soTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=wQuy+afixhXYeGDPc3fXhxa+DUFnM1i47GbbuGK/SeA=; b=CAbzVTXh/BIsC3haOkPfv0ZdbcTQo1098Uba4794gmRbWkGvIgpwOHJaK3qrOFUF8/ Dr79nq3SpzhqvdcQxUasCzxBlck/+CVT3m2fcUiwuXhkvHlmfZBbgMOADr5bmJfdfkz8 ZcSnCL76ZJInP3yzKmqQMpJy+Hk3uTxrUCN5JR9LlkLNPD6BPIdUGEEbTvz7W81I9F6u k1S+19zYtyeBSiGWE59MPUIsnLB1EwubNTWZUGWim2RXRrjtt7X9EPlK/jKXSG+aU2bH necwYb/fcka24BajPUofYOM7oQjlfklsB4amia8X7G0hp/3WhSoVzRhOleEgBaZmrQQL INGA== X-Gm-Message-State: AOAM530j5T/lAXB330DmR8CQ9J/o1lmjJUZNRsf2DhXLAW3kCPUvOvep hsZLJVhuNWQu+OvEFMWLMwF9dg== X-Google-Smtp-Source: ABdhPJwCT00sq05NxSDDPmr5MJNrLWnqxPXDEwwkelbTvOunqzjmYqNm83emsOsFcf2G3LboyUj84A== X-Received: by 2002:a02:778e:: with SMTP id g136mr18345491jac.49.1599449694220; Sun, 06 Sep 2020 20:34:54 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id x1sm7541876ilo.50.2020.09.06.20.34.53 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 06 Sep 2020 20:34:53 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 141F48005ED; Sun, 6 Sep 2020 22:34:52 -0500 (CDT) Date: Sun, 6 Sep 2020 22:34:51 -0500 From: Justin Pryzby To: pgsql-hackers@postgresql.org Cc: Noah Misch , Kyotaro Horiguchi Subject: Re: v13: CLUSTER segv with wal_level=minimal and parallel index creation Message-ID: <20200907033451.GB7158@telsasoft.com> References: <20200907023737.GA7158@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200907023737.GA7158@telsasoft.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is easily reproduced, at least on pg_attribute [pryzbyj@localhost ~]$ /usr/pgsql-13/bin/initdb -D pgsql13.dat [pryzbyj@localhost ~]$ /usr/pgsql-13/bin/postgres -D pgsql13.dat -c logging_collector=off -c port=5678 -c unix_socket_directories=/tmp -c wal-level=minimal -c max_wal_senders=0& [pryzbyj@localhost ~]$ psql -h /tmp -p 5678 postgres -c "SET min_parallel_table_scan_size=0" -c "SET client_min_messages=debug" -c "REINDEX INDEX pg_attribute_relid_attnum_index" SET SET DEBUG: building index "pg_attribute_relid_attnum_index" on table "pg_attribute" with request for 1 parallel worker TRAP: FailedAssertion("relcache_verdict == RelFileNodeSkippingWAL(relation->rd_node)", File: "relcache.c", Line: 2976) postgres: parallel worker for PID 9637 (ExceptionalCondition+0x66)[0x921d86] postgres: parallel worker for PID 9637 (AssertPendingSyncs_RelationCache+0x1db)[0x91a08b] postgres: parallel worker for PID 9637 (smgrDoPendingSyncs+0x71)[0x58e591] postgres: parallel worker for PID 9637 [0x53b1a4] postgres: parallel worker for PID 9637 (EndParallelWorkerTransaction+0x16)[0x53b826] postgres: parallel worker for PID 9637 (ParallelWorkerMain+0x437)[0x52fcf7] postgres: parallel worker for PID 9637 (StartBackgroundWorker+0x25a)[0x76047a] postgres: parallel worker for PID 9637 [0x76d88d] postgres: parallel worker for PID 9637 [0x76e43e] /lib64/libpthread.so.0(+0xf630)[0x7f46d4b47630] /lib64/libc.so.6(__select+0x13)[0x7f46d26ba983] postgres: parallel worker for PID 9637 [0x4887bc] postgres: parallel worker for PID 9637 (PostmasterMain+0x1165)[0x76fb45] postgres: parallel worker for PID 9637 (main+0x70d)[0x48a83d] /lib64/libc.so.6(__libc_start_main+0xf5)[0x7f46d25e7555] -- Justin