Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-29 Thread Viktor Voytovych
...@finaris.de javascript: www: http://www.finaris.de und http://www.rapidrep.com From:Viktor Voytovych vvoyt...@llnw.com javascript: To:h2-da...@googlegroups.com javascript: Date:25.09.2014 09:26 Subject:Re: [h2] Timeout trying to lock table SYS during table

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-25 Thread Viktor Voytovych
I've started getting this: Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table SYS; SQL statement: INSERT INTO TABLE_83e6fcbd876844f39b8a4d5dd53fe021 (time, bytes) VALUES (?,?) [50200-181] at org.h2.message.DbException. getJdbcSQLException(DbException.java:345) at

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-25 Thread christoff . schmitz
@googlegroups.com Date: 25.09.2014 09:26 Subject:Re: [h2] Timeout trying to lock table SYS during table creation Sent by:h2-database@googlegroups.com I've started getting this: Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table SYS; SQL statement: INSERT

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-23 Thread Noel Grandin
On 2014-09-22 04:24 PM, Viktor Voytovych wrote: Hello, I'm continuously getting timeouts (Timeout trying to lock table SYS) when trying to create new table under load (even insignificant). I would suggest updating to the latest version, since we have fixed a few bugs in the this area

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-23 Thread Viktor Voytovych
Thanks. Would you recommend Version 1.3.176 (2014-04-05) that is Last Stable or Version 1.4.181 (2014-08-06) that is Beta? On Tuesday, September 23, 2014 10:23:15 AM UTC+3, Noel Grandin wrote: On 2014-09-22 04:24 PM, Viktor Voytovych wrote: Hello, I'm continuously getting timeouts

Re: [h2] Timeout trying to lock table SYS during table creation

2014-09-23 Thread Viktor Voytovych
Thanks. Testing it. On Tuesday, September 23, 2014 11:04:53 AM UTC+3, Noel Grandin wrote: On 2014-09-23 09:57 AM, Viktor Voytovych wrote: Thanks. Would you recommend Version 1.3.176 (2014-04-05) that is Last Stable or Version 1.4.181 (2014-08-06) that is Beta? Since you are

[h2] Timeout trying to lock table SYS during table creation

2014-09-22 Thread Viktor Voytovych
Hello, H2 v1.3.175 URL: jdbc:h2:mem:queries_db;CACHE_SIZE=32768;DATABASE_TO_UPPER=false;IGNORECASE=false;DB_CLOSE_DELAY=-1;MULTI_THREADED=1;LOCK_TIMEOUT=1;LOG=0;UNDO_LOG=0;JMX=TRUE I's embedded database with in-memory tables only (table per request). After table is created multiple threads