Just to update on some of the details:
1. This is on Vista. Not sure whether there is a limit on the number of
open files, but I expect this isn't the problem.
2. The table from which the row is being deleted does not contain any
BLOB or CLOB columns.
3. Potentially there is a cascasde delete involved, but in this
particular case I don't believe there would be any dependent rows that
would also be deleted. Also this delete was not part of a cascade
delete. As far as I can work out all that is involved is the deletion of
a single row. However it was part of a transaction involving other things.
Tim
Kathey Marsden wrote:
Tim Dudgeon
<[email protected]> writes:
I have a report from a user of our app that uses embedded Derby
(10.4.2.0).
java.io.FileNotFoundException:
C:\Users\Csizi\Documents\IJCProjects\ijc-project\.config\localdb\db\tmp\T1242138251428.tmp
(The system cannot find the path specified)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(Unknown Source)
I see a similar error in:
https://issues.apache.org/jira/browse/DERBY-1661
The fix for that issue describes it as an incremental improvement, so I
don't know if it could still occur or if DEFAULT_MAX_MERGE_RUN is
relevant to a delete.
I wonder if upping the file descriptors (usually done with ulimit) would
help in this case.
http://db.apache.org/derby/docs/10.4/devguide/cdevstart39409.html
Kathey
If it is too many open files it would be good to get a reproduction so
we could at least try to throw a better error message.
Kathey
