org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ; SQL statement: DELETE FROM ALARM_HISTORY [50200-192]

Google Groups | Dave Anonymous | 3 months ago
  1. 0

    Error 50200-192 if delete from table after upgrading from 1.3.176 to 1.4.192

    Google Groups | 3 months ago | Dave Anonymous
    org.h2.jdbc.JdbcSQLException: Timeout trying to lock table ; SQL statement: DELETE FROM ALARM_HISTORY [50200-192]
  2. 0

    mvcc

    Google Groups | 6 years ago | Rami Ojares
    org.h2.jdbc.JdbcSQLException: Cannot change the setting "MVCC" when the database is already open; SQL statement: SET MVCC TRUE [90133-147]
  3. 0

    SymmetricDS 3.8 demo not working

    symmetricds | 2 months ago | mike182764
    org.h2.jdbc.JdbcSQLException: Table "SALE_TRANSACTION" not found; SQL statement: insert into sale_transaction (tran_id, store_id, workstation, day, seq) values (1000, '001', '3', '2014-03-21', 100) [42102-176]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    しばらく使っているとInternal Server Errorが出る

    GitHub | 2 years ago | yoshimov
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Transaction is closed [1.4.183/4]"; SQL statement: ROLLBACK [50000-183]
  6. 0

    H2 db: how to run a SQL script in the current directory

    Stack Overflow | 3 years ago | Micdev42
    org.h2.jdbc.JdbcSQLException: IO Exception: "java.io. FileNotFoundException: resource /DropSchemas.sql"; "classpath:/DropSchemas.sql"; SQL statement:</p> <pre><code>runscript from 'classpath:/DropSchemas.sql' [90031-172]

  1. andyglick 352 times, last 9 months ago
16 unregistered visitors
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

    Row not found when trying to delete from index "PUBLIC.IDX_ALARM_HISTORY_ACCOUNTALARMDATE: ( /* key:23 */ 7653, 0, 83, 'SAB 1', 1, '1', 1, 1, 'External 1 Alarm ({NoUserText})', TIMESTAMP '2016-09-02 09:45:36.822')" [90112-192]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    TcpServerThread.run
    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.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:234)
    5. org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:336)
    6. org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:245)
    7. org.h2.index.MultiVersionIndex.remove(MultiVersionIndex.java:192)
    8. org.h2.table.RegularTable.removeRow(RegularTable.java:389)
    9. org.h2.command.dml.Delete.update(Delete.java:95)
    10. org.h2.command.CommandContainer.update(CommandContainer.java:98)
    11. org.h2.command.Command.executeUpdate(Command.java:258)
    12. org.h2.server.TcpServerThread.process(TcpServerThread.java:344)
    13. org.h2.server.TcpServerThread.run(TcpServerThread.java:158)
    13 frames
  3. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame