Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vB7ca-00BB7n-AG for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Oct 2025 08:21:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vB7cY-007wvc-Uw for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Oct 2025 08:21:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vB7cY-007wvT-Kp for pgsql-bugs@lists.postgresql.org; Tue, 21 Oct 2025 08:21:29 +0000 Received: from fout-a2-smtp.messagingengine.com ([103.168.172.145]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1vB7cV-002wwK-2x for pgsql-bugs@lists.postgresql.org; Tue, 21 Oct 2025 08:21:28 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.phl.internal (Postfix) with ESMTP id 5DDD1EC009A; Tue, 21 Oct 2025 04:21:27 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Tue, 21 Oct 2025 04:21:27 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1761034887; x= 1761121287; bh=hDON4qrYm6VrduHTOYRd1ocTgu76w0BRd7KjKGoUzag=; b=M 541K7gQDorMPrdIT39NpNqf/POy8W14J7EBzaxQUVJ8fnhnK4vFpe8hbAhJGphih fENB4K/uzjxOa6PEU87m7abYqw5N6mjq8OOLyZaDGdi8jsVvI6SMHtazQv2dsmNc oLGNB2tl7ZCknIOaxOW3GUxgmuv/0gf4GJGxumZ2+WYwdiNwtteLLN+JnBkm64dD Zx0H+MK/X+CWn43bVQyggzPdWhMD3LiGJi5aiqbPDw7YEF5My4qe+vBYpdvpXgN8 c/fUaUwX6m1nQLBUiIou8MT6XnpOMf39T/xLyyYso8htVpEJ8TlZ3AyTLpz5KxwU 8HJdzGOcD6N34a3BZKoKw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1761034887; x=1761121287; bh=h DON4qrYm6VrduHTOYRd1ocTgu76w0BRd7KjKGoUzag=; b=yUDWIh4u7M5U3fomZ 2HUF9v5SgcEoyJD5YW3yHIPspx6ykz/94JFktTPg8zXYH/grgjVL2tE4kjgLSwfB w4zMlFnrZwqNX92XxeljFhsPXG6xi7vEFFJ+fhfq/F2pVODf/TX0z+UrYhylZVsi U/AsOpmbSETOoTnImmJgPTNbL6Agf/L9Fsx+8GQzD8/Qw821lNzcc/RwVhM53MwM jaFFEbUiI3cFWFTXIeNK/sJj/jf5gdNQIn0Wk+B02MRymA5rWjWR5Ooo1hKuetxd ywOf16b5qytVejWyz2SKbxLkjtwexuEpGUGgkUWtyFNFGPjJMC9glvD2SF7Ur3LE mXApg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddugedtvdduucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheplmhlvhgrrhho ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtf frrghtthgvrhhnpeetuedvheffkeevgfeuheevteevkefggedttdeufeeuheduuddthfef fffhjeefffenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgv sehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopegrrhhnugdrvghmphhtihhngheskhhovghrsggvrhdrtghomhdp rhgtphhtthhopehpghhsqhhlqdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqhhlrd horhhg X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 21 Oct 2025 04:21:26 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1761034884; bh=owlk8OBU6FUvbkUEfKQAA4OnUGNYFNKkLFaa3FmkOuc=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=KUh9vCSOBV8/XCMg0MtuGEwUemxHjbwPoHlRNKwSZLw8oSUxbi6e0+eclHRrCaq9y 2u/m+Ukr4Y2K2t1jymI2sqbuhFPKJwGtmwz9J7l5uziW2fmbwiygErcvpzhlXLMzj7 aZMrcnJkbVU9q6s6oqFamjP1UZao8zT9jPWO3Ti/tO5zvgRRYwZBhVNR2gYZlruezC 7ZOat8onoZp8ATY2p09UjOL8MRuTgcuJY3152Jblhgt7QLQlbNq5SYiKlGZVbtB6lX Saod4+RhCzyvrAdMq/7MYU5B12e5h4SOGbc4Fq+APss7Ll1azmgsOH3W1zKQYP1WPR 0c6Cy3m2aHwsA== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id B99216A; Tue, 21 Oct 2025 10:21:24 +0200 (CEST) Date: Tue, 21 Oct 2025 11:21:24 +0300 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Arnd Empting Cc: "pgsql-bugs@lists.postgresql.org" Subject: Re: postgres access violation in pg_detoast_datum Message-ID: <202510210815.er7dclxccrak@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Oct-21, Arnd Empting wrote: > Crashing postgres executable due to access violation in pg_detoast_datum > > ExceptionAddress: 00007ff6ef1e86f0 (postgres!pg_detoast_datum) > ExceptionCode: c0000005 (Access violation) You may well have corrupt data in your tables. I suspect some parts of the detoasting code are still not robust enough against that and could cause server crashes. It would be good, at some point, to look into fuzzing the toast code with random bytes so that we can report errors rather than crashing ... -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "Uno puede defenderse de los ataques; contra los elogios se esta indefenso"