MIME-Version: 1.0
References: <0af98214-3c2a-43e5-9bbf-ddd79b85ea93@ebi.ac.uk> <709d5fa0-85e1-40a2-a6a4-11040f4e5b62@ebi.ac.uk>
In-Reply-To: <709d5fa0-85e1-40a2-a6a4-11040f4e5b62@ebi.ac.uk>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 14 Jan 2025 08:39:27 -0500
Message-ID: <CANzqJaBvSYzEue9H4ENRUnFfkmmFaRw94D0U6EtBZPwgrbxU5g@mail.gmail.com>
Subject: Re: Postgresql database terminates abruptly with too many open files error
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004f64b6062baab1c1"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBvSYzEue9H4ENRUnFfkmmFaRw94D0U6EtBZPwgrbxU5g%40mail.gmail.com>
Precedence: bulk

--0000000000004f64b6062baab1c1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Jan 14, 2025 at 7:58=E2=80=AFAM Sri Mrudula Attili <sri@ebi.ac.uk> =
wrote:

> Hello Team,
>
>   We have a postgresql VDB(virtual database- Delphix) that keeps
> terminating due "to too many open files".
>
> Below are few alerts that we could see from the postgresql.log
>
>
> < 2025-01-14 11:37:20.724 GMT >LOG:  out of file descriptors: Too many
> open files in system; release and retry
>
> < 2025-01-14 11:37:20.724 GMT >FATAL:  epoll_create1 failed: Too many
> open files in system
>
>
> The number of allowed openfiles at OS level are 65000. even then we see
> these all these being utilised and causing the database to terminate.
>
>
> Is there a way we could avoid this.
>

We need more information.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--0000000000004f64b6062baab1c1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Jan 14, 2025 at 7:58=E2=80=AFAM S=
ri Mrudula Attili &lt;<a href=3D"mailto:sri@ebi.ac.uk">sri@ebi.ac.uk</a>&gt=
; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex">Hello Team,<br>
<br>
=C2=A0=C2=A0We have a postgresql VDB(virtual database- Delphix) that keeps =
<br>
terminating due &quot;to too many open files&quot;.<br>
<br>
Below are few alerts that we could see from the postgresql.log<br>
<br>
<br>
&lt; 2025-01-14 11:37:20.724 GMT &gt;LOG:=C2=A0 out of file descriptors: To=
o many <br>
open files in system; release and retry<br>
<br>
&lt; 2025-01-14 11:37:20.724 GMT &gt;FATAL:=C2=A0 epoll_create1 failed: Too=
 many <br>
open files in system<br>
<br>
<br>
The number of allowed openfiles at OS level are 65000. even then we see <br=
>
these all these being utilised and causing the database to terminate.<br>
<br>
<br>
Is there a way we could avoid this.<br></blockquote><div><br></div><div>We =
need more information.</div></div><div><br></div><span class=3D"gmail_signa=
ture_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div =
dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil=
 me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div=
></div></div></div></div>

--0000000000004f64b6062baab1c1--