Topic
  • 1 reply
  • Latest Post - ‏2012-02-22T04:34:01Z by dhanya_aishwarya
SystemAdmin
SystemAdmin
4447 Posts

Pinned topic JPA timeout Oracle

‏2011-08-10T09:37:38Z |
Has anyone experiences unusual slowness and timeout in JPA (Implementation used on RAD 7) connecting to Oracle datasource? Similar queries through normal JDBC on the same data don't have any such issue. As I could not find any thread so far with a similar issue I assume it is something basic that is missing.
What is unusual is a simple fetch from a small table timing out after 120 seconds.

========================================
8/10/11 14:36:36:073 UZT 0000001f TimeoutManage I WTRN0006W: Transaction 00000.....AC33D4700000001 has timed out after 120 seconds.

8/10/11 14:36:36:073 UZT 0000001f TimeoutManage I WTRN0124I: When the timeout occurred the thread with which the transaction is, or was most recently, associated was ThreadWebContainer : 2,5,main. The stack trace of this thread when the timeout occurred was:

java.net.SocketInputStream.socketRead0(Native Method)

java.net.SocketInputStream.read(SocketInputStream.java:140)

oracle.net.ns.Packet.receive(Packet.java:240)

oracle.net.ns.DataPacket.receive(DataPacket.java:92)

oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:172)

oracle.net.ns.NetInputStream.read(NetInputStream.java:117)

oracle.net.ns.NetInputStream.read(NetInputStream.java:92)

oracle.net.ns.NetInputStream.read(NetInputStream.java:77)

oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1034)

oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010)

oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:588)

oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)

oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)

oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)

oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)

oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)

oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1099)

com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:720)

org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:264)

org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:893)

org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1599)

org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)

org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:509)

org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384)

org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:339)

org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:420)

org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)

org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)

org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:206)

org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrategy.load(StoreCollectionFieldStrategy.java:548)

org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:819)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:692)

com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:125)

org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:116)

org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:78)

org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:2910)

org.apache.openjpa.kernel.StateManagerImpl.load(StateManagerImpl.java:379)

org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:881)

org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:793)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:986)

com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:107)

org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:278)

org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2415)

org.apache.openjpa.jdbc.meta.strats.RelationFieldStrategy.loadEagerJoin(RelationFieldStrategy.java:541)

org.apache.openjpa.jdbc.meta.FieldMapping.loadEagerJoin(FieldMapping.java:807)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1052)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1012)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:660)

com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:125)

org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:116)

org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:78)

org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:2910)

org.apache.openjpa.kernel.StateManagerImpl.load(StateManagerImpl.java:379)

org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:830)

org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:793)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:986)

com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:107)

org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:278)

org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2415)

org.apache.openjpa.jdbc.meta.strats.RelationToManyInverseKeyFieldStrategy.loadElement(RelationToManyInverseKeyFieldStrategy.java:87)

org.apache.openjpa.jdbc.meta.strats.RelationCollectionInverseKeyFieldStrategy.loadElement(RelationCollectionInverseKeyFieldStrategy.java:76)

org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrategy.processEagerParallelResult(StoreCollectionFieldStrategy.java:312)

org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrategy.loadEagerParallel(StoreCollectionFieldStrategy.java:246)

org.apache.openjpa.jdbc.meta.FieldMapping.loadEagerParallel(FieldMapping.java:801)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1055)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:1012)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:378)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:278)

com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.initialize(WsJpaJDBCStoreManager.java:144)

org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:111)

org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)

org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:913)

org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:871)

org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:793)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:986)

com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:107)

org.apache.openjpa.jdbc.sql.AbstractResult.load(AbstractResult.java:278)

org.apache.openjpa.jdbc.sql.SelectImpl$SelectResult.load(SelectImpl.java:2415)

org.apache.openjpa.jdbc.meta.strats.RelationToManyInverseKeyFieldStrategy.loadElement(RelationToManyInverseKeyFieldStrategy.java:87)

org.apache.openjpa.jdbc.meta.strats.RelationCollectionInverseKeyFieldStrategy.loadElement(RelationCollectionInverseKeyFieldStrategy.java:76)

org.apache.openjpa.jdbc.meta.strats.StoreCollectionFieldStrategy.load(StoreCollectionFieldStrategy.java:555)

org.apache.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:819)

org.apache.openjpa.jdbc.kernel.JDBCStoreManager.load(JDBCStoreManager.java:692)

com.ibm.ws.persistence.jdbc.kernel.WsJpaJDBCStoreManager.load(WsJpaJDBCStoreManager.java:125)

org.apache.openjpa.kernel.DelegatingStoreManager.load(DelegatingStoreManager.java:116)

org.apache.openjpa.kernel.ROPStoreManager.load(ROPStoreManager.java:78)

org.apache.openjpa.kernel.StateManagerImpl.loadFields(StateManagerImpl.java:2910)

org.apache.openjpa.kernel.StateManagerImpl.load(StateManagerImpl.java:379)

org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:830)

org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:788)

org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:183)

org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:453)

com.ibm.ws.jpa.management.JPATxEmInvocation.find(JPATxEmInvocation.java:211)

com.ibm.ws.jpa.management.JPAEntityManager.find(JPAEntityManager.java:185)

com.chartisinsurance.userprofileservices.gp.dao.UserManagementDAO.activateUser(UserManagementDAO.java:164)

com.chartisinsurance.userprofileservice.service.UserManagementEJB.activateUser(UserManagementEJB.java:65)

com.chartisinsurance.userprofileservice.service.EJSLocal0SLUserManagementEJB_2135c05b.activateUser(EJSLocal0SLUserManagementEJB_2135c05b.java)

com.chartisinsurance.userprofileservices.delegate.UserMgmtDelegate.activateUser(UserMgmtDelegate.java:44)

com.chartisinsurance.ebiz.portaluserprofileservicewsdl.UserProfileSOAPBindingImpl.activateUser(UserProfileSOAPBindingImpl.java:45)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

java.lang.reflect.Method.invoke(Method.java:611)

org.apache.axis2.jaxws.server.dispatcher.JavaDispatcher.invokeTargetOperation(JavaDispatcher.java:82)

org.apache.axis2.jaxws.server.dispatcher.JavaBeanDispatcher.invoke(JavaBeanDispatcher.java:98)

org.apache.axis2.jaxws.server.EndpointController.invoke(EndpointController.java:111)

org.apache.axis2.jaxws.server.JAXWSMessageReceiver.receive(JAXWSMessageReceiver.java:161)

org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:188)

org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)

com.ibm.ws.websvcs.transport.http.WASAxis2Servlet.doPost(WASAxis2Servlet.java:1378)

javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)

com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3933)

com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276)

com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:931)

com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)

com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:445)

com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:504)

com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:301)

com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:275)

com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)

8/10/11 14:36:40:245 UZT 00000025 SystemOut O 2011-08-10T14:34:21.000+05:00

8/10/11 14:36:42:339 UZT 00000034 SystemOut O Initializing the oracleJPAFactory...

8/10/11 14:36:47:308 UZT 0000003e WSChannelFram A CHFW0019I: The Transport Channel Service has started chain HttpsOutboundChain:10.175.61.28:8444:1302722041.
Updated on 2012-02-22T04:34:01Z at 2012-02-22T04:34:01Z by dhanya_aishwarya
  • dhanya_aishwarya
    dhanya_aishwarya
    1 Post

    Re: JPA timeout Oracle

    ‏2012-02-22T04:34:01Z  
    Hi Harish,

    Did you resolve this issue? If yes please let me know the solution. I have ran into a similar problem.

    Thanks,
    Dhanya