db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject Re: Unexplained exception: temp file cannot be found
Date Thu, 14 May 2009 15:02:40 GMT
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.


Kathey Marsden wrote:
>> Tim Dudgeon 
>> <tdudgeon@informaticsmatters.com> writes:
>>> I have a report from a user of our app that uses embedded Derby 
>>> (
>>>     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

View raw message