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(dot)arg(at)gmail(dot)com> wrote:

> 2009/8/12 Jonatan Evald Buus <jonatan(dot)buus(at)cellpointmobile(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>