java.util.concurrent.ExecutionException

tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafael

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • No title
    via by Unknown author,
  • Layers not saved in the workspace
    via GitHub by gpetit
    ,
  • H2 and Oracle Compatiability issues
    via Stack Overflow by john
    ,
    • 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] at java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.util.concurrent.FutureTask.get(FutureTask.java:192) at org.h2.test.db.TestMultiThread.testViews(TestMultiThread.java:361) at org.h2.test.db.TestMultiThread.test(TestMultiThread.java:70) at org.h2.test.TestBase.runTest(TestBase.java:148) at org.h2.test.TestAll.addTest(TestAll.java:896) at org.h2.test.TestAll.test(TestAll.java:785) at org.h2.test.TestAll.runTests(TestAll.java:578) at org.h2.test.TestAll.testAll(TestAll.java:523) at org.h2.test.TestAll.run(TestAll.java:475) at org.h2.test.TestAll.main(TestAll.java:416) Caused by: 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(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.mvstore.db.MVTable.doLock1(MVTable.java:223) at org.h2.mvstore.db.MVTable.lock(MVTable.java:167) at org.h2.engine.Database.lockMeta(Database.java:909) at org.h2.engine.Database.addSchemaObject(Database.java:1005) at org.h2.command.ddl.CreateView.update(CreateView.java:130) at org.h2.command.CommandContainer.update(CommandContainer.java:98) at org.h2.command.Command.executeUpdate(Command.java:258) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158) at org.h2.test.db.TestMultiThread$6.call(TestMultiThread.java:338) at org.h2.test.db.TestMultiThread$6.call(TestMultiThread.java:327) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:744)

    Users with the same issue

    Andreas Häber
    5 times, last one,
    Unknown visitor2 times, last one,
    tvrmsmith
    1 times, last one,
    osvzs
    1 times, last one,
    slash
    2 times, last one,
    143 more bugmates