Hi, > s it true that only one H2 query can execute at a time? If a query takes time, all other queries have to wait?
By default, yes. > Will MULTI_THREADED help? Most likely yes. However, there were some problems reported with this setting, so I can't recommend it currently. It may work for your use case, but it may not. Regards, Thomas On Monday, October 13, 2014, Sarmistha Samantaray < [email protected]> wrote: > H2 version 1.3.170. > > We have an application that uses H2 database. After few days of use, > application is not responding. We have to restart the application. > > > Is it true that only one H2 query can execute at a time? If a query takes > time, all other queries have to wait? > > Will MULTI_THREADED help? Any other suggestion? > > Following properties show H2 connection setting. > > > <bean id="ABC" class="com.mchange.v2.c3p0.ComboPooledDataSource" > > destroy-method="close"> > > <property name="driverClass" value="org.h2.Driver" /> > > <property name="jdbcUrl" > > value="jdbc:h2:*tcp*://*localhost*:<port>/mem:internalDB;DB_CLOSE_ON_EXIT=TRUE;MVCC=TRUE" > /> > > <property name="user" value="*sa*" /> > > <property name="password" value="*sa*" /> > > <property name="minPoolSize" value="5" /> > > <property name="initialPoolSize" value="5" /> > > <property name="maxPoolSize" value="100" /> > > <property name="maxStatements" value="300" /> > > <property name="maxIdleTime" value="3600" /> > > <property name="idleConnectionTestPeriod" value="3000" /> > > <property name="checkoutTimeout" value="5000" /> > > <property name="unreturnedConnectionTimeout" value="20" /> > > <property name="debugUnreturnedConnectionStackTraces" value="true" /> > > <property name="acquireRetryAttempts" value="1" /> > > <property name="acquireIncrement" value="1" /> > > </bean> > > Thread dump shows many threads with following info > > "H2 TCP Server (tcp://<host:port> thread" prio=10 tid=0x000000000950e800 > nid=0x18c7 waiting for monitor entry [0x00002b0fe991a000] > > Only two H2 TCP Server thread shows runnable. > > Also thread dump shows many threads with > > "http-8080-15" daemon prio=10 tid=0x00000000097d1800 nid=0x1912 in > Object.wait() [0x00002b0feaf17000] > java.lang.Thread.State: TIMED_WAITING (on object monitor) > > > > > > -- > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
