org.h2.jdbc.JdbcSQLException: The database has been closed [90098-187]

Google Groups | Faraz Rizvi | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    h2 truncate may fail

    GitHub | 4 years ago | ben-manes
    org.jooq.exception.DataAccessException: SQL [truncate table file_metadata]; Cannot truncate """file_vault"".FILE_METADATA"; SQL statement: truncate table file_metadata [90106-167]
  2. 0

    Clock crashed

    GitHub | 2 years ago | phxql
    org.h2.jdbc.JdbcSQLException: Eindeutiger Index oder Primärschlüssel verletzt: "CONSTRAINT_INDEX_B ON PUBLIC.TECHNOLOGY(PLAYER_ID, TYPE) VALUES ( /* key:2 */ null, 1, null, '2d821735-a30f-49b1-b7b1-519a00630131')" Unique index or primary key violation: "CONSTRAINT_INDEX_B ON PUBLIC.TECHNOLOGY(PLAYER_ID, TYPE) VALUES ( /* key:2 */ null, 1, null, '2d821735-a30f-49b1-b7b1-519a00630131')"; SQL statement: insert into "PUBLIC"."TECHNOLOGY" ("ID", "TYPE", "PLAYER_ID", "LEVEL") values (cast(? as uuid), cast(? as int), cast(? as uuid), cast(? as int)) [23505-176]
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Database deadlock

    GitHub | 2 years ago | phxql
    org.h2.jdbc.JdbcSQLException: Eine Verklemmung (Deadlock) ist aufgetreten. Die aktuelle Transaktion wurde rückgängig gemacht. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET (exclusive). Session #12 (user: ) on thread pool-2-thread-1 is waiting to lock PUBLIC.PLANET while locking PUBLIC.ROUND (exclusive), PUBLIC.BUILDING (exclusive), PUBLIC.EVENT (exclusive)." Deadlock detected. The current transaction was rolled back. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET (exclusive). Session #12 (user: ) on thread pool-2-thread-1 is waiting to lock PUBLIC.PLANET while locking PUBLIC.ROUND (exclusive), PUBLIC.BUILDING (exclusive), PUBLIC.EVENT (exclusive)."; SQL statement: insert into "PUBLIC"."EVENT" ("ID", "PLAYER_ID", "PLANET_ID", "TYPE", "ROUND", "FIGHT_ID") values (cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as int), cast(? as bigint), cast(? as uuid)) [40001-176]
  5. 0

    Issue 307 - h2database - Null Pointer exception while executing a Select - Java SQL database - Google Project Hosting

    google.com | 2 years ago
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-136]
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.h2.jdbc.JdbcSQLException

    The database has been closed [90098-187]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    JdbcPreparedStatement.execute
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.message.DbException.get(DbException.java:155)
    4. org.h2.message.DbException.get(DbException.java:144)
    5. org.h2.engine.Session.getTransaction(Session.java:1451)
    6. org.h2.engine.Session.getStatementSavepoint(Session.java:1461)
    7. org.h2.engine.Session.setSavepoint(Session.java:690)
    8. org.h2.command.Command.executeUpdate(Command.java:248)
    9. org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:198)
    9 frames
  3. flextrade.flexfixj.warehouse
    UpdateSessionStatement.execute
    1. flextrade.flexfixj.warehouse.impl.statements.UpdateSessionStatement.execute(UpdateSessionStatement.java:45)
    1 frame
  4. flextrade.flexfixj.persistence
    AsynchronousPersisterImpl.enqueueStatement
    1. flextrade.flexfixj.persistence.AsynchronousPersisterImpl.executeStatement(AsynchronousPersisterImpl.java:46)
    2. flextrade.flexfixj.persistence.AsynchronousPersisterImpl.enqueueStatement(AsynchronousPersisterImpl.java:37)
    2 frames
  5. flextrade.flexfixj.warehouse
    JdbcWarehouse.incrNextTargetMsgSeqNum
    1. flextrade.flexfixj.warehouse.impl.JdbcWarehouse.updateSession(JdbcWarehouse.java:227)
    2. flextrade.flexfixj.warehouse.impl.JdbcWarehouse.incrNextTargetMsgSeqNum(JdbcWarehouse.java:588)
    2 frames
  6. Apache ServiceMix :: Bundles :: ${pkgArtifactId}
    ThrottleableThreadPerSessionEventHandlingStrategy$MessageDispatchConsumer.run
    1. quickfix.SessionState.incrNextTargetMsgSeqNum(SessionState.java:370)
    2. quickfix.Session.nextHeartBeat(Session.java:1602)
    3. quickfix.Session.next(Session.java:1002)
    4. quickfix.ThrottleableThreadPerSessionEventHandlingStrategy$MessageDispatchConsumer.run(ThrottleableThreadPerSessionEventHandlingStrategy.java:151)
    4 frames
  7. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames