db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Bridges (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5544) corrupt database
Date Thu, 15 Dec 2011 19:04:30 GMT

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

Sean Bridges commented on DERBY-5544:
-------------------------------------

Here is the directory info,

ls -l log/ 
total 25147
-rw-r--r--   1 appdeployer appdeployer      48 Dec 13 09:56 log.ctrl
-rw-r--r--   1 appdeployer appdeployer 1048969 Dec 13 09:56 log32622.dat
-rw-r--r--   1 appdeployer appdeployer 1050032 Dec 13 09:56 log32623.dat
-rw-r--r--   1 appdeployer appdeployer 1053668 Dec 13 09:56 log32624.dat
-rw-r--r--   1 appdeployer appdeployer 1074350 Dec 13 09:57 log32625.dat
-rw-r--r--   1 appdeployer appdeployer 1056982 Dec 13 09:57 log32626.dat
-rw-r--r--   1 appdeployer appdeployer 1049131 Dec 13 09:57 log32627.dat
-rw-r--r--   1 appdeployer appdeployer 1075733 Dec 13 09:57 log32628.dat
-rw-r--r--   1 appdeployer appdeployer 1051651 Dec 13 09:58 log32629.dat
-rw-r--r--   1 appdeployer appdeployer 1057464 Dec 13 09:58 log32630.dat
-rw-r--r--   1 appdeployer appdeployer 1049440 Dec 13 09:58 log32631.dat
-rw-r--r--   1 appdeployer appdeployer 1048576 Dec 13 09:58 log32632.dat
-rw-r--r--   1 appdeployer appdeployer      48 Dec 13 09:56 logmirror.ctrl

ls -l seg0/
total 14597225
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c10.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 c101.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 c111.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 c121.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 c130.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 c141.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c150.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c161.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c171.dat
-rw-r--r--   1 appdeployer appdeployer   32768 Dec  7 14:05 c180.dat
-rw-r--r--   1 appdeployer appdeployer   16384 Dec  7 14:05 c191.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c1a1.dat
-rw-r--r--   1 appdeployer appdeployer   16384 Dec  7 14:05 c1b1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c1c0.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c1d1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c1e0.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c1f1.dat
-rw-r--r--   1 appdeployer appdeployer   28672 Dec  7 14:08 c20.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c200.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c211.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c221.dat
-rw-r--r--   1 appdeployer appdeployer  114688 Dec  7 14:05 c230.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c241.dat
-rw-r--r--   1 appdeployer appdeployer   20480 Dec  7 14:05 c251.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c260.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c271.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c281.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c290.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c2a1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c2b1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c2c1.dat
-rw-r--r--   1 appdeployer appdeployer   12288 Dec 10 19:03 c2d0.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec 10 19:03 c2e1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c2f0.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c300.dat
-rw-r--r--   1 appdeployer appdeployer   16384 Dec  7 14:08 c31.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c311.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c321.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c331.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c340.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c351.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c361.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c371.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c380.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c391.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c3a1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c3b1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c3c0.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c3d1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c3e1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c3f1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c400.dat
-rw-r--r--   1 appdeployer appdeployer   16384 Dec  7 14:08 c41.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c411.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c421.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c430.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c441.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c451.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 c461.dat
-rw-r--r--   1 appdeployer appdeployer 3091152896 Dec 13 09:58 c470.dat
-rw-r--r--   1 appdeployer appdeployer 1679212544 Dec 13 09:58 c481.dat
-rw-r--r--   1 appdeployer appdeployer 3162112 Dec 13 09:58 c490.dat
-rw-r--r--   1 appdeployer appdeployer   32768 Dec 13 09:56 c4a1.dat
-rw-r--r--   1 appdeployer appdeployer   32768 Dec  7 14:08 c4b0.dat
-rw-r--r--   1 appdeployer appdeployer   32768 Dec  7 14:08 c4c1.dat
-rw-r--r--   1 appdeployer appdeployer 2693464064 Dec 13 09:58 c4d1.dat
-rw-r--r--   1 appdeployer appdeployer   16384 Dec  7 14:08 c51.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 c60.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 c71.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 c81.dat
-rw-r--r--   1 appdeployer appdeployer   20480 Dec  7 14:08 c90.dat
-rw-r--r--   1 appdeployer appdeployer   20480 Dec  7 14:08 ca1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 cb1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 cc0.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 cd1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:05 ce1.dat
-rw-r--r--   1 appdeployer appdeployer    8192 Dec  7 14:08 cf0.dat



Again the file system has been corrupted, even trying to read some files results in io errors
so I can understand if derby can't open the database.
                
> corrupt database
> ----------------
>
>                 Key: DERBY-5544
>                 URL: https://issues.apache.org/jira/browse/DERBY-5544
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.2.2
>         Environment: Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
> derby 10.8.2.2
> solaris, zfs, 64 bit
>            Reporter: Sean Bridges
>
> I'm getting an exception opening a derby database,
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory
(Failed to start database '/data1/derby/db' with class loader sun.misc.Launcher$AppClassLoader@37b90b39,
see the next exception for details.)
>         at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
>         at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
>         at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
>         at message_archiver.kraken.derby.DerbyDbPool.start(DerbyDbPool.java:147)
>         ... 3 more
> Caused by: java.sql.SQLException: Failed to start database '/data1/derby/db' with class
loader sun.misc.Launcher$AppClassLoader@37b90b39, see the next exception for details.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
>         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
>         at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>         at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
>         at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
>         at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
>         at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
>         at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
>         ... 6 more
> Caused by: java.sql.SQLException: Failed to start database '/data1/message-storage/data/kraken/commitlog/derby/db'
with class loader sun.misc.Launcher$AppClassLoader@37b90b39, see the next exception for details.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
>         ... 20 more
> Caused by: java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
>         ... 17 more
> Caused by: java.lang.NullPointerException
>         at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
>         at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openDroppedContainer(Unknown
Source)
>         at org.apache.derby.impl.store.raw.xact.Xact.openDroppedContainer(Unknown Source)
>         at org.apache.derby.impl.store.raw.data.PageBasicOperation.findpage(Unknown Source)
>         at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown
Source)
>         at org.apache.derby.impl.store.raw.log.FileLogger.redo(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.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.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)
>         ... 17 more
> The database is 7 gigs, so I can't easily upload it.   

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message