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.
