From: | Thomas Mack <mack(at)ips(dot)cs(dot)tu-bs(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Too many open files... |
Date: | 2000-01-21 13:16:45 |
Message-ID: | 38885C3D.E20C0468@infbssys.ips.cs.tu-bs.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Well, we got a problem with postgres 6.5.2 on SOlaris 2.6, when:
1) Executing a query with a trigger behind it, making quite a big amount
of
queries on different relations,
2) and when this query is executed from an applet via a servlet on
Apache 1.3.3
using postgresql.jar as db driver.
So, the message is:
ERROR: Load of file /usr/dblocal/pgsql/lib/plpgsql.so failed: ld.so.1:
/usr/dblocal/pgsql/bin/postmaster: fatal: /dev/zero: open failed: Too
many open files
(or similar).
The problem does not exist, if we execute it via psql.
So I tracked it down to dlopen(filename,1). But really, I do not know,
what might
be the real reason for the failure: is it postgres (probably not),
Apache, restricting
the environment "somehow", or postgresql.jar (it should just give the
query to the
backend, so probably not as well), or Solaris itself (but why do I not
get an error,
if I execute it via psql?) or where should I check further?
I am a little confused on how to repair the problem, as it is most
probably not
a problem with postgres. Anybody had similar experiences or even a
solution (besides
not using the trigger)?
Thanks,
Thomas Mack
TU Braunschweig, Abt. Informationssysteme
From | Date | Subject | |
---|---|---|---|
Next Message | Jose Soares | 2000-01-21 13:50:02 | Re: [GENERAL] Re: weird sum() results |
Previous Message | Benjamin Cochran | 2000-01-21 07:57:14 | trouble with the postmaster |