Return-Path: 
 <derby-user-return-10974-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 17796 invoked from network); 14 May 2009 12:53:12 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 14 May 2009 12:53:12 -0000
Received: (qmail 56672 invoked by uid 500); 14 May 2009 12:53:12 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 56597 invoked by uid 500); 14 May 2009 12:53:11 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 56589 invoked by uid 99); 14 May 2009 12:53:11 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 May 2009 12:53:11 +0000
X-ASF-Spam-Status: No, hits=1.2 required=10.0
	tests=SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [68.142.198.206] (HELO smtp107.sbc.mail.mud.yahoo.com)
 (68.142.198.206)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 14 May 2009 12:53:02 +0000
Received: (qmail 9768 invoked from network); 14 May 2009 12:52:40 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=sbcglobal.net;
  h=Received:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding;
  b=jyUkUGfzXiyDpLaRrOjYVK1msEqQrNQHIQCwaUj7Ioe66AWISpEvibWi6kQTeygUfxofyKGKr/ZlYf+iz/yxJWlTixF5rrl1b+gIM+3+aVn1wvbEubNKyRpwTr7x1/u77ReG25adZhIWUmEV2iT9IWuGj/VK8uCV6W1RBMxJJcY=
  ;
Received: from unknown (HELO ?192.168.1.101?) (kmarsdenderby@70.137.143.252
 with plain)
  by smtp107.sbc.mail.mud.yahoo.com with SMTP; 14 May 2009 12:52:39 -0000
X-YMail-OSG: 
 YTb6..UVM1kcQJHgCf98rbKlchD76pjIoqqY0iC2MDKswGzs1ihffHkhJLtgIz3PDqUqAffELPLxQQLfx.UNxNUeeAT9l0uhqu6uPLCrYBFI2oxD5BWEjdShEGvpt8iZ4A4c1EYfexUCvTTg0GgXOs53BHc8y4kUw_4vfhE2qfEOGGPyBjk7c.djl4yB5EoE0POFNQbJQqVVS02NkUNegsmJkPm8sSJxJA8VdDE6QV4pFSHIs7LTcpiGD9R6etFFitJmTM78NxLOk1ygG_Hiop7Eb_OfZMy1Y7qqAaNj1ZOCz_1Xij2ccJNMb_ro5XaB3kAROKMs74lDr14mHF6zjg--
X-Yahoo-Newman-Property: ymail-3
Message-ID: <4A0C140C.3080408@sbcglobal.net>
Date: Thu, 14 May 2009 05:52:28 -0700
From: Kathey Marsden <kmarsdenderby@sbcglobal.net>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: Unexplained exception: temp file cannot be found
References: <guee68$ove$1@ger.gmane.org> <x1oxfxf84csu.fsf@sun.com>
In-Reply-To: <x1oxfxf84csu.fsf@sun.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org


> Tim Dudgeon <tdudgeon@informaticsmatters.com> 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