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 1mm3sP-0004LA-Bw for pgsql-bugs@arkaria.postgresql.org; Sun, 14 Nov 2021 01: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 1mm3sO-0002x5-B4 for pgsql-bugs@arkaria.postgresql.org; Sun, 14 Nov 2021 01:00:08 +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 1mm3sO-0002wr-2y for pgsql-bugs@lists.postgresql.org; Sun, 14 Nov 2021 01:00:08 +0000 Received: from mail-lj1-x22f.google.com ([2a00:1450:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mm3sK-0002bT-KB for pgsql-bugs@lists.postgresql.org; Sun, 14 Nov 2021 01:00:07 +0000 Received: by mail-lj1-x22f.google.com with SMTP id t11so26690463ljh.6 for ; Sat, 13 Nov 2021 17:00:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=5ao2Ud37vvZYz47/sjaKDiVTZj1Nxx6fjorPdZs1aUE=; b=ol+Egiejj8VrnteHZHQEcQyWBV/xApycObe7fefNZcZo22AM3XL9oZ2+ktWPUUGERc eYc7dyrCd30UyvfULaxDWTjvZWr6tgD/tKFujntNRZ5mtz/2dnaDgaMBcDJFUhEVtIgP +yoOeNqs9WGOrwuRnkNcUwvWgJcuMEnf9WYM4NBVNYAhYs5erhdTpISQFH06J/TYOZMu tg+6m08KYxxgnruLcBpLDv2CLmlgPb0omndkRR4MyH1CNMZXg9djKpwyjW2e6zPngjAM GpgX2GEtqSnyGOPm5llTx0anB53iMiDvEXbfgmxa7BsLhF5dQnTUZvPmZlppVr3Q9WoJ fAJA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=5ao2Ud37vvZYz47/sjaKDiVTZj1Nxx6fjorPdZs1aUE=; b=dy1Cqe3apjirAk4McVtNhucUZR2fNJtv+tL3QPQAzFpyHltnuVQEXiAx8CowVNrTq7 oNfsBA5aeOGCAivpxQhzS9y5+kEi5/tCD1zHzrs6/qV57nH8uXkMYsJTdWOYTBl05epe JU/d16PLAZAvCWPRbEEGi1veZkQkPLpyOB9Zxm9luBM3EabPT+DEXTFU+T5AcdOpX00e Nu+R+dtGaR+ud2UJu4UKxeJrR2QaQyX+HiUnTBhMlftNCO9fe1F5Ycg5PdnPdiy4Rv9H zIElWZOaKXYUhJzADkQkhhs6CrlKn6fS8pTnl05Z3xasOOzD6xlDZg5Iqjwu38LbAFad +XKw== X-Gm-Message-State: AOAM533Qup5tJ9yC+ZMGvJZ0E4NiiFTnBkwzBNba23prjiW9QobUV1IC 6cQtpxBnnC6AkkiElnEc/X/Z47xh8c4= X-Google-Smtp-Source: ABdhPJz0LzdpSoftyFXtWatNcVTZKdCJLLfugDvKm7j3X5b6E+lJTJP3M1cn2Dmhp4wKi6fPSaCymg== X-Received: by 2002:a2e:874b:: with SMTP id q11mr1566565ljj.194.1636851603053; Sat, 13 Nov 2021 17:00:03 -0800 (PST) Received: from [1.0.0.7] ([178.155.6.194]) by smtp.gmail.com with ESMTPSA id h1sm641805lfm.197.2021.11.13.17.00.02 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 13 Nov 2021 17:00:02 -0800 (PST) Subject: Re: BUG #17284: Assert failed in SerialAdd() when the summarize_serial mode is engaged To: Thomas Munro , PostgreSQL mailing lists References: <17284-c878f548184aae1f@postgresql.org> From: Alexander Lakhin Message-ID: <8583d198-46f2-57db-c7f5-97d285c0e51f@gmail.com> Date: Sun, 14 Nov 2021 04:00:00 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: 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 Hello Thomas, 13.11.2021 21:23, Thomas Munro wrote: > On Sun, Nov 14, 2021 at 1:35 AM PG Bug reporting form > wrote: >> It can be easily reproduced on the build made with 'CPPFLAGS="-O0 >> -DTEST_SUMMARIZE_SERIAL"' by the following script (based on the simplified >> script by Thomas Munro from bug#17116): > I assume from the separate bug report that this fails even if you > apply the patches from that other thread? > > https://www.postgresql.org/message-id/flat/17116-d6ca217acc180e30%40postgresql.org Yes, applying patches v4-0001-Fix-assert-failures-in-parallel-SERIALIZABLE-READ and v4-0002-Fix-race-in-SERIALIZABLE-READ-ONLY from that thread doesn't affect this assert (tested on the master branch). Best regards, Alexander