Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1j7a9I-0004cu-2P for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Feb 2020 07:33:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j7a9G-0005If-Rd for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Feb 2020 07:33:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j7a9G-0005IW-IH for pgsql-hackers@lists.postgresql.org; Fri, 28 Feb 2020 07:33:26 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j7a9E-0004vT-VE for pgsql-hackers@lists.postgresql.org; Fri, 28 Feb 2020 07:33:26 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 979DD5F1; Fri, 28 Feb 2020 02:33:22 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 28 Feb 2020 02:33:22 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=uYJz0fkhl/rC/+ONUFZrkwxC/y9 eZlVmXJyalNmMvwM=; b=OVG+pKxq/PBhODO8AeKe3ccJmiySafBdNCLZbXclYIs Bz37ZjfoW1IdZC0lsC/CiZ/VZC1lzhnHL67nJE8GpQlkxLqYTcL2VdzAR1os93c4 OX7NI+g/WicI/k2T1CcU/oMycTel5LHiLh5+a/Xh3ImajVhhCIy747SkLHZQmwGT DC7IydCJiRWm7Vl83/ng20+In4W5UJ2cg/87VZoXq0uGzAAIq6jsynlh/ISqQvYg jlDQRySVasB9FAT2pvSbr3yNDBKc4/6BF8NLyk+PSKAalaAhUZSN+eUR/ApRUyds hTXQ5W/cgiyz3JVKSXqVYvM/qQZfzGAxYLji0wMsZCA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=uYJz0f khl/rC/+ONUFZrkwxC/y9eZlVmXJyalNmMvwM=; b=p1cpNHu7MYbtvmDrV5iTtq 2NGgaxSB9vr2OL1QEFLY6B5E+mtheu5Gw6RcEI7Hwtim/gpDpHzUYjezm0b8M1AW 8XtrfK+khJ4Mrr1NSTMi+6KWUZwGVvB/p2L/h5gXjDwGGI2H3yK4fELfxrQu7Htw MdkhGtE3iFdm7zXcCjCCkOCjRXZNWnFVjpMzgjEOX1fype0sQtl3lDlkE8uG1Y+s WUcWUfpsKE6GJ8X+cuglKaQxyL7hqC9P55e2NfBBPYP+hQ5g3m2Gmvuz4bVOSaLp Ty0y7+sBoCFfcoTuSKdDCfqZWPbmiQsSUAXhSueNQkJ5zKTc1F/NN2rZxkbriv4w == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrleejgdduuddtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucfkphepudduuddrud dtvddrudektddrudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 095913280059; Fri, 28 Feb 2020 02:33:20 -0500 (EST) Date: Fri, 28 Feb 2020 16:33:18 +0900 From: Michael Paquier To: Kyotaro Horiguchi Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Make mesage at end-of-recovery less scary. Message-ID: <20200228073318.GD2688@paquier.xyz> References: <20200228.160100.2210969269596489579.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="gE7i1rD7pdK0Ng3j" Content-Disposition: inline In-Reply-To: <20200228.160100.2210969269596489579.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --gE7i1rD7pdK0Ng3j Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Feb 28, 2020 at 04:01:00PM +0900, Kyotaro Horiguchi wrote: > Hello, this is a followup thread of [1]. >=20 > # I didn't noticed that the thread didn't cover -hackers.. >=20 > When recovery of any type ends, we see several kinds of error messages > that says "WAL is broken". Have you considered an error context here? Your patch leads to a bit of duplication with the message a bit down of what you are changing where the end of local pg_wal is reached. > + * reached the end of WAL. Otherwise something's really wrong and > + * we report just only the errormsg if any. If we don't receive This sentence sounds strange to me. Or you meant "Something is wrong, so use errormsg as report if it is set"? > + * Note: errormsg is alreay translated. Typo here. > + if (StandbyMode) > + ereport(actual_emode, > + (errmsg ("rached end of WAL at %X/%X on timeline %u in %s during stre= aming replication", StandbyMode happens also with only WAL archiving, depending on if primary_conninfo is set or not. > + (errmsg ("rached end of WAL at %X/%X on timeline %u in %s during crash = recovery", FWIW, you are introducing three times the same typo, in the same word, in three different messages. -- Michael --gE7i1rD7pdK0Ng3j Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl5Ywj4ACgkQnvQgOdby QH04rQ//XZD8v9PZIPvmko2/kaF30P4x27SxL7pyMcBiQS+fEHdzFe0WZgknVebF VzhJtrnAzIwUsJW0Ud5ZcWa31d1EQWYQSL5sf2qjTAsEnGEvQzVxxXsv/kaUFykd TVCqV+r1VK7ct48lYQewQwkFzhQcFKauQzV7EyEsZjaJe/T6z2bkt3rUuk2z2CtF d6XbCXWHylgEtIylWeZhDH2qmehQW5Vqc8RTwrYH/j1quYzQJtpJ9Xdnb7PGBLoh MSygaiiyCLNQv2l/QEpWIuxQYqiEMx9klWEMLlaB1t/Ty7QkzYOn54/HS8ePZJI6 hHq95p1BOzd6uMOBHtaIDsz0FVOmjtR5bYBfMjXLwVIHE8wA/bMBai69fhHkCWLx 3J2NntvozIWyXu1+Nd669HYbZ9OSFuGbz7Zt2xAR7m9hjm6zQhaZks4V45O6w3hO EQnfRDNE7nXw3EC8vum5A1oVNtS/lpqk0xNAt30SQKq8yGj/PdTM51e57V6LrMVV ytmNj9z74UJbyChhjSWx7NfITzo1t8Jxyeqn5EBXmbe456OxXdw9vTOtL03FZmJH RaTWEckyzznm66S1MmXRW6hz7cgAHuBVVcARHloqlReQU+yEPkgZV6hGz8SEg1E9 +9WANe4Nil5TPlZXFwLfSeWVqJB7afbuZefCNqQlJZpT45oIqCw= =5iF9 -----END PGP SIGNATURE----- --gE7i1rD7pdK0Ng3j--