Hi all,

I use H2 version 1.4.188 in embeddded mode (mvstore enabled) and when I 
execute the statement DEFRAG SHUTDOWN I'm not able to open a new connection 
anymore. I use a single connection in my application and that gets closed 
when I execute the shutdown statement. (connection.isClosed() returns 
true). But when I then I try to open a new connection it tells me the file 
is locked. Am I missing something here? I believe this used to work a 
couple of months ago. Has something changed, or do I have to review my 
code? ;)

Caused by: java.lang.IllegalStateException: The file is locked: 
nio:C:/H2DB.mv.db [1.4.188/7]
    at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:773)
    at org.h2.mvstore.FileStore.open(FileStore.java:167)
    at org.h2.mvstore.MVStore.<init>(MVStore.java:346)
    at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2888)
    at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:154)
    ... 68 more
Caused by: java.nio.channels.OverlappingFileLockException
    at sun.nio.ch.SharedFileLockTable.checkList(Unknown Source)
    at sun.nio.ch.SharedFileLockTable.add(Unknown Source)
    at sun.nio.ch.FileChannelImpl.tryLock(Unknown Source)
    at org.h2.store.fs.FileNio.tryLock(FilePathNio.java:121)
    at 
org.h2.mvstore.cache.FilePathCache$FileCache.tryLock(FilePathCache.java:152)
    at java.nio.channels.FileChannel.tryLock(Unknown Source)
    at org.h2.mvstore.FileStore.open(FileStore.java:164)
    ... 71 more

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