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]

Samebug tips1

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

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web873

  • via userecho.com by Unknown author, 10 months ago
    Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-187]
  • Database may be already in use: Locked by another process. Possible solutions: close all other connection(s); use the server mode [90020-50]
  • via Google Groups by Samuel Wang, 1 year ago
    Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-173]
  • Stack trace

    • 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.g(SourceFile:121)[Ubooquity.jar:1.10.0] at com.ubooquity.data.database.c.<init>(SourceFile:47)[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]

    Write tip

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

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    2 times, 1 year ago
    Unknown user
    Once, 1 year ago
    Once, 1 week ago
    6 times, 2 weeks ago
    144 more bugmates