Hi, Yes, this should be fixed now (today) in the trunk.
Regards, Thomas On Thu, Jul 10, 2014 at 1:27 AM, Vishwa <[email protected]> wrote: > Again one more exception after build from trunk. > Can anyone help here? > > 2014-07-09 15:26:30,531 ERROR [Job Manager 10] > b.t.i.d.m.MemoryDatabaseLoader [MemoryDatabaseLoader.java:470] Exception > connecting to database:General error: > "java.lang.UnsupportedOperationException: Must contain at least two entries > [1.4.179/0]" [50000-179] > org.h2.jdbc.JdbcBatchUpdateException: General error: > "java.lang.UnsupportedOperationException: Must contain at least two entries > [1.4.179/0]" [50000-179] > > at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1198) > ~[h2-1.4.179.jar:1.4.179] > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2465) > ~[c3p0-0.9.5-pre8.jar:0.9.5-pre8] > at > biz.tradescape.ingestion.database.memory.MemoryDatabaseLoader.loadSingleTable(MemoryDatabaseLoader.java:451) > [h2server.jar:na] > at > biz.tradescape.ingestion.database.memory.MemoryDatabaseLoader.access$1(MemoryDatabaseLoader.java:332) > [h2server.jar:na] > at > biz.tradescape.ingestion.database.memory.MemoryDatabaseLoader$1.run(MemoryDatabaseLoader.java:95) > ~[h2server.jar:na] > > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > ~[na:1.7.0_25] > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > ~[na:1.7.0_25] > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > ~[na:1.7.0_25] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > ~[na:1.7.0_25] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > ~[na:1.7.0_25] > at java.lang.Thread.run(Thread.java:724) ~[na:1.7.0_25] > > > > On Saturday, June 28, 2014 8:34:15 PM UTC-7, Vishwa wrote: > >> I have been getting this exception on 1.4.178 and 1.4.179. >> Problem still persist on latest release >> No issue with older version 1.3.176. >> >> I am using these options on database url-: DB_CLOSE_DELAY=-1;MULTI_ >> THREADED=1;MODE=MYSQL;CACHE_SIZE=1073741824;PAGE_SIZE= >> 32768;CACHE_TYPE=SOFT_LRU; >> >> I can use older version, but i thought newer version performance will >> better. >> >> 2014-06-28 19:36:15,701 ERROR [Job Manager 45] >> b.t.i.d.m.MemoryDatabaseLoader [MemoryDatabaseLoader.java:449] Exception >> connecting to database:General error: "java.lang.IndexOutOfBoundsException: >> Index: 1, Size: 1"; SQL statement: >> insert into exr(currencycodefrom,currencycodeto,monthyearvalidfor,rate) >> values (?,?,?,?) [50000-179] >> org.h2.jdbc.JdbcBatchUpdateException: General error: >> "java.lang.IndexOutOfBoundsException: >> Index: 1, Size: 1"; SQL statement: >> insert into exr(currencycodefrom,currencycodeto,monthyearvalidfor,rate) >> values (?,?,?,?) [50000-179] >> at org.h2.jdbc.JdbcPreparedStatement.executeBatch( >> JdbcPreparedStatement.java:1198) ~[h2-1.4.179.jar:1.4.179] >> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement. >> executeBatch(NewProxyPreparedStatement.java:2465) >> ~[c3p0-0.9.5-pre8.jar:0.9.5-pre8] >> at biz.tradescape.ingestion.database.memory.MemoryDatabaseLoader. >> loadSingleTable(MemoryDatabaseLoader.java:432) [h2server.jar:na] >> at biz.tradescape.ingestion.database.memory. >> MemoryDatabaseLoader.access$1(MemoryDatabaseLoader.java:313) >> [h2server.jar:na] >> at biz.tradescape.ingestion.database.memory. >> MemoryDatabaseLoader$1.run(MemoryDatabaseLoader.java:80) >> ~[h2server.jar:na] >> at >> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) >> ~[na:1.7.0_25] >> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> ~[na:1.7.0_25] >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> ~[na:1.7.0_25] >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> ~[na:1.7.0_25] >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> ~[na:1.7.0_25] >> at java.lang.Thread.run(Thread.java:724) ~[na:1.7.0_25] >> org.h2.jdbc.JdbcBatchUpdateException: General error: >> "java.lang.IndexOutOfBoundsException: >> Index: 1, Size: 1"; SQL statement: >> insert into exr(currencycodefrom,currencycodeto,monthyearvalidfor,rate) >> values (?,?,?,?) [50000-179] >> at org.h2.jdbc.JdbcPreparedStatement.executeBatch( >> JdbcPreparedStatement.java:1198) >> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement. >> executeBatch(NewProxyPreparedStatement.java:2465) >> at biz.tradescape.ingestion.database.memory.MemoryDatabaseLoader. >> loadSingleTable(MemoryDatabaseLoader.java:432) >> at biz.tradescape.ingestion.database.memory. >> MemoryDatabaseLoader.access$1(MemoryDatabaseLoader.java:313) >> at biz.tradescape.ingestion.database.memory. >> MemoryDatabaseLoader$1.run(MemoryDatabaseLoader.java:80) >> at java.util.concurrent.Executors$RunnableAdapter. >> call(Executors.java:471) >> at java.util.concurrent.FutureTask$Sync.innerRun( >> FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at java.util.concurrent.ThreadPoolExecutor.runWorker( >> ThreadPoolExecutor.java:1145) >> at java.util.concurrent.ThreadPoolExecutor$Worker.run( >> ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:724) >> org.h2.jdbc.JdbcSQLException: General error: >> "java.lang.IndexOutOfBoundsException: >> Index: 1, Size: 1"; SQL statement: >> insert into exr(currencycodefrom,currencycodeto,monthyearvalidfor,rate) >> values (?,?,?,?) [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.JdbcPreparedStatement.executeUpdateInternal( >> JdbcPreparedStatement.java:157) >> at org.h2.jdbc.JdbcPreparedStatement.executeBatch( >> JdbcPreparedStatement.java:1183) >> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement. >> executeBatch(NewProxyPreparedStatement.java:2465) >> at biz.tradescape.ingestion.database.memory.MemoryDatabaseLoader. >> loadSingleTable(MemoryDatabaseLoader.java:432) >> at biz.tradescape.ingestion.database.memory. >> MemoryDatabaseLoader.access$1(MemoryDatabaseLoader.java:313) >> at biz.tradescape.ingestion.database.memory. >> MemoryDatabaseLoader$1.run(MemoryDatabaseLoader.java:80) >> at java.util.concurrent.Executors$RunnableAdapter. >> call(Executors.java:471) >> at java.util.concurrent.FutureTask$Sync.innerRun( >> FutureTask.java:334) >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> at java.util.concurrent.ThreadPoolExecutor.runWorker( >> ThreadPoolExecutor.java:1145) >> at java.util.concurrent.ThreadPoolExecutor$Worker.run( >> ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:724) >> Caused by: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 >> at java.util.ArrayList.rangeCheck(ArrayList.java:604) >> at java.util.ArrayList.get(ArrayList.java:382) >> at org.h2.mvstore.MVMap.openVersion(MVMap.java:1166) >> at org.h2.mvstore.MVStore.storeNow(MVStore.java:972) >> at org.h2.mvstore.MVStore.commitAndSave(MVStore.java:907) >> at org.h2.mvstore.MVStore.beforeWrite(MVStore.java:2102) >> at org.h2.mvstore.MVMap.beforeWrite(MVMap.java:1040) >> at org.h2.mvstore.MVMapConcurrent.put(MVMapConcurrent.java:43) >> 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.MVSecondaryIndex.add( >> MVSecondaryIndex.java:209) >> at org.h2.mvstore.db.MVTable.addRow(MVTable.java:610) >> ... 16 more >> >> -- > 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. > -- 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.
