Error: Area is not allocated!

Discussion:

Steve Mactaggart

2005-05-22 03:40:39 UTC

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)
at
com.mckoi.database.V2MasterTableDataSource.open(V2MasterTableDataSource.java
:406)
at
com.mckoi.database.TableDataConglomerate.readVisibleTables(TableDataConglome
rate.java:383)
at
com.mckoi.database.TableDataConglomerate.open(TableDataConglomerate.java:109
6)
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.Error: IO Error: Area (pointer =
445056) is not allocated!
at com.mckoi.database.Database.init(Database.java:1845)
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)

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 mckoidb-***@mckoi.com

Tobias Downer

2005-05-23 23:17:07 UTC

Permalink

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.

Post by Steve Mactaggart
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 mckoidb-***@mckoi.com

Steve Mactaggart

2005-05-27 02:59:33 UTC

Permalink

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: ***@mckoi.com [mailto:***@mckoi.com] On Behalf Of Tobias
Downer
Sent: Tuesday, 24 May 2005 9:17 AM
To: ***@mckoi.com
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.

com.mckoi.store.AbstractStore.findAllocatedAreasNotIn(AbstractStore.java:657

Post by Steve Mactaggart
)
at

com.mckoi.database.V2MasterTableDataSource.scanForLeaks(V2MasterTableDataSou

Post by Steve Mactaggart
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 mckoidb-***@mckoi.com

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

Steve Mactaggart

2005-06-17 12:38:04 UTC

Permalink

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: ***@mckoi.com [mailto:***@mckoi.com] On Behalf Of Tobias
Downer
Sent: Tuesday, 24 May 2005 9:17 AM
To: ***@mckoi.com
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.

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

Tobias Downer

2005-06-17 23:17:02 UTC

Permalink

Steve,

I have sent an update to your email address.

Thanks,
Toby.

Post by Steve Mactaggart
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..

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com

Jules Chandler

2005-06-18 08:16:21 UTC

Permalink

Why am I receiving these emails? - this subject matter does not concern me.
regards,
Jules

Post by Tobias Downer
Steve,
I have sent an update to your email address.
Thanks,
Toby.

Post by Steve Mactaggart
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..

---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/