Too Many Open Files - Linux 5.0

[Nancy Palmquist]

  On 10/11/2010 7:12 PM, Nancy Palmquist wrote:
>    I know something is wrong. The following is a dump of @ALLFILES[]
>
> Starting with element 422 (450-423 are blank) I get a bunch of the same
> thing.
>
> Right before this I used getnext to find all the entries that match one
> inquiry number.  There could easily have been hundreds, but each access
> should not list the same index.
>
> * 10/11/10 19:04:53 --------------------------------  START
> * Start: F10500385482000
> * ---------------------------------
> * ========= 422-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 421-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 420-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 419-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 418-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 417-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 416-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 415-/home/appl/filepro/mrxmlinqy/index10.D
>
> [snip] everything from 414 to 17 - they are all the same
>
> * ========= 16-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 15-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 14-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 13-/home/appl/filepro/mrxmlinqy/index10.D
> * ========= 12-/home/appl/filepro/metrodb/index.A
> * ========= 11-/home/appl/filepro/xmltransID/index.E
> * ========= 10-/home/appl/filepro/xmltransID/index.D
> * ========= 9-/home/appl/filepro/xmltransID/index.C
> * ========= 8-/home/appl/filepro/xmltransID/index.B
> * ========= 7-/home/appl/filepro/xmltransID/index.A
> * ========= 6-/home/appl/tmp/rpX2ug1r
> * ========= 5-/home/appl/filepro/xmltransID/index.E
> * ========= 4-/home/appl/filepro/xmltransID/index.D
> * ========= 3-/home/appl/filepro/xmltransID/index.C
> * ========= 2-/home/appl/filepro/xmltransID/index.B
> * ========= 1-/home/appl/filepro/xmltransID/index.A
> * Start: E09300241396000
>
> I did a CLOSE before the Start at the bottom and then it crashed when I tried to do the next inquiry processing.
> I tried running this in readonly to make sure it was not updating anything.
>
> This has run in the past but it has been a few months since I ran this report.
>
> I get too many open files - 60 is the limit. I have to get this running.  It seems to affect more than just this report.
>
> Any ideas.
> Nancy

Update info.  This file is shared across an NSF mount, I was using it 
from the source drive, not the mounted drive.  I copied the key to a 
qualifier, built fresh indexes for the qualifier and the processes run 
perfectly.
My conclusion is that it is an issue with the NSF mount somehow.  I have 
no idea how to troubleshoot that issue, but I just wanted to post the 
suspect, in case someone else is having issues.

When I ran it from the qualifer, the @allfiles[] did not have the 
mrxmlinqy/index10.D repeated over 400 times.  It was just there once.  
Not sure what is happening in filePro but something is certainly funky.

Nancy


-- 
Nancy Palmquist         MOS&  filePro Training Available
Virtual Software Systems    Web Based Training and Consulting
PHONE: (412) 835-9417           Web site:  http://www.vss3.com