Hi

I have been using some weeks now the 1.4 branch in my development environment.

MV_STORE has been on (I assume this based on filename .mv.db)
MVCC has been off (does this make sense?)
MULTI_THREADED has been on.

Every now and then the database becomes corrupted.

I will turn now MULTI_THREADED off and MVCC on and see how that goes.
I will report about my experiences in few weeks.

The latest error message was:

Exception in thread "main" org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Chunk 117176 not found [1.4.181/6]" [50000-181] 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.server.TcpServerThread.run(TcpServerThread.java:149)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: Chunk 117176 not found [1.4.181/6] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:762)
        at org.h2.mvstore.MVStore.getChunk(MVStore.java:847)
        at org.h2.mvstore.MVStore.readPage(MVStore.java:1795)
        at org.h2.mvstore.MVMap.readPage(MVMap.java:769)
        at org.h2.mvstore.MVMap.setRootPos(MVMap.java:779)
        at org.h2.mvstore.MVStore.openMap(MVStore.java:449)
at org.h2.mvstore.db.TransactionStore.openMap(TransactionStore.java:370) at org.h2.mvstore.db.TransactionStore$Transaction.openMap(TransactionStore.java:729) at org.h2.mvstore.db.MVSecondaryIndex.<init>(MVSecondaryIndex.java:71)
        at org.h2.mvstore.db.MVTable.addIndex(MVTable.java:419)
        at org.h2.command.ddl.CreateIndex.update(CreateIndex.java:94)
        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)
        ... 7 more

        at org.h2.engine.SessionRemote.done(SessionRemote.java:622)
at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:141) at org.h2.engine.SessionRemote.connectServer(SessionRemote.java:446) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:327)
        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 java.sql.DriverManager.getConnection(DriverManager.java:571)
        at java.sql.DriverManager.getConnection(DriverManager.java:215)
        at org.h2.tools.Shell.runTool(Shell.java:146)
        at org.h2.tools.Shell.main(Shell.java:79)

--
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.

Reply via email to