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.96) (envelope-from ) id 1vOeLF-00HNpV-2b for pgsql-bugs@arkaria.postgresql.org; Thu, 27 Nov 2025 15:55:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOeLE-0071p7-0Y for pgsql-bugs@arkaria.postgresql.org; Thu, 27 Nov 2025 15:55:32 +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.96) (envelope-from ) id 1vOeLD-0071oz-2B for pgsql-bugs@lists.postgresql.org; Thu, 27 Nov 2025 15:55:32 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1vOeLB-001lfS-0f for pgsql-bugs@lists.postgresql.org; Thu, 27 Nov 2025 15:55:31 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfhigh.stl.internal (Postfix) with ESMTP id B134F7A0128; Thu, 27 Nov 2025 10:55:28 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Thu, 27 Nov 2025 10:55:28 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= 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=fm2; t=1764258928; x= 1764345328; bh=NC/UiilbkHMA3FHDLe6976XHBU/HMe/njsXcQokwaA8=; b=c C0sMVTooMAh3FXlq1JJo0zTBj4FU2lvLjXDztMRG0DKuvPwymGw8sFMmJX5XM2da +vqRDjJDxKN8whYZ4JLLN5tOLo41D38dDfi89j5VC3PtzwMiol7FxZlu2mXvtEU/ e7xT3+ZK8GDk/8QhcFVyQeAZrrAGISYZmef55M3d6BtsW3x0knHdHSlGEnfw7/+n YkO/Az2SqyKqOdUdKDvAKfZHUnQylv+zzi0iDVCgYCph/arR9eD3JxUQPsdunhMy C+ujl5Ze3yM1SZlZ8w/z5CRvABj/XggleJB9Un3D7f20wDLq5V+zpUmk1Gb8+tBR W2yviSQjXDn4f0y1Wzwtg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=fm1; t=1764258928; x=1764345328; bh=NC/UiilbkHMA3 FHDLe6976XHBU/HMe/njsXcQokwaA8=; b=xmbdnitq+Ja66bmfJbq3+cX1RbfWf RNSyogYG3jP8Pl+299RloHfG//HTQWPlTamP7h0vYzjCd6A2bNY28A4+lMphtZKh EzsTK5SiQ0E42D+Is26OxuqMIyFp4Z+PpMmhi7XqmOExj6ZVvTqi6lhkCYD+Go+M O5+4DP4a8arMwOeEECT5UFNZt/sa8IOdIBzreTuDCm4VfwwI5NOatdWADi7fZxx+ vM3Y50YsQEln19psyyE5iZ1oK+7x0k8OjXlm+OxZM+bpWzZVLjL1GXooVMDdg7a5 QiqwHFINLdcen+ZsJSU6btyzaVJrOQNXeXKw476yx/JO5aZX4dJLwKIAg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddvgeejieegucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpeffhffvuffkgggtugfgjgesthekredttd dtjeenucfhrhhomheplmhlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehk uhhrihhlvghmuhdruggvqeenucggtffrrghtthgvrhhnpeehgfethefhhffghffhjeegud dujeekieevleehgfefueekhefhuddvledtieevleenucffohhmrghinhepvghnthgvrhhp rhhishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrg hilhhfrhhomheprghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvpdhnsggprhgtphht thhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehpghhsqhhlqdgsuhhgsh eslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepnhdrkhgrlhhi nhhinhesphhoshhtghhrvghsphhrohdrrhhu X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 27 Nov 2025 10:55:27 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1764258925; bh=ibWcQ3Kt4u48wwxMCuYQeni8lbmp2ySHqBqwJzSgxb8=; h=Date:From:To:Subject:In-Reply-To:From; b=fXXBGcSEgEaBL1ZBIV7cga3HI3kO+RADrNLaTyVqbEzJhuI4Tq94vCHHOLwZXzyH6 fb2cX3vnS5zeQ94ueGhv8BQszgvow2iYXmz6l+nRXKTCmz/m0zc+VJ7BWE41tFvqrZ eEh1TCIG9yyEpeUisArgRwUCSwLTgVbM0g116CcjlPVa2K945BnkeQqkQOLs02JkRB ZWb9i/qOcCgSqlRc8yk6qL5ckZd2ihHMxlWZkhjC3NLLyBOBs4Hn+xFQO0+cN1oAzO jDxWQiSx4XDuH+6TOoyTn1vYSOjdHjk8MpBxPHTKQehRRcim7zKx+dHxiIkz/1T4pR d/Oi1la7GVZyA== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 7B70676; Thu, 27 Nov 2025 16:55:25 +0100 (CET) Date: Thu, 27 Nov 2025 16:55:25 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: n.kalinin@postgrespro.ru, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19336: TRAP: failed Assert("!IsTransactionOrTransactionBlock()") Message-ID: <202511271553.luyuaduv7rtr@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <19336-3ff9a25f0dc4ab42@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Nov-27, PG Bug reporting form wrote: > With this parameter in postgresql.conf: debug_parallel_query = on > > If you execute the query: SELECT pg_sleep_for('5 minutes'); > > and then kill the postgres process with signal 9, you get the following in > the log: > > 2025-11-27 06:44:27.263 UTC [643318] FATAL: postmaster exited during a > parallel transaction > TRAP: failed Assert("!IsTransactionOrTransactionBlock()"), File: "pgstat.c", > Line: 673, PID: 643318 > /lib/x86_64-linux-gnu/libasan.so.8(+0x831e0)[0x7058d98831e0] > postgres: test postgres 127.0.0.1(44374) > SELECT(ExceptionalCondition+0x156)[0x616e63da3dcf] > postgres: test postgres 127.0.0.1(44374) > SELECT(pgstat_report_stat+0x43)[0x616e635c9ced] > postgres: test postgres 127.0.0.1(44374) SELECT(+0x51c29fe)[0x616e635c99fe] > postgres: test postgres 127.0.0.1(44374) > SELECT(shmem_exit+0x29f)[0x616e633beca2] > postgres: test postgres 127.0.0.1(44374) SELECT(+0x4fb7750)[0x616e633be750] > > Maybe the Assert shouldn't be printed to the log, and only the following > output should remain? Hmm, why does it matter? If you've kill -9'd the process, everything will be restarted anyway. It makes no difference whether the assertion hits or not, does it? -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Las navajas y los monos deben estar siempre distantes" (Germán Poo)