[ 
https://issues.apache.org/jira/browse/DERBY-6826?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14619694#comment-14619694
 ] 

Bryan Pendleton commented on DERBY-6826:
----------------------------------------

In your derby.log is this exception:

Caused by: ERROR XJ040: Failed to start database 'cachedb_paa' with class 
loader sun.misc.Launcher$AppClassLoader@7d38847d, see the next exception for 
details.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown 
Source)
        at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
 Source)
        ... 16 more
Caused by: ERROR XSTB0: An exception was thrown during transaction abort.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown 
Source)
        at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source)
        at 
org.apache.derby.impl.store.raw.xact.XactFactory.rollbackAllTransactions(Unknown
 Source)
        at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source)
        at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
        at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown 
Source)
        at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown 
Source)
        at 
org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
        at 
org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
        at 
org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
        at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown 
Source)
        at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown 
Source)
        at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown 
Source)
        at 
org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
        at 
org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
        at 
org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
        at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
        at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
        at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown 
Source)
        at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown 
Source)
        at 
org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
        at 
org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown 
Source)
        at 
org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
 Source)
        at 
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
 Source)
        at 
org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown 
Source)
        ... 13 more
Caused by: ERROR XSLA8: Cannot rollback transaction 543496278, trying to 
compensate null operation with null
        at org.apache.derby.iapi.error.StandardException.newException(Unknown 
Source)
        at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown Source)
        ... 37 more
Caused by: ERROR XSCB5: During logical undo of a btree insert or delete the row 
could not be found in the tree.
        at org.apache.derby.iapi.error.StandardException.newException(Unknown 
Source)
        at org.apache.derby.iapi.error.StandardException.newException(Unknown 
Source)
        at 
org.apache.derby.impl.store.access.btree.index.B2IUndo.findUndo(Unknown Source)
        at 
org.apache.derby.impl.store.raw.data.LogicalPageOperation.findLogicalPage(Unknown
 Source)
        at 
org.apache.derby.impl.store.raw.data.LogicalPageOperation.generateUndo(Unknown 
Source)
        at 
org.apache.derby.impl.store.raw.data.UpdateFieldOperation.generateUndo(Unknown 
Source)

This indicates that the database cannot be recovered.

Is this the oldest derby.log that you have? Do you have any records that 
indicate
what happened prior to Thu Jun 18 00:20:26 EDT 2015?

It would appear that the database is sufficiently damaged that it cannot be 
recovered, and
will have to be restored from backups.

But it would be very valuable to understand what caused this damage (e.g., hard 
disk failure,
cpu failure, power failure, disk became full, accidental system administration 
mistake, etc.)

Any additional information you can provide about what happened leading up
to the damaged database could provide useful clues.


> SOA PROD - The state of datasource DifJavaDbDataSource, application 
> domain-level is Suspended.
> ----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-6826
>                 URL: https://issues.apache.org/jira/browse/DERBY-6826
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.11.1.1
>         Environment: os.name=Linux
> os.arch=amd64
> os.version=2.6.18-371.6.1.el5
> JDK = 1.6.0_30-b30
> Space= 50 GB
> RAM= 64 GB
> CPU's = 12
>            Reporter: Gowtham Nethi
>              Labels: performance
>         Attachments: derby.log, nohup.out
>
>
> Derby Information:
> Loaded from file:/u02/oracle/product/fmw/db-derby-10.11.1.1-bin/lib/derby.jar
> java.vendor=Sun Microsystems Inc.
> java.runtime.version=1.6.0_30-b30
> user.dir=/u02/oracle/product/fmw/db-derby-10.11.1.1-bin
> os.name=Linux
> os.arch=amd64
> os.version=2.6.18-371.6.1.el5
> derby.system.home=/u02/oracle/product/fmw/db-derby-10.11.1.1-bin



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to