org.h2.jdbc.JdbcSQLException

tip

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


rafaelrafael

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.b.e(SourceFile:610)[Ubooquity.jar:1.10.0] at com.ubooquity.data.database.c.<init>(SourceFile:57)[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 visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    tvrmsmithtvrmsmith
    2 times, last one,
    guizmaiiguizmaii
    34 times, last one,
    144 more bugmates