Hi,
I'd like to give some other information if it is on this topic. (sorry for my English also) say we make 3 same concurrent update transaction on H2 db, each looks like "update table1 on row1; sleep 50ms(make the transaction take some time); update table1 on row1", then It has big chance to see error: "Timeout trying to lock table" tweak the timeout config value does not help, and I don't think we need to set it, because the case is so normal in real life usage. --- neoe On Monday, November 19, 2018 at 1:38:31 PM UTC+8, [email protected] wrote: > > Dear All, > > we use H2 extensively and think it is a great software. We have a small > database with something around 50 tables, with perhaps 1000 records each. > The server has 16 cores and 16 GB Ram. > Also the same Object Model (Tables, Indexes and Queries) runs on large > Oracle databases with more the 100 Mill. records and we use a lot of > recursive queries, so far without > any problems. > > So I was very surprised when this came up: > > Caused by: java.sql.SQLException: org.h2.jdbc.JdbcSQLTimeoutException: > Timeout trying to lock table {0}; SQL statement: > SELECT /*+PARALLEL*/ > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
