are you calling commit __after__ the rs.getString() ?
--
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
2]: exception
org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException:
org.h2.jdbc.JdbcSQLException: IO Exception: ""Missing lob entry: 18928""
[90028-176]"; "lob: null table: -1 id: 18928" [90031-176]
at org.h2.message.DbException.getJdbcSQLExcep
yes, because you are not holding the transaction open while reading the LOB, so the LOB is disappearing while you are
reading it.
i.e.
connection.setAutoCommit(false);
read the LOB completely here..
connection.commit();
--
You received this message because you are subscribed to
Hi Noel,
The update thread and the read thread each have separate
transactions/connections(ThreadLocal) to the database.
So while the read thread is open, the update thread comes and
updates/writes to the row. (currently the table has single row) and one of
the column in CLOB.
Our observation
On 2016/12/19 3:20 PM, Mayank Tankhiwale wrote:
I am getting exceptions stating "Missing lob entry" on concurrent update and
read of a row in the table.
i.e. one thread/connection is reading(in loop) meanwhile another thread comes
and updates the CLOB. After that when the
previ
Hi,
I am getting exceptions stating "Missing lob entry" on concurrent update
and read of a row in the table.
i.e. one thread/connection is reading(in loop) meanwhile another thread
comes and updates the CLOB. After that when the previous thread reads the
row, it is failing
What connection string are you using? LOBs and MVCC are a bit stuffed...
On 15/02/2014 2:08 AM, Darren S wrote:
I seemed to hit the error Missing lob entry quite frequently for my
particular application. I was wondering if there are some settings I
should enable, or some information I can
I seemed to hit the error Missing lob entry quite frequently for my
particular application. I was wondering if there are some settings I
should enable, or some information I can capture to help debug why this is
happening. I'm using 1.3.175 across various JVM versions and
configurations
Hi Thomas,
Thank you for the update. I would like to help the project implement
LOBs with MVTableEngine. I may need to get more familiar with the
project's source before I can add something to it.
As I am looking at the source, I see that the current documentation
about the LOB storage is
this exception:
Exception in thread main java.io.IOException:
org.h2.jdbc.JdbcSQLException: IO Exception: Missing lob entry: 1/0
[90028-171]
at
org.h2.message.DbException.convertToIOException(DbException.java:348)
at
org.h2.store.LobStorage$LobInputStream.fillBuffer(LobStorage.java:466
: IO Exception: Missing lob entry: 1/0
[90028-171]
at org.h2.message.DbException.convertToIOException(DbException.java:348)
at
org.h2.store.LobStorage$LobInputStream.fillBuffer(LobStorage.java:466)
at org.h2.store.LobStorage$LobInputStream.read(LobStorage.java:380)
at PersistBLOB.run
: java.io.IOException:
org.h2.jdbc.JdbcSQLException: IO Exception: Missing lob entry: 4/14
[90028-166]; lob: null table: 16 id: 4 [90031-166]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2
using the table
structure to create/update/delete local cache entries.
org.h2.jdbc.JdbcSQLException: IO Exception: java.io.IOException:
org.h2.jdbc.JdbcSQLException: IO Exception: Missing lob entry: 4/14
[90028-166]; lob: null table: 16 id: 4 [90031-166]
at org.h2
the following stack trace.
IO Exception: java.io.IOException: org.h2.jdbc.JdbcSQLException: IO
Exception: Missing lob entry: 77/0 [90028-148]; lob: null table:
53 id: 77 [90031-148]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get
14 matches
Mail list logo