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


On 24/06/2013 4:20 PM, Juan Miguel Cejuela wrote:
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...)
--
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+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.



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


Reply via email to