I was inserting thousands of records and in the middle, I killed the
process.
When I tried to connect again, I got this ERROR :
Exception in thread "main" org.h2.jdbc.JdbcSQLException: General error:
"java.lang.IllegalStateException: The transaction log might be corrupt for
key 52051 [1.4.185/100]" [50000-185]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.engine.Database.openDatabase(Database.java:297)
at org.h2.engine.Database.<init>(Database.java:260)
at org.h2.engine.Engine.openSession(Engine.java:60)
at org.h2.engine.Engine.openSession(Engine.java:167)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
at org.h2.engine.Engine.createSession(Engine.java:128)
at org.h2.engine.Engine.createSession(Engine.java:26)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
at org.h2.Driver.connect(Driver.java:72)
at
org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190)
at org.h2.jdbcx.JdbcDataSource.getConnection(JdbcDataSource.java:161)
....
Caused by: java.lang.IllegalStateException: The transaction log might be
corrupt for key 52051 [1.4.185/100]
at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.getValue(TransactionStore.java:1224)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.getValue(TransactionStore.java:1184)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1161)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.get(TransactionStore.java:1129)
at
org.h2.mvstore.db.TransactionStore$TransactionMap.lastKey(TransactionStore.java:1290)
at org.h2.mvstore.db.MVPrimaryIndex.<init>(MVPrimaryIndex.java:79)
at org.h2.mvstore.db.MVTable.init(MVTable.java:90)
at org.h2.mvstore.db.MVTableEngine.createTable(MVTableEngine.java:130)
at org.h2.mvstore.db.MVTableEngine.createTable(MVTableEngine.java:41)
at org.h2.schema.Schema.createTable(Schema.java:582)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:137)
at org.h2.engine.MetaRecord.execute(MetaRecord.java:58)
at org.h2.engine.Database.open(Database.java:732)
at org.h2.engine.Database.openDatabase(Database.java:266)
... 18 more
I tried to recover the database, but I got the same error.
Can you help me please ?
--
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 http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
