Yes I had tried deleting index file and everything worked out properly for me. But would this not happen with 1.2.140?
Thanks Raj On Aug 31, 1:47 pm, Ryan How <[email protected]> wrote: > Have you tried deleting the Index file? H2 will rebuild it when you > reopen the database. > > The new version uses the pagestore and it seems to be a more robust > format. I haven't had any issues with it. > > On 31/08/2010 3:38 PM, raj wrote: > > > > > Hi Ryan, > > > I got this exception while using ver 119 and was wondering if someone > > could help with version 119 only or could tell if this defect is > > solved in 1.2.140. > > > Thanks > > Raj > > > On Aug 30, 1:17 pm, Ryan How<[email protected]> wrote: > >> Hi, > > >> Is it a different client and server version? > > >> The error indicated version 1.1.119, not 1.2.140 ? > > >> I think somewhere along the line there was an issue where with different > >> client and server versions. It outputs an error that doesn't make sense > >> like what you are getting. So I think the cause is an incompatible > >> client and server version. > > >> Hope this helps. > > >> Ryan > > >> On 30/08/2010 3:53 PM, raj wrote: > > >>> Hi, > >>> I am getting this exception > >>> org.h2.jdbc.JdbcSQLException: General error: > >>> java.lang.RuntimeException: File ID mismatch got=0 expected=18 > >>> pos=1420361 false org.h2.store.DiskFile:/u/users/framewrk/mfwscc/flow/ > >>> tomcat/apache-tomcat-6.0.20/mfui/db/mfui_h2_db.index.db blockCount:0; > >>> SQL statement: > >>> SELECT USER_ID FROM MFUI_USERS WHERE USER_ID =? [50000-119] > >>> at org.h2.message.Message.getSQLException(Message.java:106) > >>> at org.h2.message.Message.convert(Message.java:283) > >>> at org.h2.message.Message.convert(Message.java:244) > >>> at org.h2.command.Command.executeQueryLocal(Command.java:144) > >>> at org.h2.command.Command.executeQuery(Command.java:123) > >>> at > >>> org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: > >>> 98) > >>> at- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
