Thousands of errors...what happened?

On Mon, Mar 24, 2014 at 9:14 AM, Jerry Levan <jerry.levan@gmail.com> wrote:

ERROR: could not seek to end of file "global/12292": Too many open files
LOG: out of file descriptors: Too many open files; release and retry

[...]

Any idea what the problem could have been?

Well, it tells for itself. It is out of file descriptors. Assuming you
are on Linux, the ways to fix it (to increase the limit) are described
by the link [1]http://www.cyberciti.biz/faq/linux-increase-the-maximum-number-of-open-files/. Chose one that suits you better.

[1]: http://www.cyberciti.biz/faq/linux-increase-the-maximum-number-of-open-files/

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com

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

On Mar 24, 2014, at 11:30 AM, Sergey Konoplev <gray.ru@gmail.com> wrote:

On Mon, Mar 24, 2014 at 9:14 AM, Jerry Levan <jerry.levan@gmail.com> wrote:

ERROR: could not seek to end of file "global/12292": Too many open files
LOG: out of file descriptors: Too many open files; release and retry

[...]

Any idea what the problem could have been?

Well, it tells for itself. It is out of file descriptors. Assuming you
are on Linux, the ways to fix it (to increase the limit) are described
by the link [1]. Chose one that suits you better.

This is on the latest MacOSX and generally I have very few apps open.

This is the first time this has happened in over fourteen years of using
Postgresql.

Jerry

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

Jerry Levan wrote:

The other day I attempted to connect to my 9.3.2 postgresql data base and my connection
attempts kept failing.

I found about 100000 lines in the log file that looked like:

ERROR: could not seek to end of file "global/12292": Too many open files
LOG: out of file descriptors: Too many open files; release and retry

I think this means there is a file descriptor leak somewhere; maybe a
third-party module by Apple. It might be useful to see what files are
open by the offending process; in Linux you would just see
ls -l /proc/{pid}/fd
but I don't know if this works on Mac OS X.

--
�lvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

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

On Mar 24, 2014, at 9:43 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

Jerry Levan wrote:

The other day I attempted to connect to my 9.3.2 postgresql data base and my connection
attempts kept failing.

I found about 100000 lines in the log file that looked like:

ERROR: could not seek to end of file "global/12292": Too many open files
LOG: out of file descriptors: Too many open files; release and retry

I think this means there is a file descriptor leak somewhere; maybe a
third-party module by Apple. It might be useful to see what files are
open by the offending process; in Linux you would just see
ls -l /proc/{pid}/fd
but I don't know if this works on Mac OS X.

% sudo lsof

is the tool. It doesn't have to be a leak; if you've ignored the postgres configuration, you could have a potential max clients that exceeds the standard open file limit of the system, which you may have just been lucky in never reaching until a surge in traffic generated enough postgres children to breach the limit. Adjust open file limits for launchd-based agents through /etc/launchd.conf:

https://www.google.com/search?client=safari&amp;rls=en&amp;q=launchd.conf+open+files

~ john

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