Size of SYS_INFO_sUSRSequence.koi file increases

[Arjav Chakravarti]

Hello,

Our Java application uses the documented CREATE SEQUENCE and
NEXTVAL commands to create and use the Mckoi sequence generator. We are
using Mckoi 1.0.3.

The 001SYS_INFO_sUSRSequence.koi file started out with a size of
6120 bytes. I found that every call to NEXTVAL increased the file size
by ~14 bytes. As a test, I called COMPACT TABLE on the
SYS_INFO_sUSRSequence table after every call to NEXTVAL and found that
the file size remained stable at 7144 bytes, even after 35000 calls to
NEXTVAL.

Since our customers keep the application running for several
months at a time, I am worried about database growth. I also want to
avoid the overhead of frequent calls to COMPACT TABLE.

Is this a known issue with Mckoi? Any suggestions for how I
could fix or work around this problem will be much appreciated.

Thanks,
Arjav


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

[s***@ebd-integration.de]

Sehr geehrte Damen und Herren,

in der Zeit vom 26.08. bis 12.09.2006 bin ich im Urlaub. In
dringenden Fällen wenden Sie sich bitte an unser Support-Team unter der
Nummer: 08158 - 90563 - 50 oder per E-mail an:
***@ebd-integration.de

Mit freundlichen Grüßen
Steffen Brehme




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

[j***@souwest.co.za]

I am out of the office until Wednesday 13 September 2006.




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

[Duncan Groenewald]

Any ideas on if its possible to recover from this error ? Suddenly got
this error !

Thanks

[com.mckoi.debug.Debug - Exception thrown: 'File corrupt:
last_area_pointer is before data part of file.']
java.io.IOException: File corrupt: last_area_pointer is before data part
of file.
at com.mckoi.store.AbstractStore.open(AbstractStore.java:205)
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)
java.lang.RuntimeException: IO Error: File corrupt: last_area_pointer is
before data part of file.
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)



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

[Tobias Downer]

Hi Arjav,

In a test situation where NEXTVAL is called in quick repetition you may
see the growth of the size of the sUSRSequence file. Mckoi adds a new
entry to the sequence file for each sequence value created, and will
reclaim the space from old entries when the system is less busy. In an
application when NEXTVAL is used to generate keys spread out over a
longer session, you should not see unreasonable growth of this file.
Mckoi should adopt a buffer size for the sUSRSequence file that matches
your application's frequency of generating keys.

Toby.

Post by Arjav Chakravarti
Hello,
Our Java application uses the documented CREATE SEQUENCE and
NEXTVAL commands to create and use the Mckoi sequence generator. We are
using Mckoi 1.0.3.
The 001SYS_INFO_sUSRSequence.koi file started out with a size of
6120 bytes. I found that every call to NEXTVAL increased the file size
by ~14 bytes. As a test, I called COMPACT TABLE on the
SYS_INFO_sUSRSequence table after every call to NEXTVAL and found that
the file size remained stable at 7144 bytes, even after 35000 calls to
NEXTVAL.
Since our customers keep the application running for several
months at a time, I am worried about database growth. I also want to
avoid the overhead of frequent calls to COMPACT TABLE.
Is this a known issue with Mckoi? Any suggestions for how I
could fix or work around this problem will be much appreciated.
Thanks,
Arjav

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