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 1n8Pvt-0002bY-03 for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Jan 2022 17:00:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8Pvr-0006rM-A8 for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Jan 2022 17:00:07 +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 1n8Pvq-0006oY-Ub for pgsql-bugs@lists.postgresql.org; Fri, 14 Jan 2022 17:00:07 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n8Pvo-0000XJ-KJ for pgsql-bugs@lists.postgresql.org; Fri, 14 Jan 2022 17:00:05 +0000 Received: by mail-lf1-x132.google.com with SMTP id o12so15497777lfu.12 for ; Fri, 14 Jan 2022 09:00:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=VQmO+rAF+pd4qV4p58Wn5bc5vMGgGWyanhITh3a5g3s=; b=RU1M0tCljjYSnIz5lb/1zWFPchggKdr+jFWyWAaeqki5yz82ex3VepsBgUkfLhaakM IWqGd1kNhZtU5+34weqqvxuXhuHnLsKW/7y3PvnS++iI4NbHMK65xE/T5UIVBSTphkuW S1rGxwa8/khkPzeRj4w3zb30ZHVIi1BMP6FW40oUgX+N3RVK0HUyfbqKwOtxwxlV1572 2sUMZQnpVt1iZh+41IydJugrwVu9VcsfrehTbwiS7kYq8/SbZ/T6Ci6w51nOH+MOAHd8 buTj2sJ+luhhasULNRVR9gay6WKkF0pwHUqx4JlfGDvhyqywLVCYjJFMSo3F+1QkuNo1 AD9A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=VQmO+rAF+pd4qV4p58Wn5bc5vMGgGWyanhITh3a5g3s=; b=dyVh4ahog8IH/eB+2ZoDaE/MeAgQICVrjHg2gahKts8X7H+BMeIA/qOcokUpbA4y0h 2X9TKpQ81cwKSc236JTqKtVERTJal+xDUtzWdTz5uB4F2FcQrctwUuRlAZXYeewRjlJB KOe+emVdJIJmGC0dW0WqmUFq/q84islZnHozRzb9Dq3fvRyoqqbTMCKiHTf7v6cQYcjg KcWCkyqCFer4GG+0j38SL6v/NfRPi1+eQquEYc7CJLWlLTvGWt2eP5HFQjqIvTZLjcGx CmtTRGyf096DMZkbAd5i8y9CVx3V4OG4R6Wtgu/gzAXWw1ncHM233CNhOZ5qjOxSd5bi 4kGw== X-Gm-Message-State: AOAM533Ya3N4Soyjg87N3N2CA/SaxKLjjto35QcMWpGv5DpIBa9lTG3M dwqD+tW+iLKo6wn3ch6sVq4ffBvpZ6RB9A== X-Google-Smtp-Source: ABdhPJwAzPgg6f7Nq2U4zBG5Ejf5kwWF7q99IB0FOihq1LpL578w7+NHOQT+AhE/4sMG7H7NQvjJ7g== X-Received: by 2002:a19:e218:: with SMTP id z24mr7724349lfg.528.1642179602902; Fri, 14 Jan 2022 09:00:02 -0800 (PST) Received: from [1.0.0.7] ([178.155.6.39]) by smtp.gmail.com with ESMTPSA id d20sm459558lfn.247.2022.01.14.09.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 14 Jan 2022 09:00:02 -0800 (PST) Subject: Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum To: Andres Freund , Peter Geoghegan Cc: Dmitry Dolgov <9erthalion6@gmail.com>, Matthias van de Meent , PostgreSQL mailing lists References: <20211111030821.2xxl75qfkynaga4j@alap3.anarazel.de> <20211116023918.5g6d6izevronx76m@alap3.anarazel.de> <20211122175914.ayk6gg6nvdwuhrzb@alap3.anarazel.de> <20211122223436.ov3qa27pakxay6z7@alap3.anarazel.de> <20211211045710.ljtuu4gfloh754rs@alap3.anarazel.de> <20220112192508.vibr6o64h7sy7mbw@alap3.anarazel.de> <20220114021549.m6ugihzjmsunv3jd@alap3.anarazel.de> From: Alexander Lakhin Message-ID: <972d1b31-6ed8-6526-7c3d-5bdd4a01e5d9@gmail.com> Date: Fri, 14 Jan 2022 20:00:00 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.14.0 MIME-Version: 1.0 In-Reply-To: <20220114021549.m6ugihzjmsunv3jd@alap3.anarazel.de> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 14.01.2022 05:15, Andres Freund wrote: > On 2022-01-12 13:05:45 -0800, Peter Geoghegan wrote: >> On Wed, Jan 12, 2022 at 11:25 AM Andres Freund wrote: >>>> Any blockers? >>> I'm just struggling with / procrastinating on the commit message, tbh. The >>> whole issue is kinda complicated to explain... :/ > After struggling some more, I *finally* pushed the fix and the new assertions. > > > Thanks for the bug report, investigation, review, etc! Thank you, Andres and Peter, for the fix! It was a tough bug to crack for me. P. S. I'm not seeing the fix in REL_14_STABLE yet, but as soon as it will be committed I'm going to continue the concurrent installcheck testing. Best regards, Alexander