I keep getting this error when I try to access my DB. I spent several
hours translating my MySQL schema into an H2 one, I close the db
(properly), and I can't reopen it or test the connection to it. It
looks like a parent "63" isn't found, but I don't understand what this
means: I never entered that value in my schema.
Does anyone know why this error occurs and how to solve it?
Thanks,
Olivier
General error: "java.lang.RuntimeException: parent not found:
63" [50000-129] HY000/50000 (Help)
org.h2.jdbc.JdbcSQLException: General error:
"java.lang.RuntimeException: parent not found:63" [50000-129]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
317)
at org.h2.message.DbException.get(DbException.java:157)
at org.h2.message.DbException.convert(DbException.java:285)
at org.h2.engine.Database.openDatabase(Database.java:230)
at org.h2.engine.Database.<init>(Database.java:195)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:140)
at org.h2.engine.Engine.getSession(Engine.java:120)
at org.h2.engine.Session.createSession(Session.java:119)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:
236)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:
214)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:111)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:95)
at org.h2.Driver.connect(Driver.java:58)
at org.h2.server.web.WebServer.getConnection(WebServer.java:589)
at org.h2.server.web.WebApp.test(WebApp.java:822)
at org.h2.server.web.WebApp.process(WebApp.java:212)
at org.h2.server.web.WebApp.processRequest(WebApp.java:161)
at org.h2.server.web.WebThread.process(WebThread.java:129)
at org.h2.server.web.WebThread.run(WebThread.java:86)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: parent not found:63
at org.h2.message.DbException.throwInternalError(DbException.java:
227)
at org.h2.store.PageStore.addMeta(PageStore.java:1303)
at org.h2.store.PageStore.readMetaData(PageStore.java:1234)
at org.h2.store.PageStore.recover(PageStore.java:1046)
at org.h2.store.PageStore.openExisting(PageStore.java:300)
at org.h2.store.PageStore.open(PageStore.java:258)
at org.h2.engine.Database.getPageStore(Database.java:2014)
at org.h2.engine.Database.open(Database.java:524)
at org.h2.engine.Database.openDatabase(Database.java:200)
... 17 more
You are using version 1.2.129. There was a bug that was fixed in
version 1.2.131: "In versions 1.2.129 and 1.2.130, a database could
not be opened sometimes after dropping tables or indexes, and then
creating new indexes for existing tables. The exception contained the
text "parent not found" (version 1.2.129) or "Table not found"
(version 1.2.130)."
See also http://www.h2database.com/html/changelog.html
The exception message you sent looks exactly like this problem. The
data is actually not lost, but you need to use version 1.2.131 or
1.2.132 to open the database.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.