PH18970: CONNECTION POOL HANDS OUT ABORTED CONNECTION

9.0.5.3: WebSphere Application Server traditional Version 9.0.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• ERROR: Caught exception attempting to call test method
  testTransactionTimeoutAbort on servlet
  jdbc.fat.v41.web.BasicTestServlet
  java.lang.IllegalStateException: getManagedConnection: illegal
  state exception. State = STATE_INACTIVE MCW = d3ce17fb
   at
  com.ibm.ejs.j2c.MCWrapper.getManagedConnection(MCWrapper.java:68
  0)
   at
  com.ibm.ejs.j2c.FreePool.getMCWrapperFromMatch(FreePool.java:128
  7)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server using jdbc datasources               *
  ****************************************************************
  * PROBLEM DESCRIPTION: A connection that is processed to be    *
  *                      destroyed can in some cases result in   *
  *                      additional errors.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following error can occur,
  java.lang.IllegalStateException: getManagedConnection: illegal
  state exception. State = STATE_INACTIVE MCW = d3ce17fb
  at
  com.ibm.ejs.j2c.MCWrapper.getManagedConnection(MCWrapper.java:68
  0)
  at
  com.ibm.ejs.j2c.FreePool.getMCWrapperFromMatch(FreePool.java:128
  when a connection is being used on one thread, but on another
  thread being destroy due to a connection failure.
  

Problem conclusion

• This will reduce the number of failures being logged by
  processing failed connections faster when multithreaded access
  occurs to the same managed connection.
  
  The fix for this APAR is targeted for inclusion in fix pack
  8.5.5.18 and 9.0.5.3.  For more information, see 'Recommended
  Updates
  for
  WebSphere Application Server':
  http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WEBSPHERE APP S

• Fixed component ID

  5724J0800

Applicable component levels

• R850 PSY

     UP

• R900 PSY

     UP