NPEs thrown from MVStore in multithreaded mode when inserting rows by multiple threads

[GoogleCodeExporter]

General error: "java.lang.NullPointerException"; SQL statement:
INSERT INTO WorkItem VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [50000-178]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.message.DbException.convert(DbException.java:294)
    at org.h2.mvstore.db.MVTable.addRow(MVTable.java:615)
    at org.h2.command.dml.Insert.insertRows(Insert.java:157)
    at org.h2.command.dml.Insert.update(Insert.java:115)
    at org.h2.command.CommandContainer.update(CommandContainer.java:79)
    at org.h2.command.Command.executeUpdate(Command.java:254)
    at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:199)
...
Caused by: java.lang.NullPointerException
    at org.h2.store.LobStorageMap.setTable(LobStorageMap.java:241)
    at org.h2.value.ValueLobDb.link(ValueLobDb.java:246)
    at org.h2.mvstore.db.MVPrimaryIndex.add(MVPrimaryIndex.java:121)
    at org.h2.mvstore.db.MVTable.addRow(MVTable.java:611)
    ... 48 more

What steps will reproduce the problem?
- Inserting rows into table by multiple threads. All columns in the table are 
indexed. Prepared statements are used. Embedded database (not a server). 
Database parameters: ";MULTI_THREADED=TRUE;MODE=PostgreSQL". So it is 
multithreaded with MVCC.

What version of the product are you using? On what operating system, file
system, and virtual machine?
- h2-1.4.178, Windows 7, NTFS, jdk1.7.0_45

Original issue reported on code.google.com by roman.kr...@gmail.com on 10 Jun 2014 at 10:57

[GoogleCodeExporter]

Could you post the "create table" statement please?

Original comment by thomas.t...@gmail.com on 10 Jun 2014 at 2:41

[GoogleCodeExporter]

Never mind, I can reproduce the issue. I have a test case and a fix for it.

Original comment by thomas.t...@gmail.com on 10 Jun 2014 at 6:05

[GoogleCodeExporter]

Committed in the trunk

Original comment by thomas.t...@gmail.com on 10 Jun 2014 at 6:09

• Changed state: Accepted

[GoogleCodeExporter]

Should be fixed with version 1.4.179

Original comment by thomas.t...@gmail.com on 23 Jun 2014 at 6:34

• Changed state: Fixed