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]. 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.
