Re: "Too many open files in system" error

since the message is "out of file descriptors: Too many open files in system; release and retry" i think you should also be checking the system ulimit.

try commands like "ulimit -a" to check the number of files currently open in the system. Also try "ulimit -Hn" to get  "The maximum number of open file descriptors (most systems do not allow this value to be set)" see man pages of ulimit for more details.

you could also increase the ulimit by making changes in "ac/etc/security/limits.conf".

However i hope you have already checked the possibility of some other process which might be continuously opening files and not closing it properly. Linux has a fixed number of fd's that can be used and if the process dont relese them it coudl lead to such a problem.

Hope this helps.

Thanks,
 - Jinson.

On Wed, Aug 12, 2009 at 10:44 PM, Emanuel Calvo Franco <postgres.arg@gmail.com> wrote:

2009/8/12 Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>:

> Greetings,
> We're seeing numerous "LOG:  out of file descriptors: Too many open files in
> system; release and retry" entries as well as quite a few "LOG:  could not
> open temporary statistics file "global/pgstat.tmp": Too many open files in
> system"
> Much more alarming however, we're seeing errors such as:
> FATAL:  could not open file "global/pg_database": Too many open files in
> system
> ERROR:  could not open relation 1663/2219053/2601: Too many open files in
> system
>
> kern.maxfiles is currently set to 12328 and "sysctl -a | grep
> kern.openfiles" showed over 10.000 open files prior to a reboot.
> After the reboot kern.openfiles quickly increased from less than 200 to over

Did you request about kern.maxfiles?


--
             Emanuel Calvo Franco
            Database consultant at:
                   www.siu.edu.ar
       www.emanuelcalvofranco.com.ar

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin