You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by de...@db.apache.org on 2004/09/24 23:23:32 UTC
[jira] Created: (DERBY-1) Can't create a new db on OS X
Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-1
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-1
Summary: Can't create a new db on OS X
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Versions:
10.0.2.0
Assignee:
Reporter: Tom Santos
Created: Fri, 24 Sep 2004 2:22 PM
Updated: Fri, 24 Sep 2004 2:22 PM
Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
Re: [jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by Andrew McIntyre <mc...@gmail.com>.
On 10/10/05, Suresh Thalamati (JIRA) <de...@db.apache.org> wrote:
>
> Merged this fix into 10.1 client from trunk and ran all functional tests. All tests passes on jdk142/WindowsXP.
> I like to see this fix in 10.1 branch , it would be great if some one could commit this into 10.1.
Likewise, all tests passed on my Mac for the trunk (latest) and
10.1(patched), with the exception of store/Beetle6038.java, which is
a platform-specific test issue that I'll fix separately.
If there are no objections, I'll merge the fix for DERBY-1 to the 10.1
branch on Monday.
andrew
[jira] Resolved: (DERBY-1) Can't create a new db on OS X
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=all ]
Andrew McIntyre resolved DERBY-1:
---------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
Merged fix to 10.1 branch with revision 326300.
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
> Assignee: Suresh Thalamati
> Fix For: 10.1.2.0, 10.1.1.2, 10.2.0.0
> Attachments: derby1.diff
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by de...@db.apache.org.
The following comment has been added to this issue:
Author: Tom Santos
Created: Sat, 25 Sep 2004 4:30 PM
Body:
The "rwd" patch got it working for me. Thanks much.
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_53411
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-1
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-1
Summary: Can't create a new db on OS X
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Versions:
10.0.2.0
Assignee:
Reporter: Tom Santos
Created: Fri, 24 Sep 2004 2:22 PM
Updated: Sat, 25 Sep 2004 4:30 PM
Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by de...@db.apache.org.
The following comment has been added to this issue:
Author: mario zanier
Created: Sun, 24 Oct 2004 12:58 PM
Body:
hi,
where do i place this derby.properties file with derby.storage.fileSyncTransactionLog=true on os x, to create databases with bash or DBviz ?
regards,
mario
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_54562
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-1
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-1
Summary: Can't create a new db on OS X
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Versions:
10.0.2.0
Assignee:
Reporter: Tom Santos
Created: Fri, 24 Sep 2004 2:22 PM
Updated: Sun, 24 Oct 2004 12:58 PM
Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12317732 ]
Andrew McIntyre commented on DERBY-1:
-------------------------------------
Barnet,
Are you sure you are setting the property derby.storage.fileSyncTransactionLog=true *every* time you start up Derby and connect to the database? You must set this system property every time you start up Derby in order for it to work properly on Mac OS X 10.4 with J2SE 1.5 (JDK 1.5). I am able to create a database and insert data into tables in subsequent sessions so long as I set that system property every time.
FYI, I reported the regression to Apple about a month ago, so they are aware of the problem.
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Samuel Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_65028 ]
Samuel Andrew McIntyre commented on DERBY-1:
--------------------------------------------
The underlying JVM issue has been fixed in Mac OS X 10.4 (Tiger), but remains a problem on Mac OS X 10.3.
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by de...@db.apache.org.
The following comment has been added to this issue:
Author: Suresh Thalamati
Created: Tue, 28 Sep 2004 10:41 AM
Body:
There is a work around for this problem without applying any PATCH.
This problem occurs when "write sync" mechanisms (rws mode) is used to write log. Current system has a flag to disable write sync and use file sync to make sure logs are written to disk on commit.
Write sync mode can be disabled by setting "derby.storage.fileSyncTransactionLog=true" in derby.properties. When this property is set to true logging system does file syncs on commits similar to what happens on jvms before jdk142.
My two cents on the patch:
As Jan mentioned before , I also don't believe "rwd" mode is doing sync writes on MAC OS. If syncs does not occur, users can have unrecoverable databases or lost data. Until Apple fixes "rws/rwd" bug.It would be safer for users to use derby.storage.fileSyncTransactionLog or have another PATCH that will identify MAC OS and make logging system use file sync until JVM bug is fixed.
Although using "rwd" may provide better performance on some OS. I don't think it is safe to fix this problem.
Having OS specific checks is not a clean solution, but I can not think of any other alternative way to fix this problem. Any ideas ?
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_53470
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-1
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-1
Summary: Can't create a new db on OS X
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Versions:
10.0.2.0
Assignee:
Reporter: Tom Santos
Created: Fri, 24 Sep 2004 2:22 PM
Updated: Tue, 28 Sep 2004 10:41 AM
Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by de...@db.apache.org.
The following comment has been added to this issue:
Author: Samuel Andrew McIntyre
Created: Fri, 1 Oct 2004 7:49 PM
Body:
FYI, I have reported the "rws/rwd" mode issue to Apple. It does not appear to have been fixed with the recent Java 1.4.2 Update 2 release.
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_53617
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-1
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-1
Summary: Can't create a new db on OS X
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Versions:
10.0.2.0
Assignee:
Reporter: Tom Santos
Created: Fri, 24 Sep 2004 2:22 PM
Updated: Fri, 1 Oct 2004 7:49 PM
Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by de...@db.apache.org.
The following comment has been added to this issue:
Author: Daniel John Debrunner
Created: Thu, 14 Oct 2004 9:52 AM
Body:
Samuel Andrew McIntyre wrote:
Here is a copy of the bug report I filed with Apple:
Summary:
java.io.RandomAccessFile in Java 1.4.2 Update 1 does not allow reopening files in "rws" mode if they have just been created. When a file is created with "rw" and then shortly thereafter a new RandomAccessFile object is instantiated for the same file in "rws" mode, the JVM throws a FileNotFoundException (File Exists). "rw" and "rwd" modes do not have this problem. This issue is hit when attempting to create or write to a
database with IBM Cloudscape/Apache Derby 10.0.
The testcase referenced above is Suresh's TestWriteSync.java.
http://nagoya.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=232
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_54067
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-1
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-1
Summary: Can't create a new db on OS X
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Versions:
10.0.2.0
Assignee:
Reporter: Tom Santos
Created: Fri, 24 Sep 2004 2:22 PM
Updated: Thu, 14 Oct 2004 9:52 AM
Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-1) Can't create a new db on OS X
Posted by "Suresh Thalamati (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=all ]
Suresh Thalamati reassigned DERBY-1:
------------------------------------
Assign To: Suresh Thalamati
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
> Assignee: Suresh Thalamati
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1) Can't create a new db on OS X
Posted by "Anonymous (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=all ]
updated DERBY-1:
-----------------
Attachment: derby1.diff
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
> Assignee: Suresh Thalamati
> Attachments: derby1.diff
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Kathy Saunders (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_54632 ]
Kathy Saunders commented on DERBY-1:
------------------------------------
Mario,
derby.properties must be placed in derby.system.home. By default derby.system.home is your current directory when you start Derby. You can read more about how to explicitly set derby.system.home to a directory of your choice in the Tuning Guide at http://incubator.apache.org/derby/manuals/tuning/perf14.html#HDRSII-SETPROP-16827.
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Suresh Thalamati (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12331723 ]
Suresh Thalamati commented on DERBY-1:
--------------------------------------
Merged this fix into 10.1 client from trunk and ran all functional tests. All tests passes on jdk142/WindowsXP.
I like to see this fix in 10.1 branch , it would be great if some one could commit this into 10.1.
Merge command:
svn merge -r 306822:306963 https://svn.apache.org/repos/asf/db/derby/code/trunk
Thanks
-suresh
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
> Assignee: Suresh Thalamati
> Attachments: derby1.diff
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Re: [jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by Andrew McIntyre <mc...@gmail.com>.
On 10/4/05, Mike Matrigali <mi...@sbcglobal.net> wrote:
> Given that Apple released a new JVM with this issue broken again, I
> would like to get this into the upcoming bug fix release. Is there
> anyone with a currently broken apple JVM who can try out the patch and
> make sure this still fixes the problem.
My Mac is currently in the midst of a system upgrade, but I'll test
the patch as soon as it is back up.
andrew
Re: [jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by Mike Matrigali <mi...@sbcglobal.net>.
Given that Apple released a new JVM with this issue broken again, I
would like to get this into the upcoming bug fix release. Is there
anyone with a currently broken apple JVM who can try out the patch and
make sure this still fixes the problem.
Suresh Thalamati (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12331234 ]
>
> Suresh Thalamati commented on DERBY-1:
> --------------------------------------
>
> I was hoping this issue will go away , but it seems to have appeared again in jdk1.5. Although there is a workaround by
> setting derby.storage.fileSyncTransactionLog=true. I think for users who are just tryingout Derby , hitting this problem is very annoying.
> Resubmmitting the workaround patch(derby1.diff) for this problem againest main trunk. This patch solves the problem by
> Catching the FileNotFoundException then set log write mode to file Sync and then open the log files in plain "rw" mode.
>
> Although it is a vendor spefic fix , I think it will really help users tryingout derby on Mac. It would be great if some one can review the
> patch and reconsider it for committing into 10.1 and main, if there are no objections from the community.
>
> All tests passed on WIndow Xp.
>
> My vote +1 .
>
>
>
>
>
>>Can't create a new db on OS X
>>-----------------------------
>>
>> Key: DERBY-1
>> URL: http://issues.apache.org/jira/browse/DERBY-1
>> Project: Derby
>> Type: Bug
>> Components: Store
>> Versions: 10.0.2.0
>> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
>> Reporter: Tom Santos
>> Assignee: Suresh Thalamati
>> Attachments: derby1.diff
>>
>>This problem does not occur when I use the same jars on Linux.
>>I am unable to create a new database in ij by using the following command:
>>connect 'jdbc:derby:testdb;create=true';
>>I get the following output:
>>ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
>>ERROR XBM01: Startup failed due to an exception, see next exception for details.
>>ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
>>All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
>>----------------------------------------------------------------
>>2004-09-24 20:33:53.762 GMT:
>> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
>>on database directory /Users/tom/dev/java/derby-bin/lib/testdb
>>2004-09-24 20:33:53.821 GMT:
>>Shutting down instance c013800d-00ff-3226-5601-00000015bd70
>>----------------------------------------------------------------
>>2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
>>ERROR XBM01: Startup failed due to an exception, see next exception for details.
>> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
>> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
>> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
>> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
>> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
>> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
>> at java.sql.DriverManager.getConnection(DriverManager.java:512)
>> at java.sql.DriverManager.getConnection(DriverManager.java:140)
>> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
>> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
>> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
>> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
>> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
>> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
>> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
>> at org.apache.derby.tools.ij.main(ij.java)
>>============= begin nested exception, level (1) ===========
>>java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
>> at java.io.RandomAccessFile.open(Native Method)
>> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
>> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
>> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
>> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
>> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
>> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
>> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
>> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
>> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
>> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
>> at java.sql.DriverManager.getConnection(DriverManager.java:512)
>> at java.sql.DriverManager.getConnection(DriverManager.java:140)
>> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
>> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
>> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
>> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
>> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
>> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
>> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
>> at org.apache.derby.tools.ij.main(ij.java)
>>============= end nested exception, level (1) ===========
>>Cleanup action completed
>>------------------ Java Information ------------------
>>Java Version: 1.4.2_05
>>Java Vendor: Apple Computer, Inc.
>>Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
>>Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
>>OS name: Mac OS X
>>OS architecture: ppc
>>OS version: 10.3.5
>>Java user name: tom
>>Java user home: /Users/tom
>>Java user dir: /Users/tom/dev/java/derby-bin/lib
>>--------- Derby Information --------
>>[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
>>[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
>>[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
>>[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
>>[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
>>------------------------------------------------------
>>----------------- Locale Information -----------------
>>------------------------------------------------------
>
>
Re: [jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by Mike Matrigali <mi...@sbcglobal.net>.
I have committed this change to the trunk. I reviewed the change, and
ran full set of tests on windows 2000. Have not explicitly checked
on apple myself, waiting for feedback there - this fix has been tested
by multiple apple users in the past and did fix the problem. The fix
does not change the behavior on systems where file sync does not
exhibit the problems described in the JIRA entry.
Change: 306963
Suresh Thalamati (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12331234 ]
>
> Suresh Thalamati commented on DERBY-1:
> --------------------------------------
>
> I was hoping this issue will go away , but it seems to have appeared again in jdk1.5. Although there is a workaround by
> setting derby.storage.fileSyncTransactionLog=true. I think for users who are just tryingout Derby , hitting this problem is very annoying.
> Resubmmitting the workaround patch(derby1.diff) for this problem againest main trunk. This patch solves the problem by
> Catching the FileNotFoundException then set log write mode to file Sync and then open the log files in plain "rw" mode.
>
> Although it is a vendor spefic fix , I think it will really help users tryingout derby on Mac. It would be great if some one can review the
> patch and reconsider it for committing into 10.1 and main, if there are no objections from the community.
>
> All tests passed on WIndow Xp.
>
> My vote +1 .
>
>
>
>
>
>>Can't create a new db on OS X
>>-----------------------------
>>
>> Key: DERBY-1
>> URL: http://issues.apache.org/jira/browse/DERBY-1
>> Project: Derby
>> Type: Bug
>> Components: Store
>> Versions: 10.0.2.0
>> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
>> Reporter: Tom Santos
>> Assignee: Suresh Thalamati
>> Attachments: derby1.diff
>>
>>This problem does not occur when I use the same jars on Linux.
>>I am unable to create a new database in ij by using the following command:
>>connect 'jdbc:derby:testdb;create=true';
>>I get the following output:
>>ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
>>ERROR XBM01: Startup failed due to an exception, see next exception for details.
>>ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
>>All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
>>----------------------------------------------------------------
>>2004-09-24 20:33:53.762 GMT:
>> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
>>on database directory /Users/tom/dev/java/derby-bin/lib/testdb
>>2004-09-24 20:33:53.821 GMT:
>>Shutting down instance c013800d-00ff-3226-5601-00000015bd70
>>----------------------------------------------------------------
>>2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
>>ERROR XBM01: Startup failed due to an exception, see next exception for details.
>> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
>> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
>> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
>> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
>> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
>> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
>> at java.sql.DriverManager.getConnection(DriverManager.java:512)
>> at java.sql.DriverManager.getConnection(DriverManager.java:140)
>> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
>> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
>> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
>> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
>> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
>> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
>> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
>> at org.apache.derby.tools.ij.main(ij.java)
>>============= begin nested exception, level (1) ===========
>>java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
>> at java.io.RandomAccessFile.open(Native Method)
>> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
>> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
>> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
>> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
>> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
>> at java.security.AccessController.doPrivileged(Native Method)
>> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
>> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
>> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
>> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
>> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
>> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
>> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
>> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
>> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
>> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
>> at java.sql.DriverManager.getConnection(DriverManager.java:512)
>> at java.sql.DriverManager.getConnection(DriverManager.java:140)
>> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
>> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
>> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
>> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
>> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
>> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
>> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
>> at org.apache.derby.tools.ij.main(ij.java)
>>============= end nested exception, level (1) ===========
>>Cleanup action completed
>>------------------ Java Information ------------------
>>Java Version: 1.4.2_05
>>Java Vendor: Apple Computer, Inc.
>>Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
>>Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
>>OS name: Mac OS X
>>OS architecture: ppc
>>OS version: 10.3.5
>>Java user name: tom
>>Java user home: /Users/tom
>>Java user dir: /Users/tom/dev/java/derby-bin/lib
>>--------- Derby Information --------
>>[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
>>[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
>>[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
>>[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
>>[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
>>------------------------------------------------------
>>----------------- Locale Information -----------------
>>------------------------------------------------------
>
>
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Suresh Thalamati (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12331234 ]
Suresh Thalamati commented on DERBY-1:
--------------------------------------
I was hoping this issue will go away , but it seems to have appeared again in jdk1.5. Although there is a workaround by
setting derby.storage.fileSyncTransactionLog=true. I think for users who are just tryingout Derby , hitting this problem is very annoying.
Resubmmitting the workaround patch(derby1.diff) for this problem againest main trunk. This patch solves the problem by
Catching the FileNotFoundException then set log write mode to file Sync and then open the log files in plain "rw" mode.
Although it is a vendor spefic fix , I think it will really help users tryingout derby on Mac. It would be great if some one can review the
patch and reconsider it for committing into 10.1 and main, if there are no objections from the community.
All tests passed on WIndow Xp.
My vote +1 .
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
> Assignee: Suresh Thalamati
> Attachments: derby1.diff
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by de...@db.apache.org.
The following comment has been added to this issue:
Author: Jan Hlavatý
Created: Fri, 24 Sep 2004 4:46 PM
Body:
Let me warn you though - we got suspiciously high throughput when using "rwd", so we suspect it may not do what it is supposed to do, and crash recovery may not work as good as expected.
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_53406
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-1
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-1
Summary: Can't create a new db on OS X
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Versions:
10.0.2.0
Assignee:
Reporter: Tom Santos
Created: Fri, 24 Sep 2004 2:22 PM
Updated: Fri, 24 Sep 2004 4:46 PM
Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Barnet Wagman (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12317727 ]
Barnet Wagman commented on DERBY-1:
-----------------------------------
Suresh's TestWriteSync test FAILS on Tiger with Java 1.5.0_02
Furthermore, derby.storage.fileSyncTransactionLog=true does not appear to solve
the problem; I am able to create a database, but not add to it in a subsequent session.
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1) Can't create a new db on OS X
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=all ]
Mike Matrigali updated DERBY-1:
-------------------------------
Component: Store
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
was:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12315055 ]
Andrew McIntyre commented on DERBY-1:
-------------------------------------
There is a regression of DERBY-1 in the J2SE 5.0 Release 1 JVM for Mac OS X 10.4. The issue has been fixed in the JDK 1.4.2 JVM for Mac OS X 10.4, which is the default JVM, but identical errors to those seen on Mac OS X 10.3 with JDK 1.4.2 wiill be encountered with the 5.0 JVM for Mac OS X 10.4.
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-1) Can't create a new db on OS X
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=all ]
Kathey Marsden updated DERBY-1:
-------------------------------
Fix Version: 10.1.2.0
10.1.1.2
Changing fixin to 10.1.2 as Andrew indicated he would be merging it to 10.1
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Components: Store
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
> Assignee: Suresh Thalamati
> Fix For: 10.1.2.0, 10.1.1.2
> Attachments: derby1.diff
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Barnet Wagman (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12317799 ]
Barnet Wagman commented on DERBY-1:
-----------------------------------
I was wrong, derby.storage.fileSyncTransactionLog=true does fix the problem on Tiger with Java 1.5
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by de...@db.apache.org.
The following comment has been added to this issue:
Author: Joseph Grace
Created: Fri, 24 Sep 2004 4:01 PM
Body:
This issue has been discussed on derby-dev including a patch which works on OSX and (I believe) should work elsewhere as well. The relevant (thread and) post is:
http://nagoya.apache.org/eyebrowse/ReadMsg?listName=derby-dev@db.apache.org&msgNo=233
It actually includes a fix for another (I suspect) bug as well.
The gist of the fix is to change the write mode from "rws" (which causes an issue on OSX) to the less strenuous "rwd". The difference is that "rws" keeps metadata synchronously (as well as data) whereas "rwd" just does the data (and only the metadata _necessary_ to ensure the data is recoverable). IOW, it's quite possible that "rwd" is the preferred mode for a high performance database.
As for why "rws" has issues on OSX, the issue was unresolved as there are ambiguities in what OSX is doing, and what exactly "rws" should do under certain circumstances. The interesting circumstance in this case is that a data file exists yet (presumably?) associated metadata files do not exist, possibly leading to the error. That's my take on it anyway. I have not had time to track it further, but it works with the patch on OSX.
-=-
I'm not sure what the process is to approve or disapprove my proposed patch.
---------------------------------------------------------------------
View this comment:
http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_53405
---------------------------------------------------------------------
View the issue:
http://issues.apache.org/jira/browse/DERBY-1
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-1
Summary: Can't create a new db on OS X
Type: Bug
Status: Unassigned
Priority: Major
Project: Derby
Versions:
10.0.2.0
Assignee:
Reporter: Tom Santos
Created: Fri, 24 Sep 2004 2:22 PM
Updated: Fri, 24 Sep 2004 4:01 PM
Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
Description:
This problem does not occur when I use the same jars on Linux.
I am unable to create a new database in ij by using the following command:
connect 'jdbc:derby:testdb;create=true';
I get the following output:
ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
ERROR XBM01: Startup failed due to an exception, see next exception for details.
ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
----------------------------------------------------------------
2004-09-24 20:33:53.762 GMT:
Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
on database directory /Users/tom/dev/java/derby-bin/lib/testdb
2004-09-24 20:33:53.821 GMT:
Shutting down instance c013800d-00ff-3226-5601-00000015bd70
----------------------------------------------------------------
2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
ERROR XBM01: Startup failed due to an exception, see next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= begin nested exception, level (1) ===========
java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
at org.apache.derby.impl.tools.ij.Main.go(Main.java)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
at org.apache.derby.tools.ij.main(ij.java)
============= end nested exception, level (1) ===========
Cleanup action completed
------------------ Java Information ------------------
Java Version: 1.4.2_05
Java Vendor: Apple Computer, Inc.
Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
OS name: Mac OS X
OS architecture: ppc
OS version: 10.3.5
Java user name: tom
Java user home: /Users/tom
Java user dir: /Users/tom/dev/java/derby-bin/lib
--------- Derby Information --------
[/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
[/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
[/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Barnet Wagman (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12317741 ]
Barnet Wagman commented on DERBY-1:
-----------------------------------
Yes, my code is
...
System.setProperty("derby.storage.fileSyncTransactionLog","true");
new org.apache.derby.jdbc.EmbeddedDriver();
con = DriverManager.getConnection(...);
...
and I only have one DriverManager.getConnection(...) call, except for an
explicit shutdown:
DriverManager.getConnection("jdbc:derby:;shutdown=true");
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-1) Can't create a new db on OS X
Posted by "Barnet Wagman (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1?page=comments#action_12317371 ]
Barnet Wagman commented on DERBY-1:
-----------------------------------
The problem has NOT been fixed in OS X 10.4 (Tiger), at least not with Java 1.5.0_02; I just tried running Derby on a newly
installed Tiger system with Java 1.5 and get the same problem.
> Can't create a new db on OS X
> -----------------------------
>
> Key: DERBY-1
> URL: http://issues.apache.org/jira/browse/DERBY-1
> Project: Derby
> Type: Bug
> Versions: 10.0.2.0
> Environment: OS X 10.3.5, Java 1.4.2_05, Dual G5
> Reporter: Tom Santos
>
> This problem does not occur when I use the same jars on Linux.
> I am unable to create a new database in ij by using the following command:
> connect 'jdbc:derby:testdb;create=true';
> I get the following output:
> ERROR XJ041: Failed to create database 'testdb', see the next exception for details.
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> ERROR XJ001: Java exception: '/Users/tom/dev/java/derby-bin/lib/testdb/log/log1.dat (File exists): java.io.FileNotFoundException'.
> All users have write permissions to the directory so it's not getting blocked there. I'm not sure what's going on. I've included the contents of derby.log below. I've also included the result of running sysinfo on my machine below that.
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.762 GMT:
> Booting Derby version IBM Corp. - Apache Derby - 10.0.2.0 - (30301): instance c013800d-00ff-3226-5601-00000015bd70
> on database directory /Users/tom/dev/java/derby-bin/lib/testdb
> 2004-09-24 20:33:53.821 GMT:
> Shutting down instance c013800d-00ff-3226-5601-00000015bd70
> ----------------------------------------------------------------
> 2004-09-24 20:33:53.837 GMT Thread[main,5,main] Cleanup action starting
> ERROR XBM01: Startup failed due to an exception, see next exception for details.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
> at org.apache.derby.iapi.services.monitor.Monitor.exceptionStartingModule(Monitor.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= begin nested exception, level (1) ===========
> java.io.FileNotFoundException: /Users/tom/dev/java/derby-bin/lib/log/log1.dat (File exists)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.run(LogToFile.java)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.log.LogToFile.privRandomAccessFile(LogToFile.java)
> at org.apache.derby.impl.store.raw.log.LogToFile.boot(LogToFile.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.bootLogFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.setRawStoreFactory(BaseDataFileFactory.java)
> at org.apache.derby.impl.store.raw.RawStore.boot(RawStore.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(RAMAccessManager.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Monitor.java)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(BasicDatabase.java)
> at org.apache.derby.impl.db.BasicDatabase.boot(BasicDatabase.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(TopService.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(BaseMonitor.java)
> at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(BaseMonitor.java)
> at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Monitor.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
> at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
> at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:140)
> at org.apache.derby.impl.tools.ij.ij.dynamicConnection(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ConnectStatement(ij.java)
> at org.apache.derby.impl.tools.ij.ij.ijStatement(ij.java)
> at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java)
> at org.apache.derby.impl.tools.ij.Main.go(Main.java)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java)
> at org.apache.derby.impl.tools.ij.Main14.main(Main14.java)
> at org.apache.derby.tools.ij.main(ij.java)
> ============= end nested exception, level (1) ===========
> Cleanup action completed
> ------------------ Java Information ------------------
> Java Version: 1.4.2_05
> Java Vendor: Apple Computer, Inc.
> Java home: /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
> Java classpath: /Users/tom/dev/java/derby-bin/lib/derby.jar:/Users/tom/dev/java/derby-bin/lib/derbytools.jar:/Users/tom/dev/java/derby-bin/lib/derbynet.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc.jar:/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar
> OS name: Mac OS X
> OS architecture: ppc
> OS version: 10.3.5
> Java user name: tom
> Java user home: /Users/tom
> Java user dir: /Users/tom/dev/java/derby-bin/lib
> --------- Derby Information --------
> [/Users/tom/dev/java/derby-bin/lib/derby.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbytools.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/derbynet.jar] 10.0.2.0 - (46005)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc.jar] 2.4 - (17)
> [/Users/tom/dev/java/derby-bin/lib/db2jcc_license_c.jar] 2.4 - (17)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> ------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira