[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Help with Corrupt Database
- To: mckoidb@xxxxxxxxx
- Subject: Help with Corrupt Database
- From: David Goldsmith <dgoldsmith@xxxxxxxx>
- Date: Fri, 09 Mar 2007 19:40:30 -0500
- Delivered-To: mailing list mckoidb@mckoi.com
- Mailing-List: contact mckoidb-help@mckoi.com; run by ezmlm
- User-Agent: Thunderbird 2.0b2 (Windows/20070116)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
We are using software from Elluminate for virtual online classroom
training and by default it uses the Mckoi database.
Our system's database apparently got corrupt yesterday. The Elluminate
Live Manager (ELM) web page stopped responding properly and when I tried
stopping and starting all the services, I got an error like this for mckoi:
# service mckoid start
Starting mckoid:
Mckoi SQL Database ( 1.0.3 )
Copyright (C) 2000 - 2004 Diehl and Associates, Inc. All rights reserved.
Use: -h for help.
Mckoi SQL Database comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to redistribute it
under certain conditions. See LICENSE.txt for details of the
GPL License.
[com.mckoi.debug.Debug - Exception thrown: 'Format invalid: Magic value
is not as expected.']
java.io.IOException: Format invalid: Magic value is not as expected.
at com.mckoi.store.AbstractStore.open(AbstractStore.java:166)
at
com.mckoi.database.V1FileStoreSystem.openStore(V1FileStoreSystem.java:145)
at
com.mckoi.database.V2MasterTableDataSource.open(V2MasterTableDataSource.java:377)
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.runtime.McKoiDBMain.doBoot(McKoiDBMain.java:163)
at com.mckoi.runtime.McKoiDBMain.main(McKoiDBMain.java:296)
Exception in thread "main" java.lang.RuntimeException: IO Error: Format
invalid: Magic value is not as expected.
at
com.mckoi.database.V1FileStoreSystem.openStore(V1FileStoreSystem.java:155)
at
com.mckoi.database.V2MasterTableDataSource.open(V2MasterTableDataSource.java:377)
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.runtime.McKoiDBMain.doBoot(McKoiDBMain.java:163)
at com.mckoi.runtime.McKoiDBMain.main(McKoiDBMain.java:296)
Looking at the associated McKoi debug.log file, here are the first error
messages I see starting yesterday:
**** Debug log started: Thu Mar 08 14:23:01 UTC 2007 ****
% Storage System: v1 file storage mode.
% Internal Data Cache size: 4194304
% Internal Data Cache max cell size: 8192
% lookup_comparison_list = false
% read_only = false
% transaction_error_on_dirty_select = true
% ignore_case_for_identifiers = false
% Java NIO API is available.
% io_safety_level = 10
% Using stardard IO API for heap buffered file access.
% [Buffer Manager] Using IO API: Java IO
% [Buffer Manager] Page Size: 8192
% [Buffer Manager] Max pages: 256
% Using regex bridge: gnu.regexp
% No 'function_factories' config property found.
% statement_cache = true
% Max worker threads set to: 4
% Starting Database Server
> com.mckoi.database.IndexSetStore$MappedListBlock ( lvl: 40 )
block_p = 77528
[ TIME: Thu Mar 08 23:26:53 UTC 2007 ]
% java.io.IOException: Store being constructed on deleted area.
at
com.mckoi.store.AbstractStore$StoreArea.<init>(AbstractStore.java:1516)
at com.mckoi.store.AbstractStore.getArea(AbstractStore.java:1406)
at
com.mckoi.database.IndexSetStore$MappedListBlock.getArray(IndexSetStore.java:1050)
at
com.mckoi.util.BlockIntegerList$IntArrayListBlock.searchFirst(BlockIntegerList.java:356)
at
com.mckoi.util.AbstractBlockIntegerList.searchFirst(AbstractBlockIntegerList.java:1049)
at
com.mckoi.database.InsertSearch.searchFirst(InsertSearch.java:351)
at
com.mckoi.database.CollatedBaseSearch.positionOfRangePoint(CollatedBaseSearch.java:192)
at
com.mckoi.database.CollatedBaseSearch.addRange(CollatedBaseSearch.java:272)
at
com.mckoi.database.CollatedBaseSearch.selectRange(CollatedBaseSearch.java:307)
at com.mckoi.database.Table.selectRange(Table.java:1616)
at com.mckoi.database.Table.rangeSelect(Table.java:354)
at
com.mckoi.database.QueryPlan$RangeSelectNode.evaluate(QueryPlan.java:552)
at
com.mckoi.database.QueryPlan$SubsetNode.evaluate(QueryPlan.java:946)
at com.mckoi.database.interpret.Select.evaluate(Select.java:141)
at
com.mckoi.database.interpret.SQLQueryExecutor.execute(SQLQueryExecutor.java:147)
at
com.mckoi.database.jdbcserver.AbstractJDBCDatabaseInterface.execQuery(AbstractJDBCDatabaseInterface.java:461)
at
com.mckoi.database.jdbcserver.JDBCDatabaseInterface.execQuery(JDBCDatabaseInterface.java:251)
at
com.mckoi.database.jdbcserver.JDBCProcessor.queryCommand(JDBCProcessor.java:352)
at
com.mckoi.database.jdbcserver.JDBCProcessor.processQuery(JDBCProcessor.java:293)
at
com.mckoi.database.jdbcserver.JDBCProcessor.processJDBCCommand(JDBCProcessor.java:196)
at
com.mckoi.database.jdbcserver.StreamJDBCServerConnection.processRequest(StreamJDBCServerConnection.java:137)
at
com.mckoi.database.jdbcserver.MultiThreadedConnectionPoolServer$1.run(MultiThreadedConnectionPoolServer.java:171)
at com.mckoi.database.WorkerThread.run(WorkerThread.java:123)
> com.mckoi.database.IndexSetStore$MappedListBlock ( lvl: 40 )
block_p = 77528
I searched for the error "java.io.IOException: Store being constructed
on deleted area" and came across this thread from the list:
http://www.mckoi.com/database/maillist/msg05080.html
I saved a copy of my data directory and ran the repair command. I got a
lot of output like this followed by two error messages about the "Magic
value":
+ Found state store: DefaultDatabase_sf
+ Initialized the state store: DefaultDatabase_sf
+ Repairing V2MasterTableDataSource 000SYS_INFO_sUSRSequenceInfo
- - Store: [ JournalledFileStore: 000SYS_INFO_sUSRSequenceInfo ]
- - Store areas are intact.
+ Rebuilding free bins.
- - Store repair complete.
- - Checking record integrity.
* Record count = 32 Free count = 0
- - Rebuilding all table index information.
- - Table check complete.
+ Repairing V2MasterTableDataSource 001SYS_INFO_sUSRSequence
- - Store: [ JournalledFileStore: 001SYS_INFO_sUSRSequence ]
- - Store areas are intact.
+ Rebuilding free bins.
- - Store repair complete.
- - Checking record integrity.
* Record count = 0 Free count = 0
- - Rebuilding all table index information.
- - Table check complete.
+ Repairing V2MasterTableDataSource 002SYS_INFO_sUSRPKeyInfo
- - Store: [ JournalledFileStore: 002SYS_INFO_sUSRPKeyInfo ]
- - Store areas are intact.
+ Rebuilding free bins.
- - Store repair complete.
- - Checking record integrity.
* Record count = 18 Free count = 14
- - Rebuilding all table index information.
- - Table check complete.
...
...
...
[com.mckoi.debug.Debug - Exception thrown: 'Format invalid: Magic value
is not as expected.']
java.io.IOException: Format invalid: Magic value is not as expected.
at com.mckoi.store.AbstractStore.open(AbstractStore.java:166)
at
com.mckoi.database.V1FileStoreSystem.openStore(V1FileStoreSystem.java:145)
at
com.mckoi.database.V2MasterTableDataSource.open(V2MasterTableDataSource.java:377)
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.runtime.McKoiDBMain.doBoot(McKoiDBMain.java:163)
at com.mckoi.runtime.McKoiDBMain.main(McKoiDBMain.java:296)
Exception in thread "main" java.lang.RuntimeException: IO Error: Format
invalid: Magic value is not as expected.
at
com.mckoi.database.V1FileStoreSystem.openStore(V1FileStoreSystem.java:155)
at
com.mckoi.database.V2MasterTableDataSource.open(V2MasterTableDataSource.java:377)
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.runtime.McKoiDBMain.doBoot(McKoiDBMain.java:163)
at com.mckoi.runtime.McKoiDBMain.main(McKoiDBMain.java:296)
Searching for the magiv value error, I found this post from December but
it does not appear that anyone replied.
Anyone has any ideas as to how I might be able to repair the database files?
Thanks,
David Goldsmith
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFF8f59417vU8/9QfkRAhkbAKCR4GstqKPhVzWaciPgzvK5wQEgjACbBwwJ
+UD5yEG0OfGfmnS++W4tlIU=
=UiEE
-----END PGP SIGNATURE-----