NPE while loading large dataset

126 views
Skip to first unread message

Mark Addleman

unread,
Nov 7, 2015, 9:23:49 PM11/7/15
to H2 Database
I'm loading a large data set into four tables within a single transaction. I'm not sure what information is useful to track down this exception reported in the trace file:
2015-11-07 18:10:42 database: flush
org.h2.message.DbException: General error: "java.lang.NullPointerException" [50000-190]
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.mvstore.db.MVTableEngine$1.uncaughtException(MVTableEngine.java:94)
at org.h2.mvstore.MVStore.writeInBackground(MVStore.java:2503)
at org.h2.mvstore.MVStore$BackgroundWriterThread.run(MVStore.java:2689)
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-190]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
... 5 more
Caused by: java.lang.NullPointerException
at org.h2.mvstore.db.ValueDataType.compare(ValueDataType.java:102)
at org.h2.mvstore.db.TransactionStore$ArrayType.compare(TransactionStore.java:1737)
at org.h2.mvstore.MVMap.areValuesEqual(MVMap.java:601)
at org.h2.mvstore.MVMap.replace(MVMap.java:615)
at org.h2.mvstore.MVMap.rewrite(MVMap.java:806)
at org.h2.mvstore.MVMap.rewrite(MVMap.java:823)
at org.h2.mvstore.MVMap.rewrite(MVMap.java:823)
at org.h2.mvstore.MVMap.rewrite(MVMap.java:823)
at org.h2.mvstore.MVMap.rewrite(MVMap.java:823)
at org.h2.mvstore.MVMap.rewrite(MVMap.java:782)
at org.h2.mvstore.MVStore.compactRewrite(MVStore.java:1905)
at org.h2.mvstore.MVStore.compact(MVStore.java:1797)
at org.h2.mvstore.MVStore.writeInBackground(MVStore.java:2499)
... 1 more

Mark Addleman

unread,
Nov 7, 2015, 9:24:41 PM11/7/15
to H2 Database
This is version 1.4.190

Mark Addleman

unread,
Nov 25, 2015, 1:23:12 PM11/25/15
to H2 Database
bump

On Saturday, November 7, 2015 at 9:24:41 PM UTC-5, Mark Addleman wrote:
This is version 1.4.190

Yadlapalli Vasu

unread,
Dec 2, 2015, 2:25:06 AM12/2/15
to H2 Database
I also got same exception for 1.4.190 for large data set query. Basically i have observed this exception while doing lot of CRUD operations on same table. I have used MULTI_THREADED=1 and MVCC=TRUE.
Reply all
Reply to author
Forward
0 new messages