db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5353) java.sql.SQLException: Failed to start database
Date Tue, 26 Jul 2011 18:37:09 GMT

     [ 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

        

Mime
View raw message