From derby-user-return-13041-apmail-db-derby-user-archive=db.apache.org@db.apache.org Thu Aug 12 16:42:40 2010 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 86212 invoked from network); 12 Aug 2010 16:42:40 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 12 Aug 2010 16:42:40 -0000 Received: (qmail 43032 invoked by uid 500); 12 Aug 2010 16:42:40 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 42915 invoked by uid 500); 12 Aug 2010 16:42:39 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 42908 invoked by uid 99); 12 Aug 2010 16:42:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Aug 2010 16:42:38 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of david.vancouvering@gmail.com designates 209.85.161.44 as permitted sender) Received: from [209.85.161.44] (HELO mail-fx0-f44.google.com) (209.85.161.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Aug 2010 16:42:34 +0000 Received: by fxm18 with SMTP id 18so963344fxm.31 for ; Thu, 12 Aug 2010 09:42:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:sender:received :in-reply-to:references:from:date:x-google-sender-auth:message-id :subject:to:content-type; bh=lebAEomYHvALq9oPM9Iel5EdThFYmtKMkNrTGOi/A9U=; b=kvPSKxDp68fBpKI0e6+TUBwKd+MSaIQubm9/cd20hthQ7HhMSt2nJDPVXCpJyBNvpY cbmkS8foB1qKt4MkxITotZ/9Il5tVC0kn313r9SNDPhK5B3flYMgY0/qO4B8lWCAViaM FizWGBzfvXZIYG2Qz/DO7OhI3yGZrVpcgtaT4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:content-type; b=XM15GICko69f2WwXwc5vFZ1uf3ZN8Yy/LZd5DKNDEMbldlN9KdHULJqodX3VnzrpX7 Ehei9bBtSbybdlw4QSVUnIT3qFKMAgTRDZkitNXKkzidCelpUEQtRCSZ93+5WmDQCQke 7tRQZM1agzf0dXwCTDp8scX7MSaOFRzem16Rc= Received: by 10.239.148.142 with SMTP id f14mr31774hbb.27.1281631333173; Thu, 12 Aug 2010 09:42:13 -0700 (PDT) MIME-Version: 1.0 Sender: david.vancouvering@gmail.com Received: by 10.239.172.139 with HTTP; Thu, 12 Aug 2010 09:41:53 -0700 (PDT) In-Reply-To: <4C638D7D.3010906@oracle.com> References: <4C611254.1070002@oracle.com> <4C638D7D.3010906@oracle.com> From: David Van Couvering Date: Thu, 12 Aug 2010 09:41:53 -0700 X-Google-Sender-Auth: EVrDUGw1fzkTGHJBlbHE8v9TB4E Message-ID: Subject: Re: "Can't find database" To: Derby Discussion Content-Type: multipart/alternative; boundary=001485f1dbc458cbc3048da30ce2 --001485f1dbc458cbc3048da30ce2 Content-Type: text/plain; charset=ISO-8859-1 Yes, there is definitely the possibility of multiple threads trying to boot the database. I'll look into that. This appears to be happening on 64-bit Windows machines only, but that could be a machine-related timing, or it could be the 64-bit VM. On Wed, Aug 11, 2010 at 10:58 PM, Kristian Waagan < kristian.waagan@oracle.com> wrote: > On 12.08.10 01:07, David Van Couvering wrote: > > Looks like it was a slash/forward-slash issue. I changed my code to use > File.separator and this very strange bug (it would only happen sometimes, > and only on some machines) looks like it has gone away. > > > Since the problem is intermittent, could it be caused by multiple threads > trying to boot the database? > And in case somebody wants to pursue this issue later, do you know if it > happened across a range of different JVMs? > > > Thanks, > -- > Kristian > > > > Thanks, > > David > > On Tue, Aug 10, 2010 at 1:48 AM, Kristian Waagan < > kristian.waagan@oracle.com> wrote: > >> On 09.08.10 23:55, David Van Couvering wrote: >> >> I am getting these intermittent errors that I can't reproduce on my >> machine: >> >> Database 'C:\VontuDev\main\dist\scan\incremental_index/MONITOR/INCREMENTAL_INFO' not found >> >> >> I read the docs, and there is no discussion about whether a mixed "\" "/" >> path is a problem on some systems. Could it be? Do I need to normalize the >> path to all forward slashes? >> >> >> Hi David, >> >> I guess there can be problems related to mixing different path separators, >> but testing on OpenSolaris does suggest that the monitor and the in-memory >> back end are capable of handling it: >> >> java -Dderby.system.home="C:\VontuDev\main\dist\scan\incremental_index" >> -cp classes org.apache.derby.tools.ij >> ij version 10.7 >> ij> connect 'jdbc:derby:memory:MONITOR/INCREMENTAL_INFO;create=true'; >> ij> >> >> Then, from derby.log: >> >> memory:/home/user/derby/wdir/trunk-netbeans/C:\VontuDev\main\dist\scan\incremental_index/MONITOR/INCREMENTAL_INFO >> >> However, trying this with an on-disk database fails. My guess is because >> I'm on UNIX, and then the colon from c:\ shows up in a place it's not >> supposed to be. >> In general, I think your mileage depends on what java.io.File is capable >> of, but there might be problems in the explicit path handling within Derby. >> >> Do you get an assert failure if you run with a sane build when you try to >> boot the database? >> >> >> Regards, >> -- >> Kristian >> >> >> >> >> What can cause this error to happen? I checked, and the directory is >> there on the system. >> >> Thanks, >> >> David >> >> -- >> David W. Van Couvering >> >> http://www.linkedin.com/in/davidvc >> http://davidvancouvering.blogspot.com >> http://twitter.com/dcouvering >> >> >> > > > -- > David W. Van Couvering > > http://www.linkedin.com/in/davidvc > http://davidvancouvering.blogspot.com > http://twitter.com/dcouvering > > > -- David W. Van Couvering http://www.linkedin.com/in/davidvc http://davidvancouvering.blogspot.com http://twitter.com/dcouvering --001485f1dbc458cbc3048da30ce2 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Yes, there is definitely the possibility of multiple threads trying to boot= the database.=A0 I'll look into that.

This appears to be happen= ing on 64-bit Windows machines only, but that could be a machine-related ti= ming, or it could be the 64-bit VM.

On Wed, Aug 11, 2010 at 10:58 PM, Kristian W= aagan <k= ristian.waagan@oracle.com> wrote:
=20 =20
On 12.08.10 01:07, David Van Couvering wrote:
Looks like it was a slash/forward-slash issue.=A0= I changed my code to use File.separator and this very strange bug (it would only happen sometimes, and only on some machines) looks like it has gone away.

Since the problem is intermittent, could it be caused by multiple threads trying to boot the database?
And in case somebody wants to pursue this issue later, do you know if it happened across a range of different JVMs?


Thanks,
--
Kristian



Thanks,

David

On Tue, Aug 10, 2010 at 1:48 AM, Kristian Waagan <kristian.waagan@oracle.com> wrote:
On 09.08.10 23:55, David Van Couvering wrote:
I am getting these intermittent errors that I can't reproduce on my machine:

Database 'C:\VontuDev\main\dist\scan\incremental_ind=
ex/MONITOR/INCREMENTAL_INFO' not found

I read the docs, and there is no discussion about whether a mixed "\&q= uot; "/" path is a problem on some systems.=A0 Could it be?=A0 Do I ne= ed to normalize the path to all forward slashes?

Hi David,

I guess there can be problems related to mixing different path separators, but testing on OpenSolaris does suggest that the monitor and the in-memory back end are capable of handling it:

java -Dderby.system.home=3D"C:\VontuDev\main\dist\scan\incremental_ind= ex" -cp classes org.apache.derby.tools.ij
ij version 10.7
ij> connect 'jdbc:derby:memory:MONITOR/INCREMENTAL_INFO;create=3Dtru= e';
ij>

Then, from derby.log:
memory:/home/user/derby/wdir/trunk-netbeans/C:\VontuDev\main\dist\scan\incr= emental_index/MONITOR/INCREMENTAL_INFO

However, trying this with an on-disk database fails. My guess is because I'm on UNIX, and then the colon from c:\ shows up in a place it's not supposed to be.
In general, I think your mileage depends on what java.io.File is capable of, but there might be problems in the explicit path handling within Derby.

Do you get an assert failure if you run with a sane build when you try to boot the database?


Regards,
--
Kristian




What can cause this error to happen?=A0 I checked, and the directory is there on the system.

Thanks,

David

--
David W. Van Couvering

http= ://www.linkedin.com/in/davidvc
h= ttp://davidvancouvering.blogspot.com
http://tw= itter.com/dcouvering




--
David W. Van Couvering

http://w= ww.linkedin.com/in/davidvc
http:= //davidvancouvering.blogspot.com
http://twitte= r.com/dcouvering




--
David W. Van Couvering<= br>
http://www.linkedin.c= om/in/davidvc
http= ://davidvancouvering.blogspot.com
http://twitter.com/dcouvering=
--001485f1dbc458cbc3048da30ce2--