Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Too many open files error with DBD Oracle

by Fletch (Bishop)
on Jun 23, 2010 at 14:57 UTC ( [id://846096]=note: print w/replies, xml ) Need Help??


in reply to Too many open files error with DBD Oracle

Anecdotal, but keep this in mind:

At one time Solaris had a ridiculously (FSVO rediculous) low default for number of file descriptors per process (not per thread; also not to mention I want to say there was a buglet that the stdio library used an unsigned int so even if you raised the resource limit things going through fopen etc would still crap out quickly (again, FSVO quickly; I remember easily hitting it often with mod_perl)).

To debug you might use truss and watch for open(2)-like calls (things like socket(2) as well) and close calls watching that they match up to make sure something's not leaking descriptors. That number 9 * 25 is 225 which is awful close to 254 which was where the stdio problem reared its head.

Update: Reformatted and extended.

The cake is a lie.
The cake is a lie.
The cake is a lie.

Replies are listed 'Best First'.
Re^2: Too many open files error with DBD Oracle
by JoeW (Novice) on Jun 23, 2010 at 16:44 UTC
    Excellent, thanks - I hadn't used truss before - very useful.

    Assuming when I see
    open("/data/oracle/product/10.2.0.4/rdbms/mesg/ocius.msb", O_RDONLY) = 99
    I should subsequently see
    close(99)

    Then I seem to have found a problem with above mentioned file open - there are 225 of them, and none is closed.
    Not sure where this leaves me - is this a bug in DBD that I should raise?
        aha, thanks for that. Well, this has been very helpful - I think I need to rethink the way I'm using files and Oracle connections to work around this (e.g. re-using the connection rather than disconnecting for each iteration), as my options for changing the Oracle install are limited.
        Cheers

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://846096]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (3)
As of 2024-03-19 02:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found