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 1nZrBL-0002nG-Gp for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Mar 2022 09:33:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nZrBK-000687-EC for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Mar 2022 09:33:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nZrBJ-00067x-UI for pgsql-hackers@lists.postgresql.org; Thu, 31 Mar 2022 09:33:30 +0000 Received: from mail-pf1-x42b.google.com ([2607:f8b0:4864:20::42b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nZrBE-0003Fl-Op for pgsql-hackers@lists.postgresql.org; Thu, 31 Mar 2022 09:33:29 +0000 Received: by mail-pf1-x42b.google.com with SMTP id u22so21445707pfg.6 for ; Thu, 31 Mar 2022 02:33:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:message-id:to:cc:subject:from:in-reply-to:references :user-agent:mime-version:content-transfer-encoding; bh=W7wVi95bzl7GNZ4nx79FWzcuKThfeqh5f5qGGZijAWM=; b=c7T8N9I4jprFuZIks98a8Q7NU9YZol9qbNKjbZK75N/zyTYFyGk/grySp6Ndd+T/Ad ncMHudZDkHYcDFwoX8ZBggAypUjOTjTQK7n2EA1l73GHCbNfF43yxVotIYzUqqdMQo4e aoXQ4eX9LaiD1EfUJSpDZXMBv8FeAMv7iqf8CM67mpCMi05ca4YjWDf/cfX4Dl58HSgp AyYyn668MfRkey2pFGF6wqfXwXNnYeqhAU0SZPx6YlAvSlUuBTTPcK4tFiijxMSmgQ5K 9wKSHnMiWKgy7FQ92RLNIEeDfCEvAcYcQI8VxpMM2Se6ypvcSf9Xo6YUEQF8g1LqAZS8 06uA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:message-id:to:cc:subject:from:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=W7wVi95bzl7GNZ4nx79FWzcuKThfeqh5f5qGGZijAWM=; b=jTmN2W9602vMXBqwRE9kR+0F0CJ+1VUxtZ54/p8p+bSNz79Q6TVwf0nqh6c/tJ9k91 gY7TE69OIXdPOE7bHkX7UIB4Nszfc5s1J0TwX44vCbIQfu42qmi8tC6ETpAtf8OhBhrw 3T0zvwwaI+wK82V/0DI5hM0PQw0Q6Zlrumos/v7mw7sPh1CnbPKJ6RjxvI1amgtYyTZf DbBtbbwsJh1Pzo2UN2+vyPywWxTmRpVXDSpJpZxuSdekpMNdwNBPvdVIlXwNRAkFC5bL dEWUx5JaJaI7QdhgcKpoYJbULs1nk4hTjSj7zGZOkIBs88gWr8q8t5WCKMU9ywrRSuaq 1jKQ== X-Gm-Message-State: AOAM531NTBR+luB5qTWMXIM60Xh0o8SGvza9W8IokK/Y9GVhgYM1zFp4 gJqv2xzMVqpBmE9P40zLsyE= X-Google-Smtp-Source: ABdhPJyaoMMSdaqVlkLaqMao6S9ikKv3KCp1M0CRuTdPsFc6iyUhreXi9kvXkbRybuiUtP3zLnhI5A== X-Received: by 2002:a05:6a00:23d2:b0:4fa:f262:719 with SMTP id g18-20020a056a0023d200b004faf2620719mr4632255pfc.4.1648719202279; Thu, 31 Mar 2022 02:33:22 -0700 (PDT) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id z2-20020aa79902000000b004fb05c04b53sm25227812pff.103.2022.03.31.02.33.19 (version=TLS1_3 cipher=TLS_CHACHA20_POLY1305_SHA256 bits=256/256); Thu, 31 Mar 2022 02:33:21 -0700 (PDT) Date: Thu, 31 Mar 2022 18:33:18 +0900 (JST) Message-Id: <20220331.183318.1550548268473692904.horikyota.ntt@gmail.com> To: pryzby@telsasoft.com Cc: tgl@sss.pgh.pa.us, rjuju123@gmail.com, jakub.wartak@tomtom.com, pgsql-hackers@lists.postgresql.org Subject: Re: In-placre persistance change of a relation From: Kyotaro Horiguchi In-Reply-To: <20220331053707.GK28503@telsasoft.com> References: <20220330134402.GF28503@telsasoft.com> <20220331.135845.1011177858609779865.horikyota.ntt@gmail.com> <20220331053707.GK28503@telsasoft.com> User-Agent: Mew version 6.8 on Emacs 26.1 Mime-Version: 1.0 Content-Type: Multipart/Mixed; boundary="--Next_Part(Thu_Mar_31_18_33_18_2022_007)--" Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ----Next_Part(Thu_Mar_31_18_33_18_2022_007)-- Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit At Thu, 31 Mar 2022 00:37:07 -0500, Justin Pryzby wrote in > On Thu, Mar 31, 2022 at 01:58:45PM +0900, Kyotaro Horiguchi wrote: > > Thanks! Version 20 is attached. > > The patch failed an all CI tasks, and seems to have caused the macos task to > hang. > > http://cfbot.cputube.org/kyotaro-horiguchi.html > > Would you send a fixed patch, or remove this thread from the CFBOT ? Otherwis e > cirrrus will try to every day to rerun but take 1hr to time out, which is twice > as slow as the slowest OS. That is found to be a thinko that causes mark files left behind in new database created in the logged version of CREATE DATABASE. It is easily fixed. That being said, this failure revealed that pg_checksums or pg_basebackup dislikes the mark files. It happens even in a quite low possibility. This would need further consideration and extra rounds of reviews. > I think this patch should be moved to the next CF and set to v16. I don't think this can be commited to 15. So I post the fixed version then move this to the next CF. regards. -- Kyotaro Horiguchi NTT Open Source Software Center ----Next_Part(Thu_Mar_31_18_33_18_2022_007)-- Content-Type: Text/X-Patch; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="v21-0001-In-place-table-persistence-change.patch"