Re^2: Too many open files error with DBD Oracle

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?

Comment on Re^2: Too many open files error with DBD Oracle

Replies are listed 'Best First'.
Re^3: Too many open files error with DBD Oracle by almut (Canon) on Jun 23, 2010 at 16:55 UTC
Presumably a problem on the Oracle side — seems to be an old issue... See file handles staying open on ocius.msb.	[reply]
Re^4: Too many open files error with DBD Oracle by JoeW (Novice) on Jun 23, 2010 at 18:26 UTC
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	[reply]
Re^5: Too many open files error with DBD Oracle by BrowserUk (Patriarch) on Jun 23, 2010 at 19:12 UTC
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. Rather than making wholesale changes to what you have working, if instead of creating 25 new threads, connections & filehandles within the same process to process each new input file; restart() the entire process. That way you get a clean slate for everything. ()If Solaris is a forky OS, then that might be the way to go.	[reply]
Re^6: Too many open files error with DBD Oracle by JoeW (Novice) on Jun 28, 2010 at 13:56 UTC