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
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/8d2958f2-516a-4ccf-9e77-e4a3ed9860b1%40googlegroups.com.
