Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 4063 invoked from network); 5 Aug 2005 01:40:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Aug 2005 01:40:56 -0000 Received: (qmail 30366 invoked by uid 500); 5 Aug 2005 01:40:53 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 30330 invoked by uid 500); 5 Aug 2005 01:40:53 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 30312 invoked by uid 99); 5 Aug 2005 01:40:53 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=SPF_FAIL X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Aug 2005 18:40:40 -0700 Received: from ajax.apache.org (ajax.apache.org [127.0.0.1]) by ajax.apache.org (Postfix) with ESMTP id EE1F8E5 for ; Fri, 5 Aug 2005 03:40:36 +0200 (CEST) Message-ID: <827324636.1123206036974.JavaMail.jira@ajax.apache.org> Date: Fri, 5 Aug 2005 03:40:36 +0200 (CEST) From: "Andrew McIntyre (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-1) Can't create a new db on OS X In-Reply-To: <1419916290.1096061012193.JavaMail.apache@nagoya> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ 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.(EmbedConnection.java) > at org.apache.derby.impl.jdbc.EmbedConnection20.(EmbedConnection20.java) > at org.apache.derby.impl.jdbc.EmbedConnection30.(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.(RandomAccessFile.java:204) > at org.apache.derby.impl.io.DirRandomAccessFile.(DirRandomAccessFile.java) > at org.apache.derby.impl.io.DirRandomAccessFile4.(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.(EmbedConnection.java) > at org.apache.derby.impl.jdbc.EmbedConnection20.(EmbedConnection20.java) > at org.apache.derby.impl.jdbc.EmbedConnection30.(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