headers
David Goldsmith | 10 Mar 2007 01:40
Favicon

Help with Corrupt Database


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
(Continue reading)

Permalink | Reply | 0 comments |
headers
Dario . | 17 Mar 2007 21:43
Picon
Favicon

Is the support still active?

I´m having some corruption issues.....
Permalink | Reply | 1 comment |
headers
Tobias Downer | 20 Mar 2007 01:21

Re: Is the support still active?

Hi Dario,

Yes, please post your problem and we'll help you out as well as we are able.

Toby.

Dario . wrote:
> I´m having some corruption issues.....

---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe <at> mckoi.com
Permalink | Reply | 0 comments |
headers
Dario . | 21 Mar 2007 15:53
Picon
Favicon

Corrupted DB

Toby, thanks for the last reply!
This is the log i get when i try to access my db, with DBVisualizer
 
 
 
% 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 = false
% ignore_case_for_identifiers = true
% 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
% 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 = false
% ignore_case_for_identifiers = true
% 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
java.io.IOException: Area (pointer = 3354656) 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(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at com.onseven.dbvis.wrapper.DriverManagerImpl.getConnection(Unknown Source)
 at com.onseven.dbvis.sql.N.?(Unknown Source)
 at com.onseven.dbvis.sql.N.access$200(Unknown Source)
 at com.onseven.dbvis.sql.N$A.execute(Unknown Source)
 at se.pureit.util.ThreadCommand.runExecute(ThreadCommand.java:163)
 at se.pureit.util.ThreadCommand.run(ThreadCommand.java:143)
 at java.lang.Thread.run(Unknown Source)
java.lang.Error: IO Error: Area (pointer = 3354656) 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(Unknown Source)
 at java.sql.DriverManager.getConnection(Unknown Source)
 at com.onseven.dbvis.wrapper.DriverManagerImpl.getConnection(Unknown Source)
 at com.onseven.dbvis.sql.N.?(Unknown Source)
 at com.onseven.dbvis.sql.N.access$200(Unknown Source)
 at com.onseven.dbvis.sql.N$A.execute(Unknown Source)
 at se.pureit.util.ThreadCommand.runExecute(ThreadCommand.java:163)
 at se.pureit.util.ThreadCommand.run(ThreadCommand.java:143)
 at java.lang.Thread.run(Unknown Source)

Permalink | Reply | 0 comments |

Gmane