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.

Reply via email to