Request a Demo
Home   >   mailing lists

Re: Postgresql database terminates abruptly with too many open files error - Mailing list pgsql-general

From Ron Johnson
Subject Re: Postgresql database terminates abruptly with too many open files error
Date
Msg-id CANzqJaBvSYzEue9H4ENRUnFfkmmFaRw94D0U6EtBZPwgrbxU5g@mail.gmail.com
Whole thread Raw
In response to Postgresql database terminates abruptly with too many open files error  (Sri Mrudula Attili <sri@ebi.ac.uk>)
List pgsql-general
Tree view
On Tue, Jan 14, 2025 at 7:58 AM 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.

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

pgsql-general by date:

Previous
From: Frank Lanitz
Date:
Subject: Re: Postgresql database terminates abruptly with too many open files error
Next
From: Tom Lane
Date:
Subject: Re: Postgresql database terminates abruptly with too many open files error