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 1qBpXV-0001dL-2W for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Jun 2023 04:33:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qBpXU-0002Zd-0x for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Jun 2023 04:33:52 +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 1qBpXT-0002ZU-OC for pgsql-hackers@lists.postgresql.org; Wed, 21 Jun 2023 04:33:51 +0000 Received: from mail-pf1-x42e.google.com ([2607:f8b0:4864:20::42e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qBpXR-003Mi2-6X for pgsql-hackers@postgresql.org; Wed, 21 Jun 2023 04:33:50 +0000 Received: by mail-pf1-x42e.google.com with SMTP id d2e1a72fcca58-6689430d803so1318343b3a.0 for ; Tue, 20 Jun 2023 21:33:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1687322028; x=1689914028; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=cjtKkRKvmqpLCBAbjGdVoW87luvBEdpNIOSL5wr1tqI=; b=ePzyGHns/AEI+6t7ka+Su1o8m4Md1jjCp8f5vQsgTYD3nJJGn6JNVFVZJ8EdRXKtFA rjAKe+rBUmyk3sMtygKPju+tru0pKADCuR+GbsjzAADG7fq7i57bWmMTz25gTylUndHw 8eKxu2JtyRM0a4aTJFf9yb5OhQhCQXGW+Gb+NEln+6TSBRV2TibN2R9ziGuxGXugRQN8 seIdmNY2Yuk3xFRZVPnj7u2pFxm8BU2tE4dtmSrGI4sRjIsan6KLqha9MirVW/qqgUcd fpxOTixzujc2T6pFtqGQ0r5UaXbFxfGCEgamY0iAPE+8Qg/Uvv+/2d3pVd5InVDVYJtn J9aQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687322028; x=1689914028; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=cjtKkRKvmqpLCBAbjGdVoW87luvBEdpNIOSL5wr1tqI=; b=THMgKkAafq+q8gzkAc1ciOYZpof/c4p1kydWq0YoVp49dVGV0uaoIvDc/npyABrTxL NpG7PhIXatfFoldpaWNjzsJr42hpXs9N4SRBTafX3Q2xqTXMJYcomkkxIXoUhhsJy3EL AALPc2EkofTNjtUKxaVadextBNEKLQhZlIam/SWrJPdJ7JLO/UN+db5+AZ001FvDK1w+ AdDHFxstkjDL50EBTXtCqjHlkogkUIgDBF2V5jCa2qyM7db6pKPPMs5qEF0qDcKlFK77 VZ/uv6FU4H2N9DilZeVPHcOJ/BCAXoeX7gBNUvOdAgONGqi5SJ9EkhI1K1LLRKUD6dRh W1Vw== X-Gm-Message-State: AC+VfDwYye3RSc1oBNFd1Z4DNqA7MIskvOIcW8A/1m6fjNEIsHim1O6K H79y86TwFSoUco/gaQ/8nCg= X-Google-Smtp-Source: ACHHUZ6l2bR3mqJ1eE2SB5iNgCYuayQnKgY8hB5yLo4cqebaGab/lZxIvIRqBxYoRcga3SMalhT/gA== X-Received: by 2002:a05:6a20:394d:b0:122:36eb:3315 with SMTP id r13-20020a056a20394d00b0012236eb3315mr5000516pzg.12.1687322028168; Tue, 20 Jun 2023 21:33:48 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id i20-20020aa79094000000b0065a1b05193asm2000826pfa.185.2023.06.20.21.33.47 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 20 Jun 2023 21:33:47 -0700 (PDT) Date: Tue, 20 Jun 2023 21:33:45 -0700 From: Nathan Bossart To: Michael Paquier Cc: Kyotaro Horiguchi , julian.markwort@cybertec.at, pgsql-hackers@postgresql.org Subject: Re: [BUG] recovery of prepared transactions during promotion can fail Message-ID: <20230621043345.GA787473@nathanxps13> References: <743b9b45a2d4013bd90b6a5cba8d6faeb717ee34.camel@cybertec.at> <20230619.144154.1628674635368115138.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jun 20, 2023 at 10:49:03AM +0900, Michael Paquier wrote: > And done for v13 and v14. I have split the test and comment changes > into their own commit, doing that for v13~HEAD. I've started seen sporadic timeouts for 009_twophase.pl in cfbot, and I'm wondering if it's related to this change. https://api.cirrus-ci.com/v1/task/4978271838797824/logs/test_world.log https://api.cirrus-ci.com/v1/task/5477247717474304/logs/test_world.log https://api.cirrus-ci.com/v1/task/5931749746671616/logs/test_world.log https://api.cirrus-ci.com/v1/task/6353051175354368/logs/test_world.log https://api.cirrus-ci.com/v1/task/5687888986243072/logs/test_world.log -- Nathan Bossart Amazon Web Services: https://aws.amazon.com