| From: | Frank Lanitz <frank(at)frank(dot)uvena(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgresql database terminates abruptly with too many open files error |
| Date: | 2025-01-14 13:39:06 |
| Message-ID: | 83e42564-ae78-4876-9525-d1f48843c532@frank.uvena.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-in-general |
Hello,
Have you checked something like lsof to see open file descriptors to see?
Cheers,
frank
Am 14.01.25 um 13:58 schrieb Sri Mrudula Attili:
> 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.
>
>
> Thanks,
>
> Sri
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2025-01-14 13:39:27 | Re: Postgresql database terminates abruptly with too many open files error |
| Previous Message | Sri Mrudula Attili | 2025-01-14 12:58:44 | Postgresql database terminates abruptly with too many open files error |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2025-01-14 13:39:27 | Re: Postgresql database terminates abruptly with too many open files error |
| Previous Message | Sri Mrudula Attili | 2025-01-14 12:58:44 | Postgresql database terminates abruptly with too many open files error |