Hi,
A development database ends corrupted few days after migration to v
1.2.130 (Linux 64bits. Sun JVM 1.6 )
Database was correctly closed without any abnormal termination , and at
next day startup I get this connection error:
RL - H2 emb : File corrupted while reading record: "Table not found:10
for ( /* key:9 */ 8, 1, 10, 35784, 'OFF,0,,', '1,0') meta:{0=T0_DATA,
-1=PAGE_INDEX_DATA}".
Possible solution: use the recovery tool [90030-130]
org.h2.jdbc.JdbcSQLException: File corrupted while reading record:
"Table not found:10 for ( /* key:9 */ 8, 1, 10, 35784, 'OFF,0,,', '1,0')
meta:{0=T0_DATA, -1=PAGE_INDEX_DATA}". Possible solution: use the
recovery tool [90030-130]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:317)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.get(DbException.java:145)
at org.h2.store.PageStore.addMeta(PageStore.java:1305)
at org.h2.store.PageStore.readMetaData(PageStore.java:1236)
at org.h2.store.PageStore.recover(PageStore.java:1045)
at org.h2.store.PageStore.openExisting(PageStore.java:301)
at org.h2.store.PageStore.open(PageStore.java:259)
at org.h2.engine.Database.getPageStore(Database.java:2005)
at org.h2.engine.Database.open(Database.java:524)
at org.h2.engine.Database.openDatabase(Database.java:200)
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:141)
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
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:280)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:619)
I try to recover adding RECOVERY=1 to the URL , but nothing change.
Now I will trying with Recovery tool now.
--
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.
