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 5029B74D6 for ; Wed, 7 Dec 2011 20:33:02 +0000 (UTC) Received: (qmail 60318 invoked by uid 500); 7 Dec 2011 20:33:02 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 60292 invoked by uid 500); 7 Dec 2011 20:33:02 -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 60285 invoked by uid 99); 7 Dec 2011 20:33:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Dec 2011 20:33:02 +0000 X-ASF-Spam-Status: No, hits=-2001.2 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; Wed, 07 Dec 2011 20:33:00 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id E0069106EC4 for ; Wed, 7 Dec 2011 20:32:39 +0000 (UTC) Date: Wed, 7 Dec 2011 20:32:39 +0000 (UTC) From: "Kathey Marsden (Resolved) (JIRA)" To: derby-dev@db.apache.org Message-ID: <716031282.50651.1323289959919.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <1466685988.7747.1311693074927.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Resolved] (DERBY-5353) java.sql.SQLException: Failed to start database MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-5353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden resolved DERBY-5353. ----------------------------------- Resolution: Cannot Reproduce Closing cannot reproduce as we have not heard back more information from the user > java.sql.SQLException: Failed to start database > ----------------------------------------------- > > Key: DERBY-5353 > URL: https://issues.apache.org/jira/browse/DERBY-5353 > Project: Derby > Issue Type: Bug > Components: Store > Reporter: Shrikanth Holla > > The derby database fails to start with below exception > Jul 22 15:06:30 isn20cmt {NPM}: main [InitializeCmdr] Telling Database (100) to startup... > Jul 22 15:06:35 isn20cmt {NPM}: java.sql.SQLException: Failed to start database '/data/npm/data > base/derbyDB', see the next exception for details. > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQ > LException(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.Util.newEmbedSQLException > (Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.Util.seeNextException(Unk > nown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.EmbedConnection.bootDatab > ase(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.EmbedConnection.(Un > known Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.EmbedConnection30.( > Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.jdbc.Driver30.getNewEmbedConnection > (Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.jdbc.InternalDriver.connect(Unknown > Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.jdbc.AutoloadedDriver.connect(Unkno > wn Source) > Jul 22 15:06:35 isn20cmt {NPM}: at java.sql.DriverManager.getConnection(DriverManager.j > ava:525) > Jul 22 15:06:35 isn20cmt {NPM}: at java.sql.DriverManager.getConnection(DriverManager.j > ava:140) > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.NpmServer.DatabaseManager.Da > tabaseConnection.initialize(DatabaseConnection.java:314) > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.NpmServer.DatabaseManager.Da > tabaseManager.beginStartUp(DatabaseManager.java:877) > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.Framework.InitializeCmdr.inv > okeStartUp(InitializeCmdr.java:112) > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.NpmServer.StartUp.PatchStart > Up.main(PatchStartUp.java:196) > Jul 22 15:06:35 isn20cmt {NPM}: Caused by: java.sql.SQLException: Page Page(2,Container(0, 1216 > )) is at version 1,171, the log file contains change version 1,215, either there are log record > s of this page missing, or this page did not get written out to disk properly. > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQ > LException(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.Util.generateCsSQLExcepti > on(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: ... 12 more > Jul 22 15:06:35 isn20cmt {NPM}: Caused by: ERROR XSDB4: Page Page(2,Container(0, 1216)) is at v > ersion 1,171, the log file contains change version 1,215, either there are log records of this > page missing, or this page did not get written out to disk properly. > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.iapi.error.StandardException.newExc > eption(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.raw.data.PageBasicOperat > ion.needsRedo(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.raw.log.FileLogger.redo( > Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.raw.log.LogToFile.recove > r(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.raw.RawStore.boot(Unknow > n Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.b > oot(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.TopService.bo > otModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.s > tartModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.iapi.services.monitor.Monitor.bootS > erviceModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.access.RAMAccessManager. > boot(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.b > oot(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.TopService.bo > otModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.s > tartModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.iapi.services.monitor.Monitor.bootS > erviceModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.db.BasicDatabase.bootStore(Unk > nown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.db.BasicDatabase.boot(Unknown > Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.b > oot(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.TopService.bo > otModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.b > ootService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.s > tartProviderService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.f > indProviderAndStartService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.s > tartPersistentService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.iapi.services.monitor.Monitor.start > PersistentService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: ... 12 more > Jul 22 15:06:35 isn20cmt {NPM}: main [InitializeCmdr] Database (100) threw an exception during > shutdown. java.lang.Exception: java.sql.SQLException: Failed to start database '/data/npm/data > base/derbyDB', see the next exception for details. > Jul 22 15:06:35 isn20cmt {NPM}: java.lang.Exception: java.sql.SQLException: Failed to start dat > abase '/data/npm/database/derbyDB', see the next exception for details. > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.NpmServer.DatabaseManager.Da > tabaseManager.beginStartUp(DatabaseManager.java:957) > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.Framework.InitializeCmdr.inv > okeStartUp(InitializeCmdr.java:112) > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.NpmServer.StartUp.PatchStart > Up.main(PatchStartUp.java:196) > Jul 22 15:06:35 isn20cmt {NPM}: Caused by: java.sql.SQLException: Failed to start database '/da > ta/npm/database/derbyDB', see the next exception for details. > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQ > LException(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.Util.newEmbedSQLException > (Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.Util.seeNextException(Unk > nown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.EmbedConnection.bootDatab > ase(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.EmbedConnection.(Un > known Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.EmbedConnection30.( > Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.jdbc.Driver30.getNewEmbedConnection > (Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.jdbc.InternalDriver.connect(Unknown > Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.jdbc.AutoloadedDriver.connect(Unkno > wn Source) > Jul 22 15:06:35 isn20cmt {NPM}: at java.sql.DriverManager.getConnection(DriverManager.j > ava:525) > Jul 22 15:06:35 isn20cmt {NPM}: at java.sql.DriverManager.getConnection(DriverManager.j > ava:140) > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.NpmServer.DatabaseManager.Da > tabaseConnection.initialize(DatabaseConnection.java:314) > Jul 22 15:06:35 isn20cmt {NPM}: at com.nortel.patching.npm.NpmServer.DatabaseManager.Da > tabaseManager.beginStartUp(DatabaseManager.java:877) > Jul 22 15:06:35 isn20cmt {NPM}: ... 2 more > Jul 22 15:06:35 isn20cmt {NPM}: Caused by: java.sql.SQLException: Page Page(2,Container(0, 1216 > )) is at version 1,171, the log file contains change version 1,215, either there are log record > s of this page missing, or this page did not get written out to disk properly. > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQ > LException(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.Util.generateCsSQLExcepti > on(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: ... 12 more > Jul 22 15:06:35 isn20cmt {NPM}: Caused by: ERROR XSDB4: Page Page(2,Container(0, 1216)) is at v > ersion 1,171, the log file contains change version 1,215, either there are log records of this > page missing, or this page did not get written out to disk properly. > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.iapi.error.StandardException.newExc > eption(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.raw.data.PageBasicOperat > ion.needsRedo(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.raw.log.FileLogger.redo( > Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.raw.log.LogToFile.recove > r(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.raw.RawStore.boot(Unknow > n Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.b > oot(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.TopService.bo > otModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.s > tartModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.iapi.services.monitor.Monitor.bootS > erviceModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.store.access.RAMAccessManager. > boot(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.b > oot(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.TopService.bo > otModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.s > tartModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.iapi.services.monitor.Monitor.bootS > erviceModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.db.BasicDatabase.bootStore(Unk > nown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.db.BasicDatabase.boot(Unknown > Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.b > oot(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.TopService.bo > otModule(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.b > ootService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.s > tartProviderService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.f > indProviderAndStartService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.services.monitor.BaseMonitor.s > tartPersistentService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.iapi.services.monitor.Monitor.start > PersistentService(Unknown Source) > Jul 22 15:06:35 isn20cmt {NPM}: ... 12 more > Jul 22 15:06:35 isn20cmt {NPM}: main [PatchStartUp] NPM Server shutting down due to startup fai > lure. -- 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