You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by David Van Couvering <da...@vancouvering.com> on 2010/08/09 23:55:40 UTC
"Can't find database"
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?
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
Re: "Can't find database"
Posted by David Van Couvering <da...@vancouvering.com>.
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
Re: "Can't find database"
Posted by Kristian Waagan <kr...@oracle.com>.
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 <ma...@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
Re: "Can't find database"
Posted by David Van Couvering <da...@vancouvering.com>.
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.
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
Re: "Can't find database"
Posted by Kristian Waagan <kr...@Oracle.COM>.
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