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 1qY6lY-000nqf-Ad for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Aug 2023 15:24:29 +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 1qY6lX-007WVt-5R for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Aug 2023 15:24:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qY6lV-007WVd-LM for pgsql-bugs@lists.postgresql.org; Mon, 21 Aug 2023 15:24:26 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qY6lQ-000BwE-O0 for pgsql-bugs@lists.postgresql.org; Mon, 21 Aug 2023 15:24:24 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id DE3433200932 for ; Mon, 21 Aug 2023 11:24:16 -0400 (EDT) Received: from imap49 ([10.202.2.99]) by compute6.internal (MEProxy); Mon, 21 Aug 2023 11:24:17 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:content-type: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=fm2; t=1692631456; x=1692717856; bh=xW 5OcK+Js9nQKz40NcXesb3c2/JqlS7sVo2XIfidzl4=; b=Nvrxjp38WsnE1WkJGz lxhwDeQ/B6wuVKEs5wF3r9qt+kWhfDAjGruJ4Lwt9YJvcWIvDuyAZnC/OmEr9C0V q2xjcnQAYzuk7Mt1rBZ5hOwsIRTcv++i9bluBrI1nt72t/7wkpXPiLZxyo/Loqx2 DS0XNpiwZHwZW+8J94m1b7CIDyk6nEHPeVK57KTU7/X2wXlXVOI2tYs6fLd0Yj0v E9PWO39bYAwlEiZFbWcmUX3DPwRNOvqKFUauCD7+XTZxTEts2I/xYCNoONfqat+h fDajBzb2sE1iAZFONRjUpMoCI9nSNZxz47LGOtsLxvbLSrkEMzceHXHWBMhB9ZRK PCyQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type: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=1692631456; x=1692717856; bh=xW5OcK+Js9nQK z40NcXesb3c2/JqlS7sVo2XIfidzl4=; b=B9r3YT0M60/wf6OdVsh36jxvT/Urp S6qzRpnr8VdS1GJhHG/IYfINjPJZTAVlYgHXnKY8K5WKohCmomJ4gW9h64L/7q/v Nm9FaCbdyBN1vdeHzvdKZvXklwlqwKL4T1l04fUl9EwyRg7h1bN2ZvnDSJki7v5Q qKeSEjH4+GRXOYzqofbW5iN+NFGpEypIxwHGRwI3ZKGFXNwT59cH+662Seq0SH6J vWdH05uwZVmVP2/EOGpfpNuJ+RsM5MdssX4aLjOfYXu4j5oSTKXAaB9/S/yq0Qs0 PheBgVfHBBZQOsbwDLqDMU0PBxaUq3Bkez7WKtGq3foWYMflTg0RXYRoQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudduledgkeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefofgggkfgjfhffhffvufgtsegrtd erreerredtnecuhfhrohhmpedfgfhulhgvrhcuvfgrvhgvihhrrgdfuceovghulhgvrhes vghulhgvrhhtohdrtghomheqnecuggftrfgrthhtvghrnhepjeethfeuvdfgffdtteevud eftdejueffkeelveekhfevkeegleefhfejhedtjeegnecuffhomhgrihhnpegvnhhtvghr phhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegvuhhlvghrsegvuhhlvghrthhordgtohhm X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id E995915A0091; Mon, 21 Aug 2023 11:24:15 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.9.0-alpha0-647-g545049cfe6-fm-20230814.001-g545049cf Mime-Version: 1.0 Message-Id: <4e64ce95-9186-4003-a980-ebeae2f49aad@app.fastmail.com> In-Reply-To: References: Date: Mon, 21 Aug 2023 12:23:55 -0300 From: "Euler Taveira" To: pgsql-bugs@lists.postgresql.org Subject: Re: Postgresql15 crash with :FATAL: could not open shared memory segment "/PostgreSQL.0000000": No such file or directory Content-Type: multipart/alternative; boundary=34ef057e325a4042847d31ad5d959f2d List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --34ef057e325a4042847d31ad5d959f2d Content-Type: text/plain On Thu, Aug 17, 2023, at 5:27 PM, Emile Amewoto (ZA) wrote: > > Postgres version 15 randomly crash with the following error : FATAL: could not open shared memory segment "/PostgreSQL.2771626404": No such file or directory > You didn't provide enough information about your environment (operating system, exact Postgres version, Postgres settings, etc). I don't know if it is your exact problem but systemd contains a setting that removes IPC during the logout. It means that if you are using the Postgres service account (generally the 'postgres' user) to execute administrative tasks and you log out while you're running a query (that requires dynamic shared memory) then you get this error. See 'man 5 logind.conf' for details. If you want to avoid it, disable RemoveIPC in /etc/systemd/logind.conf. (IIRC only Debian/Ubuntu defaults to yes; RHEL doesn't.) If that's not your problem then you have to provide additional information as I said before. -- Euler Taveira EDB https://www.enterprisedb.com/ --34ef057e325a4042847d31ad5d959f2d Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Thu, Au= g 17, 2023, at 5:27 PM, Emile Amewoto (ZA) wrote:

Postgres version 15 randomly crash with= the following error : FATAL: could not o= pen shared memory segment "/PostgreSQL.2771626404": No such file or dire= ctory



You didn't provide enough information about your enviro= nment (operating system,
exact Postgres version, Postgres = settings, etc).

I don't know if it is your = exact problem but systemd contains a setting that
removes = IPC during the logout. It means that if you are using the Postgres
service account (generally the 'postgres' user) to execute admi= nistrative tasks
and you log out while you're running a qu= ery (that requires dynamic shared
memory) then you get thi= s error.

See 'man 5 logind.conf' for detail= s. If you want to avoid it, disable RemoveIPC
in /etc/syst= emd/logind.conf. (IIRC only Debian/Ubuntu defaults to yes; RHEL
doesn't.)

If that's not your problem = then you have to provide additional information as I
said = before.


=
--
Euler Tave= ira
EDB   https://www.enterprisedb.com/

--34ef057e325a4042847d31ad5d959f2d--