RE: Error: Area is not allocated!

Sorry to be a pest, but when starting the supplied database I get the
following errors

> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
  Inconsistant: Row is indexed but marked as removed or uncommitted.
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
  Row: 4263 Type: 3 Table: SYS_INFO.sUSRSequence
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
  Inconsistant: Row is indexed but marked as removed or uncommitted.
> com.mckoi.database.V2MasterTableDataSource ( lvl: 40 )
  Row: 4287 Type: 3 Table: SYS_INFO.sUSRSequence 

And so on..

But it starts fine, then when I try to connect to it I get the following
errors.

com.mckoi.database.jdbc.MSQLException: Out of bounds.
       at
com.mckoi.database.jdbc.RemoteDatabaseInterface.execQuery(RemoteDatabaseInte
rface.java:280)
       at
com.mckoi.database.jdbc.MConnection.executeQuery(MConnection.java:453)
       at
com.mckoi.database.jdbc.MConnection.executeQueries(MConnection.java:436)
       at
com.mckoi.database.jdbc.MStatement.executeQueries(MStatement.java:193)
       at
com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:167)
       at
com.mckoi.database.jdbc.MStatement.executeQuery(MStatement.java:222)
       at com.mckoi.database.jdbc.MConnection.login(MConnection.java:306)

So I can't connect to the database, but thought that u might like to see the
errors.

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]