You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomee.apache.org by lreddy <li...@trizetto.com> on 2016/11/18 15:27:16 UTC
TomEE servers are getting stopped in the middle of the day and is
throwing "Caused by: org.apache.openjpa.persistence.PersistenceException: Pool
wait interrupted"
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.
Re: TomEE servers are getting stopped in the middle of the day and is
throwing "Caused by: org.apache.openjpa.persistence.PersistenceException: Pool wait interrupted"
Posted by Romain Manni-Bucau <rm...@gmail.com>.
2016-11-18 18:34 GMT+01:00 lreddy <li...@trizetto.com>:
> Here is the version number:Server number: 7.0.55.0
>
>
Looks like an old one, we got several fixes which can be related. Here the
tests I would recommand:
1. move to dbcp pooling (DataSourceCreator = dbcp)
2. ensure you evict the pool properly (check TestWhileIdle/ValidationQuery
properties)
If it happens again check the pool properties through JMX and get a thread
dump.
> We didn't put any of the properties with respect to eviction. Do you
> recommend any properties that I have to configure with respect to eviction?
>
>
>
>
>
> --
> 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-tp4680592p4680594.html
> Sent from the TomEE Dev mailing list archive at Nabble.com.
>
Re: TomEE servers are getting stopped in the middle of the day and
is throwing "Caused by: org.apache.openjpa.persistence.PersistenceException:
Pool wait interrupted"
Posted by lreddy <li...@trizetto.com>.
Here is the version number:Server number: 7.0.55.0
We didn't put any of the properties with respect to eviction. Do you
recommend any properties that I have to configure with respect to eviction?
--
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-tp4680592p4680594.html
Sent from the TomEE Dev mailing list archive at Nabble.com.
Re: TomEE servers are getting stopped in the middle of the day and is
throwing "Caused by: org.apache.openjpa.persistence.PersistenceException: Pool wait interrupted"
Posted by Romain Manni-Bucau <rm...@gmail.com>.
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 <li...@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.
>