Hi does it happen on 7.0.2? Did you configure eviction on the database (no link with the stateless pool)?
Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://blog-rmannibucau.rhcloud.com> | Old Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory <https://javaeefactory-rmannibucau.rhcloud.com> 2016-11-18 16:27 GMT+01:00 lreddy <likki.re...@trizetto.com>: > one of our applicaiton is deployed in TomEE and I am not sure what causing > but JVM is getting stopped in the middle of the business day and eventually > someone has to go in and manually restart the server. > > when we checked the logs, it is throwing this error > > Caused by: <openjpa-2.4.0-nonfinal-1598334-r422266:1599166 fatal general > error> org.apache.openjpa.persistence.PersistenceException: Pool wait > interrupted. > at org.apache.openjpa.jdbc.sql.DBDictionary.narrow( > DBDictionary.java:4998) > at > org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException( > DBDictionary.java:4958) > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:108) > at > org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:60) > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager. > connect(JDBCStoreManager.java:968) > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getConnection( > JDBCStoreManager.java:242) > at > org.apache.openjpa.jdbc.kernel.PreparedSQLStoreQuery$PreparedSQLExecutor. > executeQuery(PreparedSQLStoreQuery.java:104) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl. > java:1005) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) > at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) > at > org.apache.openjpa.kernel.DelegatingQuery.execute( > DelegatingQuery.java:542) > at org.apache.openjpa.persistence.QueryImpl.execute( > QueryImpl.java:275) > at > org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:291) > at > org.apache.openejb.core.cmp.jpa.JpaCmpEngine.executeSelectQuery( > JpaCmpEngine.java:280) > at > org.apache.openejb.core.cmp.jpa.JpaCmpEngine.queryBeans( > JpaCmpEngine.java:234) > at > org.apache.openejb.core.cmp.CmpContainer.findEJBObject( > CmpContainer.java:702) > at org.apache.openejb.core.cmp.CmpContainer.invoke( > CmpContainer.java:271) > at > org.apache.openejb.core.entity.EntityEjbHomeHandler. > findX(EntityEjbHomeHandler.java:65) > at > org.apache.openejb.core.ivm.EjbHomeProxyHandler._invoke( > EjbHomeProxyHandler.java:202) > ... 52 more > Caused by: java.sql.SQLException: Pool wait interrupted. > at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection( > ConnectionPool.java:655) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection( > ConnectionPool.java:188) > at > org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection( > DataSourceProxy.java:128) > at > org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection( > DelegatingDataSource.java:110) > at > org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection( > DecoratingDataSource.java:87) > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connectInternal( > JDBCStoreManager.java:979) > at > org.apache.openjpa.jdbc.kernel.JDBCStoreManager. > connect(JDBCStoreManager.java:964) > ... 66 more > Caused by: java.lang.InterruptedException > at > java.util.concurrent.locks.AbstractQueuedSynchronizer. > doAcquireSharedNanos(AbstractQueuedSynchronizer.java:1038) > at > java.util.concurrent.locks.AbstractQueuedSynchronizer. > tryAcquireSharedNanos(AbstractQueuedSynchronizer.java:1326) > at java.util.concurrent.CountDownLatch.await( > CountDownLatch.java:282) > at > org.apache.tomcat.jdbc.pool.FairBlockingQueue.poll( > FairBlockingQueue.java:151) > at > org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection( > ConnectionPool.java:650) > ... 72 more > > Here are some of the properties for our applicaiton > > myStatelessContainer = new://Container?type=STATELESS > myStatelessContainer.accessTimeout = 30 seconds > myStatelessContainer.callbackThreads = 5 > myStatelessContainer.closeTimeout = 5 minutes > myStatelessContainer.garbageCollection = false > myStatelessContainer.idleTimeout = 0 minutes > myStatelessContainer.maxAge = 0 hours > myStatelessContainer.maxAgeOffset = -1 > myStatelessContainer.maxSize = 150 > myStatelessContainer.minSize = 10 > myStatelessContainer.replaceAged = true > myStatelessContainer.replaceFlushed = false > myStatelessContainer.strictPooling = true > myStatelessContainer.sweepInterval = 5 minutes > > If someone could help me with this issue, that would be great. > > > > -- > View this message in context: http://tomee-openejb.979440. > n4.nabble.com/TomEE-servers-are-getting-stopped-in-the- > middle-of-the-day-and-is-throwing-Caused-by-openjpa-2-4-0-n-tp4680592.html > Sent from the TomEE Dev mailing list archive at Nabble.com. >
