Thanks again for your quick response. On Thursday, July 3, 2014 2:36:57 PM UTC-4, Thomas Mueller wrote: > > Hi, > > I'm working on this issue right now. > > > Can you tell me if disabling the MVStore ( MV_STORE=FALSE; ) would take > me to a more stable version > > Yes. That way, the old "page store" is used. > > > or should I download an older version? > > That's an option as well. See the change log for bugs that were fixed > since then, and whether they affect you or not. > > Regards, > Thomas > > > > On Thu, Jul 3, 2014 at 4:32 PM, Kenton Garner <[email protected] > <javascript:>> wrote: > >> I got another exception today.... >> >> Caused by: org.h2.jdbc.JdbcSQLException: General error: >> "java.lang.IllegalArgumentException: Illegal Capacity: -1"; SQL statement: >> INSERT INTO CDS_HISTORY(ID, SEQNUM, XACTID, MSGDATE, FILENAME, STATE) >> VALUES('FAKE_None',27024,'20140703054701192T','2014-07-03 >> 05:47:01.192000','00-20140703054701192000_27024-ORACLE.GDS2DB_OWNER.0','RCV') >> >> [50000-179] >> at >> org.h2.message.DbException.getJdbcSQLException(DbException.java:345) >> at org.h2.message.DbException.get(DbException.java:168) >> at org.h2.message.DbException.convert(DbException.java:295) >> at org.h2.mvstore.db.MVTable.addRow(MVTable.java:614) >> at org.h2.command.dml.Insert.insertRows(Insert.java:156) >> at org.h2.command.dml.Insert.update(Insert.java:114) >> at org.h2.command.CommandContainer.update(CommandContainer.java:78) >> at org.h2.command.Command.executeUpdate(Command.java:253) >> at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:185) >> at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:159) >> at >> com.issinc.cds.sbrecv.history.RecvHistoryDBStore.update(RecvHistoryDBStore.java:266) >> ... 4 more >> Caused by: java.lang.IllegalArgumentException: Illegal Capacity: -1 >> at java.util.ArrayList.<init>(ArrayList.java:142) >> at org.h2.mvstore.MVMap.removeUnusedOldVersions(MVMap.java:993) >> at org.h2.mvstore.MVMap.newRoot(MVMap.java:699) >> at org.h2.mvstore.MVMap.put(MVMap.java:113) >> at org.h2.mvstore.MVMap.putIfAbsent(MVMap.java:574) >> at >> org.h2.mvstore.db.TransactionStore$TransactionMap.trySet(TransactionStore.java:1089) >> at >> org.h2.mvstore.db.TransactionStore$TransactionMap.set(TransactionStore.java:1011) >> at >> org.h2.mvstore.db.TransactionStore$TransactionMap.put(TransactionStore.java:989) >> at org.h2.mvstore.db.MVPrimaryIndex.add(MVPrimaryIndex.java:143) >> at org.h2.mvstore.db.MVTable.addRow(MVTable.java:610) >> ... 11 more >> >> I have been running tests for a couple weeks now. The 1.4.179 version >> has been pretty stable for me during that time ( running 24x7 ) with >> constant updates/deletes/queries. However, this exception was just thrown; >> and now I think my dbfile maybe in a bad state because the trace file is >> showing multiple corrupt page counts now. >> >> I am new to h2 but I have heard so many positive things about it - it was >> the embedded DB I chose to implement. >> Can you tell me if disabling the MVStore ( MV_STORE=FALSE; ) would take >> me to a more stable version or should I download an older version? >> What is your recommendation? >> What are the pros/cons as well - are the URL options largely different? >> >> Current URL: >> "jdbc:h2:../data/dbFile;COMPRESS=TRUE;AUTOCOMMIT=ON;MVCC=TRUE;DB_CLOSE_ON_EXIT=FALSE;AUTO_SERVER=TRUE;AUTO_SERVER_PORT=8700" >> Current Version 1.4.179 >> Current OS: Solaris 10 >> Java version: 1.7u45 >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
