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 1qY7eE-000qHg-Gb for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Aug 2023 16:20:58 +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 1qY7eC-008LKl-Rj for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Aug 2023 16:20:56 +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 1qY7eC-008LKb-HZ for pgsql-bugs@lists.postgresql.org; Mon, 21 Aug 2023 16:20:56 +0000 Received: from sonic311-24.consmr.mail.ne1.yahoo.com ([66.163.188.205]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qY7e8-000CWn-HK for pgsql-bugs@lists.postgresql.org; Mon, 21 Aug 2023 16:20:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1692634849; bh=N5+jut7c6Uc9eZSBRdPf0ezJNLysDn5UBdsC0GpKqXM=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=eUuGRijLyFh36LCCSIXi662/LEEbrAgqWeFoPYElAdF0pbobcNe0eeOvQIQWdKltk0I3LUXAWfGqnm+rxyIJTik+ZI/TRkAqcw5zk/CnT+UVyx0S9W2CQjM2lWM+eWg6XgGg8PRcHusDsjcmeizjJ5JRk+3+A5d/m8aQh5+qWNx7xWIMNaBaCDBj0d67j/HnF3QLdVAoy4bcV5vN7Xi6A7AFQbzExsFcu6gmVOz716mi0igtO3710lKYkrBpzCyNsj33H4BKZbmj5kM/AenwH5t1VA72pfcqdDy4GvAq9iM1u//Lkh5uOs/BN24x0NN36dsa86xQXFuZtFA4MlNePA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1692634849; bh=pGI9Y2qn3cRFV8HEGGEHvxhnDv4jdk1tgiidU0/vQk0=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=BLRXi67wcTQRmwr835QR4rtb5JONLEAAB7K3sheERWvACBe8oenkLtKT1RJI3Cz0I1j2qJnQqumP+lyl9BGYfMaQttUNBWhuCgWCSjhqaddUWxxm4qBhYHGxTXqk4opfVeAR3PMLKQzTZTOVzxaCIEEwGM02Zl2+hJTpR/PjWW4Zu6x15XXmtj9Wl4f9urLc19Wv2pPNirlJO2lB+jokGvTQmFghAJWtWEDu8C+iZql9opt9l8CbXSrevYFHWIj+RYx26CUpdX9GgPTIHiJmX8PPSSJxirwxnadXOmKbOtt8AwSi3MLVx4ynm/XJmC/yhnK60LA0DYiB0qfd/XS9Hw== X-YMail-OSG: oEz8kh8VM1naFK.DKlUGu8T8fRvvTfA_WwIH53XP2jWLBnkElmIYMtrF81fTVuG JHSJszrhYO0wQHnpTE3sSzUmCmMKX3yg6xpIkyxO3dU_3HcvRHJQzlz9NcHnUZZw.vhXi3Xn.nHt iFuRpcb95twaoOr64fom1DUhO4E6_q2DpU.9bGeKt93eJRBrau9iJhKMx4CQo0JdDQ1Ku7MkymbP 8zjc5522Qpn9SXZ5hrauXu9yqXsA8sOtFCmji9goRAiwjeZ00ItD2WZEP0b5JPn4NommrQwLXdFB ylG14yD8c9HbrxAi7uHSfAr.A5gJcWo0Eue51cSoPdx45Fxck.RF3u1l9F6rXAvvjJEKmEfNOapk 4ZW3b5q_EPtfj5gvWKlCg.bcaKdehbL5eOLFMylaFP_l15FJUtbjA1ArMrtY6NNlxVk6p.9mHcGq YMKVmvfWuIpOtWtI61Rmt0x5QxaBXVMEkVYxXV6YNAChA_TzKuMI1U5hbTNJ3ZJpwsooQ6jzJ6j3 qzCVnFwupJ7hdGO8OkMpLGXpnA66S88osEOCT.Qv8tycLqzILZ1eBleUNRphPMPqhOjdVgF.Pi39 17Ag_WPVPoavy3IPbkse4sJnfWIVHC7XMjfrhWF1psTy8slg4LjxbBacJasgtdEAnjiyug8E2Uip Sqe8ZAhI1ffaxTssAG70EYAefgpjHPICq.YxmaihMAv2E9w8ZDY0WR7Z_9ZnNpsrg5O_e_YVKMMZ HZKzVe0yYpWKQ3jObIhNJuFKVH9U2WLFS3r82HIwLjyOr6ZJrH2c_R3mvaC3GrcCfuhAPCZDEqh. K69mtR7ynTp.RG0nKyqbfuXaqQrmiWtjfX2e_rSus0obGr3ltIyfc97Fib6ud5SOr_sE.o8NXGbF Emig9GN1XhmmtNQ7tU.8Bu0JQ3aQGXEvL41j3vjOvcTvjaQVXMXJy5dZXmDuyWbYLWYqiCRpX6u2 eWVBEJQh_s.Phjl5L8fLRiRtcirjUQS4J3bKu6IAd1PVPEq2_.8KES8P94AVR9qs.PCtwYpCMfsz BGOg1jPA.8CGRhslpImL2I8tVEZqVgEbLqycgSn8BnDtJJOT2IWOYw26a9MbCh4ijbU8RHZo2_V8 hQPTYBylpO75aKLmVu92S4c.n0hAC_gnzoWH6TYZYDTQLDabbr8tz_Ch5rZ3V6Nmcq10Q8qfdKVK vefSEfgWaZq8NRzmjWX4dNrmrvY8IjcSpoTa6xMXWe4ofSc1atFkFtWooc8T9HQAigXIzc8vnslW 2ZJReal.uZHgsnY_5lkKYYdDHZObw6lF5B5cOu6buOhoCCGBB7BhXGeNVTFhV5UriYBSHxbuhgZC oOh2ueiQid3fFjwKeh5rSMUVMYwUSeaMOQDtc.s_r5.LMiJt3kko3nseAqqIZvrBymge_U4PkrKI Q3y1JOwKKZ70rLAvzD1rWP79CcLEQmjWXkofun0dVkTcLFbOLzXh5HJOKPC1ozJ6tPyFgcDbVgEU E8Q5dP8I1fv279b5JRGwRqQWnF1zspSAXwoRJANe6fDeWJNU9RMqdG6EgfLEazeauH_DNa8lmGvE pNyy9g5tTlsIPm5YbThU.fsPFcxr9b71GFe7dfZ_876bcW_TQ1dJPoFD.rZLlIlDBF9YQcENQYI. 4x8ARh8A9tUqK.q64CoTUR98zufdmVWCYpSDiDaEf4bXIxOj2YoMxH2qGWtD5SMSU4tHulT3IxbA W9GBqVa190WAtXoa0lcov2GFnlp2xYlEflZtYk_92Sem6De3.kenImxWmevXxWrNUdiOWl0DsUXD T9C5a7uAjZumIfh6.BIokY99jxMk..UWFZDewdVJcMBEPzqwc.WGFS.BYG_McosuZuF2Q80dQGev XV.JPjg2q6yLdP7Ij4VSxRITxHXOfORplsrivLv9AD7Dacp5o4o03OtXB5x7QIoKUQSFV9y4fzTZ 5DkFhMhFFWg2TBLdSbyDb7f6izY8ni1WY4EFlm87Tp3tAFx3Uar2nO3AMJhsLmb2gA4QtqBHfv9O zu8CGsAO8WDzB8RZay535LoUXTgfvpN8OhBQNr0tb2P7wU2q2ZYC5R15GMMrko83nDIH7J8fB6EH 4_3VBIN5Iv3P84kMZqv7PgG5Dfco.WQjvmJx7lp2L8UuEV_S9juQVRY4SeZVBHOjPsnhbrR_9Xs6 f945hFqzQoRz_BoLH9439hZEQVoRoIBDAPoIwDmxpto4yDJtrZ4n1qiyogNBnD.EqByBvRGgNw6n z77H43KgiCmUg50PB_DvNyIdMJiweNjua8i9fZCQNHE2_mPn4Tw.jtC2iBWh82.smj7hpegP3l4D J4O6_FeB4KbZHPt.H1oc2Zb8scTpR.1TZ6DznmvYVr5jkm1sTjKsMmO4XJsRKcuJUmA-- X-Sonic-MF: X-Sonic-ID: 6887214f-94b6-4bdd-935f-818bf465772c Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.ne1.yahoo.com with HTTP; Mon, 21 Aug 2023 16:20:49 +0000 Date: Mon, 21 Aug 2023 16:20:39 +0000 (UTC) From: Emile Amewoto Reply-To: Emile Amewoto To: euler@eulerto.com, pgsql-bugs@lists.postgresql.org Message-ID: <537973380.2573525.1692634839959@mail.yahoo.com> In-Reply-To: <4e64ce95-9186-4003-a980-ebeae2f49aad@app.fastmail.com> References: <4e64ce95-9186-4003-a980-ebeae2f49aad@app.fastmail.com> Subject: Re: Postgresql15 crash with :FATAL: could not open shared memory segment "/PostgreSQL.0000000": No such file or directory MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2573524_708709056.1692634839958" X-Mailer: WebService/1.1.21732 YahooMailAndroidMobile Content-Length: 5875 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2573524_708709056.1692634839958 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks Euler, that's exactly my problem.=C2=A0I will set RemoveIPC to no.Yo= ur update is very helpful, thanks again.=C2=A0 My environment is Rhel 7.9 Regards,=C2=A0=C3=89mile=C2=A0 Sent from Yahoo Mail on Android=20 =20 On Mon, Aug 21, 2023 at 17:24, Euler Taveira wrote: = =20 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 di= rectory You didn't provide enough information about your environment (operating sys= tem, exact Postgres version, Postgres settings, etc). I don't know if it is your exact problem but systemd contains a setting tha= t removes IPC during the logout. It means that if you are using the Postgres service account (generally the 'postgres' user) to execute administrative t= asks 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 Remov= eIPC 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=C2=A0=C2=A0 https://www.enterprisedb.com/ =20 ------=_Part_2573524_708709056.1692634839958 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks Euler, that's exactly my problem. 
I will set RemoveIPC to = no.
Your update is very helpful, thanks again. 
My environment is Rhel 7.9

Regards,&n= bsp;
=C3=89mile 


On Mon, Aug 21, 2023 at 17:24, Euler Taveira
<euler@eulerto= .com> wrote:
On Thu, Aug 17, 2023, at 5:27 PM, Emile Amewoto (ZA) wr= ote:

Postgres version 15 rand= omly crash with the following error : FATAL: could n= ot open shared memory segment "/PostgreSQL.2771626404": No such file or dir= ectory



<= /div>
You didn't provide enough information about your environment (ope= rating system,
exact Postgres version, Postgre= s settings, etc).

I don't know if it is your exact problem but systemd contains a setting t= hat
removes IPC during the logout. It means th= at if you are using the Postgres
service accou= nt (generally the 'postgres' user) to execute administrative tasks
and you log out while you're running a query (that req= uires 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/Ub= untu defaults to yes; RHEL
doesn't.)

If that's not your probl= em then you have to provide additional information as I
<= /div>
said before.


--
Euler Taveira
EDB   https://www.enterprisedb.com/

------=_Part_2573524_708709056.1692634839958--