Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7C44275CF for ; Thu, 15 Dec 2011 21:40:04 +0000 (UTC) Received: (qmail 62242 invoked by uid 500); 15 Dec 2011 21:40:04 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 62202 invoked by uid 500); 15 Dec 2011 21:40:03 -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: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 62195 invoked by uid 99); 15 Dec 2011 21:40:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Dec 2011 21:40:03 +0000 X-ASF-Spam-Status: No, hits=-2001.5 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Dec 2011 21:39:53 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id ACC83115E57 for ; Thu, 15 Dec 2011 21:39:30 +0000 (UTC) Date: Thu, 15 Dec 2011 21:39:30 +0000 (UTC) From: "Mike Matrigali (Commented) (JIRA)" To: derby-dev@db.apache.org Message-ID: <1082602966.17155.1323985170709.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <173890570.16211.1323969750637.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (DERBY-5544) corrupt database MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-5544?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13170509#comment-13170509 ] Mike Matrigali commented on DERBY-5544: --------------------------------------- yes, derby derby depends on the filesystem so there is not much it can do. Probably should close this issue. I took a look at the offending routine and it was not obvious where the null pointer was coming from. If you ever get a chance to run it wih a sane server and get a line number then we could file a JIRA to get a better error in this situation. Do include the derby.log as sometimes it includes nested exceptions which may tell a better story of what is breaking. > corrupt database > ---------------- > > Key: DERBY-5544 > URL: https://issues.apache.org/jira/browse/DERBY-5544 > Project: Derby > Issue Type: Bug > Affects Versions: 10.8.2.2 > Environment: Java(TM) SE Runtime Environment (build 1.6.0_26-b03) > derby 10.8.2.2 > solaris, zfs, 64 bit > Reporter: Sean Bridges > > I'm getting an exception opening a derby database, > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Failed to start database '/data1/derby/db' with class loader sun.misc.Launcher$AppClassLoader@37b90b39, see the next exception for details.) > at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) > at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) > at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > at message_archiver.kraken.derby.DerbyDbPool.start(DerbyDbPool.java:147) > ... 3 more > Caused by: java.sql.SQLException: Failed to start database '/data1/derby/db' with class loader sun.misc.Launcher$AppClassLoader@37b90b39, see the next exception for details. > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source) > at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) > at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) > at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) > at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) > at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) > at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) > at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) > ... 6 more > Caused by: java.sql.SQLException: Failed to start database '/data1/message-storage/data/kraken/commitlog/derby/db' with class loader sun.misc.Launcher$AppClassLoader@37b90b39, see the next exception for details. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) > ... 20 more > Caused by: java.sql.SQLException: Java exception: ': java.lang.NullPointerException'. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) > at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source) > ... 17 more > Caused by: java.lang.NullPointerException > at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source) > at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openDroppedContainer(Unknown Source) > at org.apache.derby.impl.store.raw.xact.Xact.openDroppedContainer(Unknown Source) > at org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(Unknown Source) > at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown Source) > at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source) > at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source) > at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) > at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) > at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) > at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) > at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source) > at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source) > at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source) > ... 17 more > The database is 7 gigs, so I can't easily upload it. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira