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 "Kathey Marsden (Resolved) (JIRA)" <ji...@apache.org> on 2011/12/07 21:32:39 UTC
[jira] [Resolved] (DERBY-5353) java.sql.SQLException: Failed to
start database
[ 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.<init>(Un
> known Source)
> Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(
> 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.<init>(Un
> known Source)
> Jul 22 15:06:35 isn20cmt {NPM}: at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(
> 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