Missing lob, lob: null table, when selecting CLOB for update (MVCC setting)

[Juan Miguel Cejuela]

I'm getting the following error:

org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: org.h2.message.DbException: IO Exception: ""java.io.IOException: org.h2.jdbc.JdbcSQLException: IO Exception: """"Missing lob: 7"""" [90028-170]"" [90028-168]"; "lob: null table: -1 id: 7" [90031-168]

When I do a select for update of a row with a CLOB column.

Facts:

• I added the CLOB column to an existing table.
• The table and the database were created with h2 version 168.
• The server is currently using h2 version 172.
• I use MVCC
• If I do a normal select (without for update), it works fine.

What is the cause of the error and how can I solve it?

Should I drop the MVCC setting? (although I want it...)

[Ryan How]

Hi,

Yeah this doesn't work. And nobody is currently supporting MVCC until the new Storage engine is out. So options are: Don't use MVCC. Don't use For Update with LOBS. Try and fix H2 code.

Also, Other people have noted problems with lots of LOBS and MVCC when not using for update.

Ryan

--
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 h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Juan Miguel Cejuela]

Thanks a lot for the caveat on LOBS and MVCC. I will consider other alternatives for the moment.

(reference to new storage engine: MVStore)