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

Google Groups | Faraz Rizvi | 3 months ago
  1. 0

    h2 truncate may fail

    GitHub | 3 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

    Database issue

    GitHub | 3 years ago | apauzies
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "ACCOUNT"; SQL statement:|select x2."USER_NAME", x2."MAIL_ADDRESS", x2."PASSWORD", x2."ADMINISTRATOR", x2."URL", x2."REGISTERED_DATE", x2."UPDATED_DATE", x2."LAST_LOGIN_DATE", x2."IMAGE", x2."GROUP_ACCOUNT" from "ACCOUNT" x2 where x2."USER_NAME" = ? [xxxx]
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