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 1nJEfI-0003jw-3x for pgsql-hackers@arkaria.postgresql.org; Sun, 13 Feb 2022 13:11:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nJEfH-0004mH-29 for pgsql-hackers@arkaria.postgresql.org; Sun, 13 Feb 2022 13:11:43 +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 1nJEfG-0004m7-PO for pgsql-hackers@lists.postgresql.org; Sun, 13 Feb 2022 13:11:42 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nJEfD-0002bn-Kh for pgsql-hackers@lists.postgresql.org; Sun, 13 Feb 2022 13:11:41 +0000 Received: by mail-ed1-x532.google.com with SMTP id s7so23297622edd.3 for ; Sun, 13 Feb 2022 05:11:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=message-id:date:mime-version:user-agent:subject:content-language :from:to:references:in-reply-to:content-transfer-encoding; bh=u7HCaOMmWPpS404eTRO4NQT5hofntOHO9UdMS0Y6jfw=; b=JZj40mV1ZMdnFG522kBx6En8Ah7wvR61GzDKGhSiuAZx9RjQXMKyonCKolgTHBjdoX sLuY4+a+epHIPlC8rOmABGKRoKHOkxRlzO3oScddK4vcoTFaGwbf06TxbLrL4I0XqfCJ Sa9yYWK5qOzYrS6wVnpXjhTHyNNINeGZKFNIXl/T39mp6cstsAZ18UVFL7fkjRWmtBqm D+pVJXdZNo6Xw2manBwSIraGCEXubPwjOv/Hzp21S1SH7OknUXrtTw2hs+eiG1oCyf7D 9k2dl0v8GNpGRc1pvM9GoTsRP8JFdW8fauTaBzC25gQze3u0bqfhIf+/BvqC6kd3snwv ZK2g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:from:to:references:in-reply-to :content-transfer-encoding; bh=u7HCaOMmWPpS404eTRO4NQT5hofntOHO9UdMS0Y6jfw=; b=FnttDKbZey+Ciq+a2tzDTnlwzkohkLfl6NZtzZR02Hhpvnbu4rHAWI8LpS0LKxQRni cvkfsm07Uw+fjr5PqKZSGKbMr8/hK5yvIXOOH2mzuOD0zWAsUZMcYejyIzXSRevMvX/b f0F+Mk9ZTVTIrgQQMF4nNkP4jHSiIhtx1nnhkJjWdJlTyIOiGiW7hWsrV+LiPbwrlmCd PqqZ+zkOGp7i0cntwrC5fEfzHtscZj368i132zI3BinOAcMujwBRxRvQfH0n06htehCt jxMHjFD0YwuET2K94/vmEvy+1kDMIbazWAucUeXzFo2JsBkmyUb2GKzYrjPreaQc7ZdM YC7A== X-Gm-Message-State: AOAM531tG3E/TW8al7LLfQkFTWxBHcPlhSxxl+1axJVOso+aIjXnTq91 Z03XkZeQyjhMj9332g4j2wYxWmDc8gad38GiTIRyiD0wQllD2MpDQq+pNoCPJpaEAh9fJVbJgOx tEUa+iQ7rfQFg0No+zyut6/6sGVqxMRTbzLIFCgMfrtsL7JzO1aw5hYAxzhWbm8CWX/d+u7N2PH R0MLcaIUXBvhYcDFDGgmXeYS5eOtkGxm+yBh6LsAUxgZGCBoPL6LVp X-Google-Smtp-Source: ABdhPJztZ2ejpmWBpgaTkza0ovC0v9sxp0ft+6rR9LqWkwwUudcV3grvX+/O5zDT7fKU/76bQWafSg== X-Received: by 2002:a50:cccb:: with SMTP id b11mr10934185edj.57.1644757898093; Sun, 13 Feb 2022 05:11:38 -0800 (PST) Received: from [10.137.0.19] (ip-86-49-251-241.net.upcbroadband.cz. [86.49.251.241]) by smtp.gmail.com with ESMTPSA id fn5sm570642ejc.179.2022.02.13.05.11.37 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 13 Feb 2022 05:11:37 -0800 (PST) Message-ID: <88e2315d-c99a-309b-145f-36be2be4d8a3@enterprisedb.com> Date: Sun, 13 Feb 2022 14:11:36 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.5.0 Subject: Re: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 1173, ... Content-Language: en-US From: Tomas Vondra To: Andres Freund , pgsql-hackers@lists.postgresql.org, Thomas Munro , pgsql-hackers References: <67b46634-6916-4e6a-15c4-fad43f2fa0c1@enterprisedb.com> In-Reply-To: <67b46634-6916-4e6a-15c4-fad43f2fa0c1@enterprisedb.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/13/22 13:27, Tomas Vondra wrote: > > ... > > BTW it's probably just a coincidence, but the cfbot does show a strange > failure on the macOS machine [1], as if we did not wait for all changes > to be applied by replica. I thought it's because of the issue with > tracking LSN for sequences [2], but this is with a reworked test that > does not do just nextval(). So I'm wondering if these two things may be > related ... both things happened on macOS only. > I take this back - this failure was just a thinko in the ROLLBACK test, I've posted an updated patch fixing this. regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company