[
https://issues.apache.org/jira/browse/DERBY-5353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13071276#comment-13071276
]
Dag H. Wanvik commented on DERBY-5353:
--------------------------------------
At first glance it looks like Derby thinks a page has been persisted to disk,
but somehow it didn't actually get written, cf. the version number skew.
> 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
> Priority: Blocker
>
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
