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 1oxWwk-0002ia-4B for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Nov 2022 17:20:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oxWwi-0004DG-QL for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Nov 2022 17:20:32 +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 1oxWwi-0004D7-H2 for pgsql-hackers@lists.postgresql.org; Tue, 22 Nov 2022 17:20:32 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oxWwg-0002st-1z for pgsql-hackers@lists.postgresql.org; Tue, 22 Nov 2022 17:20:31 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 4EC4B5C02C8; Tue, 22 Nov 2022 12:20:29 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Tue, 22 Nov 2022 12:20:29 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; t=1669137629; x=1669224029; bh=lGpd2YrgQi JV8kQ2k80xF4CjygPX/KpLampzkdCj36E=; b=mXPW5Sg+TKqNLw8hkCIyeKgoaC IoE/YTor6NAIWbn2WYVP+soceiyQhQzejc8Nq+pMuja/64eKKi22OyKEN9FDZAUW keZgW6M+uOqG+4wnUaHiSEJx/tu+hlEkheHUu/coaG+pJ6ef1tWJ0e2jAl8jETFT Q8EJ1zd88ifdXLCiFlPeNEYPqut4wK+Ww8/8kuJIlsqI04RDYp08ltP8uIiuxBBM tC/q6/Dm/4bt+KhZ4vcJxamfubj9hrKSL+vliFdPtypG+86AsHP64KV5RJ1mqMTu tEfSNYURy1BZtGKOQN1GJ3MnoFlxlT1ZXoPS3m9+80ZQ1qD416Iw/m46hFvA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1669137629; x=1669224029; bh=lGpd2YrgQiJV8kQ2k80xF4CjygPX /KpLampzkdCj36E=; b=LacuOOM7T5rg+fufYpSIPoB47zjBmSlvlEC4cdGj+whx LPmetMeR3QyJZEK8bM3o9YUV8FwDSdOtLD1OJZLRwZWmG1A5YDTG38t5vFzyCQjH KkFYuVH5c3vGTOdqrdoCMLli9tFa5NlKprNHBvgNWGQH1BSnGIdWfRz0GsSnmqnH WlFYb0r6KxX/6iqyfKol4dP0UcV4C0GuYWZe4NCIELo7u3S9xNFaRWekyNoRA1Do btNpY1NXKCujt3zegAsSqd4QTF6P2yGW1cMxfP+NW58gMvIgaYAeBV1qurKTFqQR nQ2bUXoRbED/+f57kFmYogWdHMjq+5clQAIpL/vaMw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvgedrheelgdeilecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuffkfhggtggujgesthdtre dttddtvdenucfhrhhomheptehnughrvghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghn rghrrgiivghlrdguvgeqnecuggftrfgrthhtvghrnhephfegjedtudegveffteefjeelje dvgeetueelffdtffejgeffgeeggeffteegheeunecuffhomhgrihhnpegtihhrrhhushdq tghirdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrh homheprghnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 22 Nov 2022 12:20:28 -0500 (EST) Date: Tue, 22 Nov 2022 09:20:27 -0800 From: Andres Freund To: Kyotaro Horiguchi Cc: pryzby@telsasoft.com, jchampion@timescale.com, ashu.coek88@gmail.com, pashkin.elfe@gmail.com, michael@paquier.xyz, bossartn@amazon.com, david@pgmasters.net, peter.eisentraut@2ndquadrant.com, pgsql-hackers@lists.postgresql.org, jtc331@gmail.com, robertmhaas@gmail.com Subject: Re: Make mesage at end-of-recovery less scary. Message-ID: <20221122172027.x7utz4aaust5rsue@awork3.anarazel.de> References: <20220917042150.GS31833@telsasoft.com> <20220926.161737.1260903443656462873.horikyota.ntt@gmail.com> <20221028023705.GH16921@telsasoft.com> <20221118.172537.1914590795663055479.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20221118.172537.1914590795663055479.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2022-11-18 17:25:37 +0900, Kyotaro Horiguchi wrote: > Just rebased. Fails with address sanitizer: https://cirrus-ci.com/task/5632986241564672 Unfortunately one of the failures is in pg_waldump and we don't seem to capture its output in 011_crash_recovery. So we don't see the nice formattted output... [11:07:18.868] #0 0x00007fcf43803ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [11:07:18.912] [11:07:18.912] Thread 1 (Thread 0x7fcf43662780 (LWP 39124)): [11:07:18.912] #0 0x00007fcf43803ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [11:07:18.912] No symbol table info available. [11:07:18.912] #1 0x00007fcf437ed537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [11:07:18.912] No symbol table info available. [11:07:18.912] #2 0x00007fcf43b8511b in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:155 [11:07:18.912] No locals. [11:07:18.912] #3 0x00007fcf43b8fce8 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [11:07:18.912] No locals. [11:07:18.912] #4 0x00007fcf43b7244c in __asan::ScopedInErrorReport::~ScopedInErrorReport (this=0x7ffd4fde18e6, __in_chrg=) at ../../../../src/libsanitizer/asan/asan_report.cpp:186 [11:07:18.912] buffer_copy = {<__sanitizer::InternalMmapVectorNoCtor> = {data_ = 0x7fcf40350000 '=' , "\n==39124==ERROR: AddressSanitizer: heap-buffer-overflow on address 0x625000002100 at pc 0x55c36c21e315 bp 0x7ffd4fde2550 sp 0x7ffd4fde2"..., capacity_bytes_ = 65536, size_ = }, } ... [11:07:18.912] #6 0x00007fcf43b72788 in __asan::__asan_report_load1 (addr=) at ../../../../src/libsanitizer/asan/asan_rtl.cpp:117 [11:07:18.912] bp = 140725943412048 [11:07:18.912] pc = [11:07:18.912] local_stack = 140528180793728 [11:07:18.912] sp = 140725943412040 [11:07:18.912] #7 0x000055c36c21e315 in ValidXLogRecordLength (state=state@entry=0x61a000000680, RecPtr=RecPtr@entry=33655480, record=record@entry=0x625000000bb8) at xlogreader.c:1126 [11:07:18.912] p = [11:07:18.912] pe = 0x625000002100 "" [11:07:18.912] #8 0x000055c36c21e3b1 in ValidXLogRecordHeader (state=state@entry=0x61a000000680, RecPtr=RecPtr@entry=33655480, PrevRecPtr=33655104, record=record@entry=0x625000000bb8, randAccess=randAccess@entry=false) at xlogreader.c:1169 [11:07:18.912] No locals. The most important bit is "AddressSanitizer: heap-buffer-overflow on address 0x6250000\ 02100 at pc 0x55c36c21e315 bp 0x7ffd4fde2550 sp 0x7ffd4fde2" Greetings, Andres Freund