java.util.concurrent.ExecutionException: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "SYS"; SQL statement: CREATE VIEW INVOICE_DETAIL_VIEW124 as SELECT DTL.* FROM INVOICE_VIEW124 INV JOIN INVOICE_DETAIL_VIEW DTL ON INV.INVOICE_ID = DTL.INVOICE_ID WHERE DESCRIPTION='TEST' [50200-192]

h2database.com | 2 months ago
  1. 0

    h2database.com | 2 months ago
    java.util.concurrent.ExecutionException: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "SYS"; SQL statement: CREATE VIEW INVOICE_DETAIL_VIEW124 as SELECT DTL.* FROM INVOICE_VIEW124 INV JOIN INVOICE_DETAIL_VIEW DTL ON INV.INVOICE_ID = DTL.INVOICE_ID WHERE DESCRIPTION='TEST' [50200-192]
  2. 0

    H2.sql missing dist_reindex tables

    GitHub | 3 years ago | wezell
    com.dotmarketing.exception.DotDataException: Table "DIST_LOCK" not found; SQL statement: select * from dist_lock for update [42102-169]
  3. 0

    Syntax error when you try to delete the pushed asset history from maintenance

    GitHub | 2 years ago | bryanboza
    com.dotmarketing.exception.DotDataException: Syntax error in SQL statement "TRUNCATE PUBLISHING_PUSHED_ASSETS[*] "; expected "TABLE"; SQL statement: TRUNCATE publishing_pushed_assets [42001-176]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    dbColumnName problem in Mapper, schemify, CRUDify in 1.1-M6 and 1.1-SHAPSHOT

    GitHub | 7 years ago | econoplas
    org.h2.jdbc.JdbcSQLException: Duplicate column name ACTIVE; SQL statement: ---> ALTER TABLE PROJECT_TYPE ADD COLUMN ACTIVE BOOLEAN [42121-121]
  6. 0

    Layers not saved in the workspace

    GitHub | 2 years ago | gpetit
    org.h2.jdbc.JdbcSQLException: Table "SUPERPOSE2" not found; SQL statement: CREATE FORCE TRIGGER IF NOT EXISTS DM_SUPERPOSE2 AFTER INSERT, UPDATE, DELETE ON "SUPERPOSE2" CALL "org.orbisgis.h2triggers.H2Trigger" [42102-182]

  1. archenroot 1 times, last 1 month ago
  2. tvrmsmith 1 times, last 2 months ago
  3. Kawada 3 times, last 2 months ago
  4. Shadd518 3 times, last 3 months ago
11 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

    Timeout trying to lock table "SYS"; SQL statement: CREATE VIEW INVOICE_DETAIL_VIEW124 as SELECT DTL.* FROM INVOICE_VIEW124 INV JOIN INVOICE_DETAIL_VIEW DTL ON INV.INVOICE_ID = DTL.INVOICE_ID WHERE DESCRIPTION='TEST' [50200-192]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    JdbcStatement.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.mvstore.db.MVTable.doLock1(MVTable.java:223)
    5. org.h2.mvstore.db.MVTable.lock(MVTable.java:167)
    6. org.h2.engine.Database.lockMeta(Database.java:909)
    7. org.h2.engine.Database.addSchemaObject(Database.java:1005)
    8. org.h2.command.ddl.CreateView.update(CreateView.java:130)
    9. org.h2.command.CommandContainer.update(CommandContainer.java:98)
    10. org.h2.command.Command.executeUpdate(Command.java:258)
    11. org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
    12. org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
    12 frames
  3. org.h2.test
    TestMultiThread$6.call
    1. org.h2.test.db.TestMultiThread$6.call(TestMultiThread.java:338)
    2. org.h2.test.db.TestMultiThread$6.call(TestMultiThread.java:327)
    2 frames
  4. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask.run(FutureTask.java:266)
    2. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    3. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    4. java.lang.Thread.run(Thread.java:744)
    4 frames