[
https://issues.apache.org/jira/browse/DERBY-5353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik updated DERBY-5353:
---------------------------------
Component/s: (was: JDBC)
Store
Urgency: (was: Blocker)
Changed category to store. Setting urgency to None since it has not been
triaged.
Shrikanth, can you provide some more information, please?
Which derby version are you using? OS, Java version?
Can you provide the log files and/or the database files?
Did this happen only once?
> 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
