Corrupted database after DBConglomerateRepairTool

Stefaan A Eeckels <[email protected]> Wed, 9 Mar 2005 00:55:36 +0100
Newsgroups gmane.comp.db.mckoi
Organization E.C.C. sa - Computer Consultants
Message-ID <[email protected]>
Hi,

First, big thanks and kudos to Toby for a marvellous DBMS.

I performed a normal shutdown of the database, and executed
DBConglomerateRepairTool as a matter of routine. It terminated
with a error which I stupdily forgot to record. I did try and
restart the application, and got the following (lots of lines
similar to the lines below snipped). I'm testing the application
rather heavily (it uses an embedded database), so the database
has been shut down and restarted at least 50 times today, without
any problems. I'm using the latest release (1.0.3).

> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
  Row: 790 Type: 2 Table: APP.FLOW_AUDIT
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
  Inconsistant: Row committed added but not in master index.
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
  Row: 791 Type: 2 Table: APP.FLOW_AUDIT
java.io.IOException: Area (pointer = 673744) wasn't found in store!
        at com.mckoi.store.AbstractStore.findAllocatedAreasNotIn
(AbstractStore.java:670) at
com.mckoi.database.V2MasterTableDataSource.scanForLeaks
(V2MasterTableDataSource.java:785)        at
com.mckoi.database.V2MasterTableDataSource.open
(V2MasterTableDataSource.java:406) at
com.mckoi.database.TableDataConglomerate.readVisibleTables
(TableDataConglomerate.java:383) at
com.mckoi.database.TableDataConglomerate.open
(TableDataConglomerate.java:1096) at com.mckoi.database.Database.init
(Database.java:1803) at
com.mckoi.database.control.DBController.startDatabase
(DBController.java:131) at
com.mckoi.database.jdbcserver.DefaultLocalBootable.boot
(DefaultLocalBootable.java:135) at
com.mckoi.database.jdbc.MDriver.connectToLocal(MDriver.java:448) at
com.mckoi.database.jdbc.MDriver.connect(MDriver.java:484) at
java.sql.DriverManager.getConnection(DriverManager.java:512) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
edamisDatabase.connect(edamisDatabase.java:34) at edfms.main
(edfms.java:92) Exception in thread "main" java.lang.Error: IO Error:
Area (pointer = 673744) wasn't found in store!        at
com.mckoi.database.Database.init(Database.java:1845) at
com.mckoi.database.control.DBController.startDatabase
(DBController.java:131) at
com.mckoi.database.jdbcserver.DefaultLocalBootable.boot
(DefaultLocalBootable.java:135) at
com.mckoi.database.jdbc.MDriver.connectToLocal(MDriver.java:448) at
com.mckoi.database.jdbc.MDriver.connect(MDriver.java:484) at
java.sql.DriverManager.getConnection(DriverManager.java:512) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
edamisDatabase.connect(edamisDatabase.java:34) at edfms.main
(edfms.java:92)

I've got a ZIP file of the corrupted database, it's about 200K, which
I can email or put on my website, whatever is preferred.

Thanks and kind regards,

-- 
Stefaan
-- 
As complexity rises, precise statements lose meaning,
and meaningful statements lose precision. -- Lotfi Zadeh 


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]