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 1n8xNv-0004yH-7n for pgsql-hackers@arkaria.postgresql.org; Sun, 16 Jan 2022 04:43:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n8xNt-0004ZX-8U for pgsql-hackers@arkaria.postgresql.org; Sun, 16 Jan 2022 04:43:17 +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 1n8xNs-0004ZO-Tq for pgsql-hackers@lists.postgresql.org; Sun, 16 Jan 2022 04:43:16 +0000 Received: from mail-pf1-x42b.google.com ([2607:f8b0:4864:20::42b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n8xNl-0007yF-O7 for pgsql-hackers@postgresql.org; Sun, 16 Jan 2022 04:43:15 +0000 Received: by mail-pf1-x42b.google.com with SMTP id i65so6625734pfc.9 for ; Sat, 15 Jan 2022 20:43:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=fsBQPUm/9uSjl9RZDLV78iIwVOL+uwuwT/z8AI50Vhs=; b=Xhrq2U2ySEHerFFWcj4u63lHGe0PQOiObTl3WPsT/u43H9UHpU0+MHvJKY45+0/9YX PUiCJnSvz0O3xyKlc/wAdDn0dpPxONlaqSg/Sql3aLWfB/IrP4dyrGEzXP4ZTcXD2Gtk hz8RygI0dinNmDC6wqXoqxrlLLzXCuTNoMRFYwpJysvna2ydejz/Q5PmbZwVHKhYaGYE kJsuPEidCX8SfZ/9CktuKboa40HS/DEATT+/V/dgxcwDN25WRxPRsc2qfkiGDoLzoXgq HE3/hlABhydr9J/uPhsjQURQUN2uzZGJukRWBe6QLr21+ktdYP2H3OihIis93nfpf5P7 18PA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=fsBQPUm/9uSjl9RZDLV78iIwVOL+uwuwT/z8AI50Vhs=; b=bQRuaLgy9+AtYf1ljB4RPcDCgHWlhZ9KU0+b4U2a0c+FG1S/3FOrODFRias49T8SHR yGDmgS8g1a6eyy39yjYHu87bqgSYtJ13pgJuTaFJjMAhXM4L+VPbNziEVtExmn9t8fMu wI7Qk/wND+JqTmc31paPRdj5fO//nNWWAdrNr0Nc4cHv8srLdHb5CPwS4xNNK/OyYTR1 GUarj+Mhh/75A88OvCRoMWIS6b+r2MIySCK854IERJkBdJJ/OxHVujhgf19RW6KwoAit nfokXVoSuLa7rvhT7HJcObxejeoyuy/0rANLE3Zxs+eOPs+8JvsnmurYmri2nX5qguU7 6g1g== X-Gm-Message-State: AOAM531oNlr3vBywfY87fqGyQAj4If4TDpOQCf2ow/75MyFhyqxrsL4+ S58d42+ULqpXACSbbY2q6RQ= X-Google-Smtp-Source: ABdhPJzuvD/9/EaBY2Xn4FOJR+JsABXkkE3dXWRGedVa/Da25TkZH02stQheTjWsu3Xj2LTq2882fg== X-Received: by 2002:a63:6b46:: with SMTP id g67mr13962070pgc.482.1642308188276; Sat, 15 Jan 2022 20:43:08 -0800 (PST) Received: from jrouhaud (1-171-185-43.dynamic-ip.hinet.net. [1.171.185.43]) by smtp.gmail.com with ESMTPSA id f7sm10500180pfe.210.2022.01.15.20.43.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 15 Jan 2022 20:43:06 -0800 (PST) Date: Sun, 16 Jan 2022 12:43:03 +0800 From: Julien Rouhaud To: Kyotaro Horiguchi Cc: pgsql-hackers@postgresql.org Subject: Re: standby recovery fails (tablespace related) (tentative patch and discussion) Message-ID: <20220116044303.yzdjpxjksnpryzzi@jrouhaud> References: <202111101214.buuhq756cbbs@alvherre.pgsql> <20211111.111352.621135863697850711.horikyota.ntt@gmail.com> <20211112.164327.1698785294524198152.horikyota.ntt@gmail.com> <20211224.192159.1530858517688558145.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20211224.192159.1530858517688558145.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Fri, Dec 24, 2021 at 07:21:59PM +0900, Kyotaro Horiguchi wrote: > Just a complaint.. > > At Fri, 12 Nov 2021 16:43:27 +0900 (JST), Kyotaro Horiguchi wrote in > > "" on Japanese (CP-932) environment. I didn't actually > > tested it on Windows and msys environment ...yet. > > Active perl cannot be installed because of (perhaps) a powershell > version issue... Annoying.. > > https://community.activestate.com/t/please-update-your-powershell-install-scripts/7897 I'm not very familiar with windows, but maybe using strawberry perl instead ([1]) would fix your problem? I think it's also quite popular and is commonly used to run pgBadger on Windows. Other than that, I see that the TAP tests are failing on all the environment, due to Perl errors. For instance: [04:06:00.848] [04:05:54] t/003_promote.pl ..... [04:06:00.848] Dubious, test returned 2 (wstat 512, 0x200) https://api.cirrus-ci.com/v1/artifact/task/4751213722861568/tap/src/bin/pg_basebackup/tmp_check/log/regress_log_020_pg_receivewal # Initializing node "standby" from backup "my_backup" of node "primary" Odd number of elements in hash assignment at /tmp/cirrus-ci-build/src/bin/pg_ctl/../../../src/test/perl/PostgreSQL/Test/Cluster.pm line 996. Use of uninitialized value in list assignment at /tmp/cirrus-ci-build/src/bin/pg_ctl/../../../src/test/perl/PostgreSQL/Test/Cluster.pm line 996. Use of uninitialized value $tsp in concatenation (.) or string at /tmp/cirrus-ci-build/src/bin/pg_ctl/../../../src/test/perl/PostgreSQL/Test/Cluster.pm line 1008. Use of uninitialized value $tsp in concatenation (.) or string at /tmp/cirrus-ci-build/src/bin/pg_ctl/../../../src/test/perl/PostgreSQL/Test/Cluster.pm line 1009. That's apparently the same problem on every failure reported. Can you send a fixed patchset? In the meantime I will switch the cf entry to Waiting on Author. [1] https://strawberryperl.com/