org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-187]

tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafael

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • NRS v1.5.9
    via by Unknown author,
  • NRS server has exited
    via by Unknown author,
  • Database may be already in use - H2 issue
    via Stack Overflow by arjuncc
    ,
  • 20 days without NXT client
    via by Unknown author,
  • UMS 6.0.0 broken on NixOS
    via GitHub by thall
    ,
  • NRS v1.9.1e
    via by Unknown author,
    • org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-187] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.message.DbException.get(DbException.java:179)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.message.DbException.get(DbException.java:155)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:461)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.store.FileLock.lockFile(FileLock.java:355)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.store.FileLock.lock(FileLock.java:135)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.Database.open(Database.java:634)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.Database.openDatabase(Database.java:266)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.Database.<init>(Database.java:260)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.Engine.openSession(Engine.java:60)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.Engine.openSession(Engine.java:167)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.Engine.createSession(Engine.java:128)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.Engine.createSession(Engine.java:26)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.Driver.connect(Driver.java:72)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:353)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:385)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:227)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199)[h2-1.4.187.jar.5592702856121964741.tmp:1.4.187] at com.ubooquity.data.database.c.h(SourceFile:144)[Ubooquity.jar:1.10.0] at com.ubooquity.data.database.c.<init>(SourceFile:48)[Ubooquity.jar:1.10.0] at com.ubooquity.Ubooquity.main(SourceFile:258)[Ubooquity.jar:1.10.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_92] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_92] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_92] at java.lang.reflect.Method.invoke(Method.java:498)[na:1.8.0_92] at com.ubooquity.e.c.a(SourceFile:823)[Ubooquity.jar:1.10.0] at com.ubooquity.Launcher.main(SourceFile:10)[Ubooquity.jar:1.10.0]

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor2 times, last one,
    Unknown visitor1 times, last one,
    batwalrus76
    batwalrus764 times, last one,
    Unknown visitor1 times, last one,
    144 more bugmates