RE: Error: Area is not allocated!

Thanks Toby, 

Ive run the repair tool, and it flys through a heap of tables, but seems to
get stuck on one 

+ Repairing V2MasterTableDataSource 069APP_TEAM_MEMBER
- Store: [ JournalledFileStore: 069APP_TEAM_MEMBER ]
- Store areas are intact.
+ Rebuilding free bins.
- Store repair complete.
- Checking record integrity.
* Record count = 1476 Free count = 540
- Rebuilding all table index information.
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException
        at java.lang.System.arraycopy(Native Method)
        at
com.mckoi.store.LoggingBufferManager$BMPage.read(LoggingBufferManager.java:8
88)
        at
com.mckoi.store.LoggingBufferManager.readByteArrayFrom(LoggingBufferManager.
java:480)
        at
com.mckoi.store.JournalledFileStore.readByteArrayFrom(JournalledFileStore.ja
va:132)
        at
com.mckoi.store.AbstractStore.getPreviousAreaHeader(AbstractStore.java:853)
        at com.mckoi.store.AbstractStore.free(AbstractStore.java:1318)
        at com.mckoi.store.AbstractStore.deleteArea(AbstractStore.java:1387)
        at
com.mckoi.database.IndexSetStore.deleteAllAreas(IndexSetStore.java:165)
        at
com.mckoi.database.IndexSetStore.access$600(IndexSetStore.java:83)
        at
com.mckoi.database.IndexSetStore$IndexBlock.deleteBlockChain(IndexSetStore.j
ava:1436)
        at
com.mckoi.database.IndexSetStore$IndexBlock.removeReference(IndexSetStore.ja
va:1485)
        at
com.mckoi.database.IndexSetStore.commitDropIndex(IndexSetStore.java:699)
        at
com.mckoi.database.V2MasterTableDataSource.checkAndRepair(V2MasterTableDataS
ource.java:877)
        at
com.mckoi.database.TableDataConglomerate.checkVisibleTables(TableDataConglom
erate.java:438)
        at
com.mckoi.database.TableDataConglomerate.fix(TableDataConglomerate.java:2323
)
        at
com.mckoi.tools.DBConglomerateRepairTool.repair(DBConglomerateRepairTool.jav
a:57)
        at
com.mckoi.tools.DBConglomerateRepairTool.main(DBConglomerateRepairTool.java:
87)

Any suggestions on this one?

Steve

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Tobias
Downer
Sent: Tuesday, 24 May 2005 9:17 AM
To: [email protected]
Subject: Re: Error: Area is not allocated!

Hi Steve,

Please make a backup of the database files, and then run the repair 
tool.  To use the repair tool, run the following command;

   java -cp mckoidb.jar com.mckoi.tools.DBConglomerateRepairTool -path 
[path to you database 'data' directory]

Be careful when using a database interchangeably between embedded and 
server modes.  You must not connect to a database in embedded mode from 
more the one JVM at a time.  If you have multiple JVMs that access the 
database then you must run Mckoi in server mode and connect via 
'jdbc:mckoi://localhost/'

Regards,
Toby.


Steve Mactaggart wrote:

> Hey all,
> 
> I have been running mckoi for a little website I run for a while now, but
in
> the last few days the database seems to not want to start and when
launched
> issues the following error.
> 
> java.io.IOException: Area (pointer = 445056) is not allocated!
>         at
>
com.mckoi.store.AbstractStore.findAllocatedAreasNotIn(AbstractStore.java:657
> )
>         at
>
com.mckoi.database.V2MasterTableDataSource.scanForLeaks(V2MasterTableDataSou
> rce.java:785)
> 
> The database used to run standalone, and recently (<2weeks) I moved it to
be
> internal, but now the database doesn't seem to start internally and when
> launched as an standalone instance I get this error.
> 
> I know that the db was not cleanly shutdown a couple of times (due to
power
> outages) but am unable to get it working again.
> 
> Any ideas on how to fix this error and get the database back up and
working
> again?
> I'm running 1.0.3 and the database can be provided if needed..
> 
> Thanks in advance
> 
> Steve



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



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