This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Timedout Exception

 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What could be the cause of this error?

esidual_billing][AccountInfoDAO][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAccountDetailsList(ProjPk projPk) ends
[residual_billing][ProjHelper][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getAccountsList(form)
[residual_billing][ProjHelper][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][GlobalParamContext][02/25 12:22:50.811][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getGlobalMap() method strats here
[residual_billing][ConnectionMgr][02/25 12:22:50.811][INFO][Severity 4] [] Method Starts Here
[residual_billing][GlobalParamContext][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getGlobalMap() method ends here
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] handleModifyRequest(projSetupForm,session,user)
[residual_billing][ProjModifyInitialAction][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][ConnectionMgr][02/25 12:24:12.478][DEBUG][Severity 4] [] Not able to get the connection
 
Joe Ess
Bartender
Posts: 9320
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I can't tell you with what you've given us.
What are you trying to connect to?
Do you have a stack trace?
The code where the error occurs?
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Using WAS 6.0.2,DB2 and struts.Trying to connect to DB2 using JDBC.It keeps on throwing Connection Timeout Exception

Only 3 concurrent users for pilot run and 10 connections are allocated in connection pool of WAS.Using SessionDB for Session management of WAS.


There are two errors

1)SESN0040E: BackedHashtable:commonSetup - problem streaming object

2)com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000

1)2/21/08 7:54:08:751 GMT] 00000cbc LocalTranCoor W WLTC0033W: Resource jdbc/in_gdbilling_resbill rolled back in cleanup of LocalTransactionContainment.
[2/21/08 7:54:08:785 GMT] 00000cbc LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainment.
[2/21/08 7:54:12:633 GMT] 000000ae SessionContex E SESN0040E: BackedHashtable:commonSetup - problem streaming object. Exception caught while trying to serialize session data for subsequent database write. The session data may be too large to serialize. Either put less data in the session or consider configuring Session Manager for MultiRow database mode.


2)[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] getLocationsMap()
[residual_billing][ProjHelper][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] handleModifyRequest(projSetupForm,session,user)
[residual_billing][ProjModifyInitialAction][02/25 12:22:50.834][DEBUG][Severity 4] [w3alpha.toronto.ca.ibm.com] execute(mapping,form,request,response)
[residual_billing][ConnectionMgr][02/25 12:24:12.478][DEBUG][Severity 4] [] Not able to get the connection
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180000
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:302)
at services.in.gdbilling.config.ConnectionMgr.getConnection(ConnectionMgr.java(Compiled Code))
at services.in.gdbilling.in.dao.ViewProjDAO.getProjInfo(ViewProjDAO.java:69)
at services.in.gdbilling.cc.helper.LogonHelper.createRBUser(LogonHelper.java:272)
at services.in.gdbilling.ui.logon.actions.LogonAction.execute(LogonAction.java:136)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)
[
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Connection Timeout Error is hitting everywhere.I can not tell one place where it is going to hit.Users are complaining this error in different screens and places.It is very difficult to pinpoint the place where it throws this error.
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
00000337 LocalTranCoor W WLTC0033W: Resource jdbc/in_gdbilling_resbill rolled back in cleanup of LocalTransactionContainment.
00000337 LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled

Needs to following things
From Database
these are the apps currently connected:

Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
can whittle down the list of those app ids that are in lock wait, and those that are not,
and we can try purging the ones that you deem least likely to cause issues... the ones in
UOW status (idle) can usually be purged
Get lock snapshot , so that we can pin point why is this happening

while you're reading through that snaplock - I found another UOW thread - 885, it also has one X lock will check that after this force hmmm, looks like 932 is gone now
Paul can you please tell us what is LOCKTIMEOUT value?
can you please tell us what is LOCKTIMEOUT value
db2 get db cfg | grep LOCK
LOCKTIMEOUT=-1
db2 get db cfg for RESBILL |grep LOCK
Max storage for lock list (4KB) (LOCKLIST) = 100
Percent. of lock lists per application (MAXLOCKS) = 10
Lock timeout (sec) (LOCKTIMEOUT) = -1


what enterprising soul set that value, I wonder? no wonder all those apps are just sitting there lockwaiting

Needs to find out Lock Wait
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic