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: JDBC
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
