Hi,

Maybe the problem is as simple as a missing index. It's hard to say. Did
you try to find out if there are any slow queries? Did you read the
documentation section "performance"?

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