Error 50000 at db opening and connection test
Olivier
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
Sergi Vladykin
Looks like your database file is corrupted. Try to recreate database
from scratch.
Thomas Mueller
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
Olivier Grégoire
Indeed I'm using that version, it's the one I downloaded when I wanted to start the project, but it seems a bit outdated now that I'm actually starting it.
I just tested with the 1.2.131 (since it has the label "Latest Stable" unlike 1.2.132) and it works like a charm!
Thank you very much: you just saved my day!
Regards,
Olivier
--
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.