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 | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    h2database.com | 7 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

    Spring and Hibernate Database Tables Relationship Issues

    Stack Overflow | 9 months ago | Eddy Freeman
    org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 1 of resource class path resource [test-data.sql]: insert into contact (first_name, last_name, birth_date) values ('Chris', 'Schaefer', '1981-05-03')
  3. 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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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]
  6. 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]

  1. Andreas Häber 19 times, last 3 weeks ago
  2. tvrmsmith 2 times, last 1 month ago
  3. batwalrus76 29 times, last 1 month ago
  4. archenroot 1 times, last 6 months ago
  5. Kawada 3 times, last 6 months ago
1 more registered users
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