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 1sMgAw-003oq1-RF for pgsql-general@arkaria.postgresql.org; Thu, 27 Jun 2024 03:51:59 +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 1sMgAu-007zDZ-PI for pgsql-general@arkaria.postgresql.org; Thu, 27 Jun 2024 03:51:57 +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 1sMgAt-007zDR-8B for pgsql-general@lists.postgresql.org; Thu, 27 Jun 2024 03:51:56 +0000 Received: from fhigh6-smtp.messagingengine.com ([103.168.172.157]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMgAq-003KKn-3y for pgsql-general@lists.postgresql.org; Thu, 27 Jun 2024 03:51:54 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 847311140267; Wed, 26 Jun 2024 23:51:50 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Wed, 26 Jun 2024 23:51:50 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1719460310; x=1719546710; bh=a/05Lyun3Q b57Tx6u682Sw51kgY/VMfstxXt21usXxA=; b=zx6vmOrPZD6HqQf0lZUwkdvdus ysw3Vm5RqCjJVKoXlRWTEt4oc/Fg0WjF3LS8eJTHLQv+D4a4ZpKf6fQhdtMO2hGO 3E9rsVWEybb+0nPV7das07UpJ3MUjoNqSPVRTdWvqjDr5cV2Jid//sSF0QbTZP9X HQrJybaP6ESraNsBu6W44xEhCQKWK10c1fz3dalCsAOWA0LqOX6SUlyCWBpisazK 0V6/Rp4fs4LyKFQ4mksm4h5O5J3xShU3RSDDZ2p8SMPUOD3/eVr8ElXoCQwJSNkL bQz8D+iHrlSscdd6C7QutVzNVZGrbDJ40fKocA5+ARRFqG/ZC1yTCwmFG2lA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc: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:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1719460310; x=1719546710; bh=a/05Lyun3Qb57Tx6u682Sw51kgY/ VMfstxXt21usXxA=; b=HCrLNoZu01xfYKyqiMhXaXSPZ6T03/Bxi8QNAht0Qg/T +R8m0qODuZG95H1s64ntwtRwKOYFFxB8GftnAy9t5zp/5867GyORtiHWOHYOvvMx JncKEIBbpMvdo1zKC1sxMZGE/YzaMs32PFmEKnHZuZz44X17NxdpGpVIe0a+W+rF kKZR4bJQUeU/cguDq8ZwIM0ZyaDvKNMNzB+4r4wbO/+PacOmlQRr5fg+aWefj7hy 2yRBxFIqLovpYLhgwf+3H4TLj6e5opxgJ6VlWChhNDo+dpskCRgwjzzEPSpzmytC csiSbGv20l15XDRS5CDzaI0e805VMFTbVfmDR0rXSQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrtdefgdejiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt jeenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeejieegheevjedvgeektdegveej ueegheeljeeggeffvdfhjeefffeigfejjedvfeenucffohhmrghinhepphhoshhtghhrvg hsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhf rhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 26 Jun 2024 23:51:49 -0400 (EDT) Date: Thu, 27 Jun 2024 12:51:31 +0900 From: Michael Paquier To: Andrew Longwill Cc: "pgsql-general@lists.postgresql.org" Subject: Re: ERROR: could not attach to dynamic shared area Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="n1E9L57ggMPo1Hz5" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --n1E9L57ggMPo1Hz5 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jun 26, 2024 at 02:43:30PM +0000, Andrew Longwill wrote: > We=E2=80=99re using Postgresql 15.4 in AWS RDS. Since yesterday we have s= een > two occurrences where our PHP application becomes unable to connect > to our RDS replicas. In the application logs we see the error > "FATAL: could not attach to dynamic shared area". The RDS replica > remains unusable in this state unless it=E2=80=99s rebooted. I suspect that you have been hit with this issue: https://www.postgresql.org/message-id/CAO6_XqqJbJBL=3DM7Ym13TcB4Xnq58vRa2jc= C+gwEPBgbAda6B1Q@mail.gmail.com A fix has been committed for it today by me down to v15. This will show up in the next round of minor releases. -- Michael --n1E9L57ggMPo1Hz5 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmZ84cMACgkQnvQgOdby QH0pZRAAniJ1gqfVPbDWD36kreKM+QE3Drh+2ddl14hFpy9e/vt1D40pQqN5uLF8 OifgpXQnzMBP/tmakfFhT9gWPGkLVyn1cYLwPetthAZEWtABCHODJ9RzqlCttyz+ zym5xI9US6nXZrHDeCs4YhKWeLEuBAzK8cN78vAmXZ3pYf0Jolp4riupmiHetHkB UL5vdYchtq7KyxXGH6ABfz3mrcoFZyn9EIgPzeelGdxaoOJw4i/+RW1Igcz6oLzt TfOPnion3q+HJeIUAWn85eSr8TXT+1E79uj4BsO/sTj2fBo4mC7pE1M9H5qmBcXv 5uQDhRozMaLPBxkAQFeKXA+YQJzZ1h0UPavSo6IfUeQtr/g9ETEaY/tixrdLAEGA R0pFBQmg8QkXY+6/bICA3fnOhrfBdrQ5+NhPYfLsmyUPYw9n8K5OmN/EcJ3ep185 AaA5GEPWRvU+YADUcF/OFJt7klDSSo/azScl9W5sV4iLLQGsFOe5OdNRmGsmDvzy 6gp+1EK8jzuJEAqU1vRT2R+L6jYz554fIyZ2SVi7t1E94vmD4AESQnUKhR4kpJZw /3gvrQLpfEPZI+1ZcH1R/5eYv9nA8bA9KFpP5zZ0MuC6q7PHVUrUnjhb3VVzwvh9 Z/SUkouy8XnugrJPy0GG08B25zq9vEOEzjVJV5DK7jH7xGg2KPo= =uFKv -----END PGP SIGNATURE----- --n1E9L57ggMPo1Hz5--