1.4.201-pre: java.nio.channels.OverlappingFileLockException

[areichel]

Dear All,

unfortunately we trigger different problems with 1.4.201-pre.

When we install our software, it creates a new empty H2 database, populates it with schemas, tables and indexes and then starts to execute select statements.

All of that in SERVER mode with parallel connections.

That procedure ran well for more than 5 years and has not changed.

However, when switching to 1.4.201-pre we get File Lock exceptions like shown below.

We have tried several times, to delete the database file(s). Still the same exception occurs.

Only when I deleted the whole folder/directory it will work as expected.

Operating System is: Arch Linux with BTRFS

Connection String is: jdbc:h2:tcp://localhost//home/are/.manticore/ifrsbox;IFEXISTS=FALSE;PAGE_SIZE=128;DB_CLOSE_DELAY=30;AUTO_RECONNECT=TRUE;CACHE_SIZE=8192;

What could be the issue please?

Best regards

Andreas

Error on READ ORGANIZATION UNIT USER ROLE BY USER ID

                                     org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-200]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:623)

at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)

at org.h2.message.DbException.get(DbException.java:194)

at org.h2.mvstore.db.MVTableEngine$Store.convertIllegalStateException(MVTableEngine.java:198)

at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:174)

at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:95)

at org.h2.engine.Database.getPageStore(Database.java:2655)

at org.h2.engine.Database.open(Database.java:648)

at org.h2.engine.Database.openDatabase(Database.java:303)

at org.h2.engine.Database.<init>(Database.java:297)

at org.h2.engine.Engine.openSession(Engine.java:74)

at org.h2.engine.Engine.openSession(Engine.java:192)

at org.h2.engine.Engine.createSessionAndValidate(Engine.java:171)

at org.h2.engine.Engine.createSession(Engine.java:166)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:168)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.lang.IllegalStateException: The file is locked: /home/are/Downloads/cmb/.manticore/ifrsbox.mv.db [1.4.200/7]

at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:951)

at org.h2.mvstore.FileStore.open(FileStore.java:156)

at org.h2.mvstore.MVStore.<init>(MVStore.java:381)

at org.h2.mvstore.MVStore$Builder.open(MVStore.java:3605)

at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:162)

... 11 more

Caused by: java.nio.channels.OverlappingFileLockException

at sun.nio.ch.SharedFileLockTable.checkList(FileLockTable.java:255)

at sun.nio.ch.SharedFileLockTable.add(FileLockTable.java:152)

at sun.nio.ch.FileChannelImpl.tryLock(FileChannelImpl.java:1107)

at java.nio.channels.FileChannel.tryLock(FileChannel.java:1155)

at org.h2.mvstore.FileStore.open(FileStore.java:153)

... 14 more