I got the corruption error again. This time with MVCC and no MULTI_THREADED.
The stuff I was doing was redeploying my own custom classes and stopping
and starting h2 server.
The way I stop h2 is to send SIGTERM to the jvm process.
I was wondering if it could have something to do with that.
Eg. starting a new h2 process before the previous one has completed
doing the shutdown.
Does the previous process keep the db file locked long enough so the
next process can not mess with it?
Or could the problem lie with deploying new custom classes.
Here's the exception (the same Chunk missing issue as before)
Exception in thread "main" org.h2.jdbc.JdbcSQLException: General error:
"java.lang.IllegalStateException: Chunk 10751 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 10751 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:375)
at
org.h2.mvstore.db.TransactionStore$Transaction.openMap(TransactionStore.java:729)
at org.h2.mvstore.db.MVPrimaryIndex.<init>(MVPrimaryIndex.java:74)
at org.h2.mvstore.db.MVTable.init(MVTable.java:88)
at
org.h2.mvstore.db.MVTableEngine.createTable(MVTableEngine.java:129)
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)
... 7 more
On 10.9.2014 14:37, Rami Ojares wrote:
Unfortunately I do not have one.
I can only describe in broad terms what I do.
I keep on generating tables, views etc. Importing data, doing some
changes, destroying everything, regenerating...
I do this inside vmware virtual machine that I shutdown normally, move
to another machine and so on.
Every now and then when trying to open the database I get some
corruption error.
That's all I can tell you I'm afraid.
- Rami
10.09.2014 14:10, Thomas Mueller kirjoitti:
Hi,
Do you have a reproducible test case?
For version 1.4.x, I was hoping both multi-threaded and MVCC can be
supported (even combined).
Regards,
Thomas
On Wednesday, September 10, 2014, Noel Grandin <[email protected]
<mailto:[email protected]>> wrote:
MULTI_THREADED is still experimental.
On 2014-09-10 09:53 AM, Rami Ojares wrote:
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.
--
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.
--
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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.
