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 thi
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 th
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 informa
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
Hi,
Sorry for the delay.
> Why isn't that table saved in MVStore like any other table?
Now it is. Possibly this will change in the future, but right now it's OK.
I don't see an urgent need to change it. Using the StreamStore would add a
few features, but those are not important right now.
Regar
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 somewha
tes from an
> MVStore table, I am seeing 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.
LException: 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(LobStor
ries.
>
>
>
> 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.message.DbExcepti
d in the
>> 159 version. Anyone see this and know what the actual issue is, I've used
>> the error identifier on h2database and it says an io error occurred. I'm
>> getting this at the very end of my unit test run after using the table
>> structure to create/
error occurred. I'm
> getting this at the very end of my unit test run after 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 Exceptio
r occurred. I'm
getting this at the very end of my unit test run after 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/1
ace.
>
> 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(DbExcepti
I get 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(
18 matches
Mail list logo