Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t2xdQ-0090bW-6q for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Oct 2024 19:00:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t2xdN-00AeL7-JS for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Oct 2024 19:00:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t2xdN-00AeKy-9n for pgsql-hackers@lists.postgresql.org; Mon, 21 Oct 2024 19:00:05 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t2xdL-002Ghn-Ib for pgsql-hackers@postgresql.org; Mon, 21 Oct 2024 19:00:05 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-539e59dadebso6101823e87.0 for ; Mon, 21 Oct 2024 12:00:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729537203; x=1730142003; darn=postgresql.org; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=ZEi0ytUTGdjg++35EEQZzZR7SGoRyBOevagR5xAeWKA=; b=J/UZj9paMjlPkqhtJLLmseVGyfDvEz2oHsyzoqufA1ZsDZBhALaBF2CYsN3oBlWKDk asArhoCQFRf5W7ZbW1g2wkqmvYJ64c+BiSfPu6NFgQR/vpvwzqN2SXNTH4e1KY7lJffP NUvyEYjKaJ03twYURHY77GICtd+3nVtsYAq5e8Jq2PUeMixPEbhOX+oOEMkxAbYkcjh+ 8jhAwhmwnoppiBab15LgzcZeiibMTLzABrC5oV9wJJyIVTXxTfWxg1r3IVQuQ/XhXuiA uWi+3IuXheHozm3CM0Arg48UnOj+fNgvu+EkQ7RxmRbZpQ1jS4xRyczdkZgRp6Tp/mJ+ 2eVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729537203; x=1730142003; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=ZEi0ytUTGdjg++35EEQZzZR7SGoRyBOevagR5xAeWKA=; b=kckX9gBVVxhPEFJE7oNNaEfhnPcjEiPzexzeHf1sLXQeH1DNJxYRi9cqOgr7R9pXnf 4CMHLWiERYsbABn0egpyeaK/RPhbU/1nAjscQ1GbyY4KTnM81bpQb7Eh3jZM8qU5ZHfo nLMlxxmmuWW9XIBTh+owks9T8Y6SAMct4646sSxSLeQtH0BWqcwit4mbcRJiJxv6vv9W BxxgUCLMAzqNWa9NNejgHX2gin+S51n8UKzgWDP5t3dT515Jhb2vBsudXJF7NdaHY6pt DiePuOuaZHK63mXcHHYCdwnoWBxBWirQR50cb4Nk1nAdqffmQJ1YJzTegm6U3AxhPdMT Vdxw== X-Forwarded-Encrypted: i=1; AJvYcCWnS/aAFqZA5n710m57l8KOPltm9WIyM1NuuTzuyKYGjk3b7jBfa7/YAtVEaZou2UCjJJCNmFKbVYC93iyR@postgresql.org X-Gm-Message-State: AOJu0YyFhAkUU2rQZZ7XHJhuuB9kPHGdgrgPZKsU3gGKOn/FAVamn/yC DTpIoav+ycS1ASsaGyMpLAkiR/Kcq6aQMu4U/o4v0HSUdwHNoiy1 X-Google-Smtp-Source: AGHT+IEagG5RmoDwWfn52fBsJ0n32eQPeyqWbEhKFHOaao5Skuc4pc/om5X9VcJCVzrpVJv3biqsfg== X-Received: by 2002:a05:6512:2352:b0:539:e94d:b490 with SMTP id 2adb3069b0e04-53a1544c27fmr5733555e87.43.1729537202314; Mon, 21 Oct 2024 12:00:02 -0700 (PDT) Received: from [1.0.0.7] ([178.155.17.174]) by smtp.gmail.com with ESMTPSA id 2adb3069b0e04-53a223e54f3sm539330e87.4.2024.10.21.12.00.00 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 21 Oct 2024 12:00:01 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------Bl0sAphrH4PcNgZxIgDqpPRF" Message-ID: <6c92f59b-f5bc-e58c-9bdd-d1f21c17c786@gmail.com> Date: Mon, 21 Oct 2024 22:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: race condition in pg_class Content-Language: en-US To: Noah Misch Cc: Nitin Motiani , Heikki Linnakangas , Robert Haas , pgsql-hackers@postgresql.org, Tom Lane , Smolkin Grigory , Michael Paquier References: <20240903212329.61.nmisch@google.com> <20240904195720.cf.nmisch@google.com> <20240905220434.80.nmisch@google.com> <20240906185531.48.nmisch@google.com> <20240919213346.0a.nmisch@google.com> <20240924224352.93.nmisch@google.com> From: Alexander Lakhin In-Reply-To: <20240924224352.93.nmisch@google.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Bl0sAphrH4PcNgZxIgDqpPRF Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hello Noah, 25.09.2024 01:43, Noah Misch wrote: > Pushed, but the pushes contained at least one defect: > Please look at an anomaly introduced with a07e03fd8. With the attached modification for intra-grant-inplace.spec, running this test triggers a Valgrind-detected error for me: ==00:00:00:09.624 319033== Conditional jump or move depends on uninitialised value(s) ==00:00:00:09.624 319033==    at 0x25D120: DoesMultiXactIdConflict (heapam.c:7373) ==00:00:00:09.624 319033==    by 0x25B45A: heap_inplace_lock (heapam.c:6265) ==00:00:00:09.624 319033==    by 0x27D8CB: systable_inplace_update_begin (genam.c:867) ==00:00:00:09.624 319033==    by 0x33F717: index_update_stats (index.c:2856) ==00:00:00:09.624 319033==    by 0x33FEE2: index_build (index.c:3106) ==00:00:00:09.625 319033==    by 0x33C7D3: index_create (index.c:1276) ==00:00:00:09.625 319033==    by 0x451000: DefineIndex (indexcmds.c:1216) ==00:00:00:09.625 319033==    by 0x48D091: ATExecAddIndex (tablecmds.c:9156) ==00:00:00:09.625 319033==    by 0x483F8E: ATExecCmd (tablecmds.c:5302) ==00:00:00:09.625 319033==    by 0x483877: ATRewriteCatalogs (tablecmds.c:5186) ==00:00:00:09.625 319033==    by 0x482B9A: ATController (tablecmds.c:4741) ==00:00:00:09.625 319033==    by 0x4827A1: AlterTable (tablecmds.c:4387) ==00:00:00:09.625 319033== Perhaps current_is_member in heap_inplace_lock() should be initialized before the DoesMultiXactIdConflict() call as in other places... Best regards, Alexander --------------Bl0sAphrH4PcNgZxIgDqpPRF Content-Type: text/x-patch; charset=UTF-8; name="intra-grant-inplace-mod.patch" Content-Disposition: attachment; filename="intra-grant-inplace-mod.patch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L2lzb2xhdGlvbi9zcGVjcy9pbnRyYS1ncmFudC1pbnBs YWNlLnNwZWMgYi9zcmMvdGVzdC9pc29sYXRpb24vc3BlY3MvaW50cmEtZ3JhbnQtaW5wbGFj ZS5zcGVjCmluZGV4IDI5OTJjODViNDQuLjMzMzljOWY0MDAgMTAwNjQ0Ci0tLSBhL3NyYy90 ZXN0L2lzb2xhdGlvbi9zcGVjcy9pbnRyYS1ncmFudC1pbnBsYWNlLnNwZWMKKysrIGIvc3Jj L3Rlc3QvaXNvbGF0aW9uL3NwZWNzL2ludHJhLWdyYW50LWlucGxhY2Uuc3BlYwpAQCAtOTAs OSArOTAsOSBAQCBwZXJtdXRhdGlvbgogCiAjIGlucGxhY2Ugd2FpdCBOTyBLRVkgVVBEQVRF IHcvIEtFWSBTSEFSRQogcGVybXV0YXRpb24KLQlrZXlzaHI1CiAJYjMKIAlzZm5rdTMKKwlr ZXlzaHI1CiAJYWRkazIocjMpCiAJcjMKIAo= --------------Bl0sAphrH4PcNgZxIgDqpPRF--