>> Moving that data external to the DB would be the first thing I'd try. Yea moving the data is planned but for now we are stuck with the current schema. So, there is no way to figure out the issue which caused the corruption?
What is your opinion on the following statement that I originally posted? "After digging into the corruption problem, we found that we use tcpAllowOthers and AUTO_SERVER=TRUE at the same time. Due to this reason, we have sometimes "server" property in the .lock.db file and sometimes not. In all the corruption cases, we found a .lock.db file with missing "server" property. We will remove this property soon." And also is there a way to set the trace file directory? "Also, I want to enable tracing but is there a way to specify a directory for trace file? a property that I can set as part of connection string? something similar to TRACE_LEVEL_FILE?" On Tuesday, 19 June 2018 14:52:26 UTC+2, Noel Grandin wrote: > > > > On 2018/06/19 2:24 PM, Behroz Sikander wrote: > > > > A few questions: > > - When I recover my corrupted DB, and query the last row, I get > > Error: org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: > org.h2.jdbc.JdbcSQLException: IO Exception: > > ""Missing lob entry, block: 1225254"" [90028-176]"; "lob: null table: 34 > id: 2266" [90031-176] > > > > Hard to say. The way LOBs work, they can generate a lot of db traffic, > even for read-only usage, so sometimes they are > just the thing most likely to show up if there is another underlying > problem. > > But also LOBs in H2 are not great, so it's possible you're managing to > trigger a bug in that implementation. > > Moving that data external to the DB would be the first thing I'd try. > > > - Is it okay to map String to CLOB column? The column which is throwing > the above error is of type CLOB in H2 but the > > ORM framework we use (Slick) has a type of String. So, internally String > is being converted to CLOB. > > > > Yup, that's fine. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
