PQ65178: ON RECOVERY FROM DATABASE DOWN, WAITING THREADS DO NOT THROW CONNECTION WAIT TIMEOUT EXCEPTIONS WHEN WAITING ON THE POOL.

 Fixes are available

4.0.5: WebSphere Application Server Version 4.0 Fix Pack 5 (Version 4.0.5)
4.0.2-4.0.7: Component cumulative Connection Manager fix



APAR status
Closed as program error.

Error description
On an Oracle down, the connection pool is flushed when the
fatal stale connection excption is thrown. When some threads
are repopulating the pool, the other threads wait but do not thr
ow the proper connection wait timeout after the specified time.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: All WebSphere Application Server users of    *
*                 connection management to connect to a        *
*                 relational database.                         *
****************************************************************
* PROBLEM DESCRIPTION: When database server machine fails,     *
*                      user does not see                       *
*                      StaleConnectionExceptions or            *
*                      ConnectionWaitTimeoutExceptions as      *
*                      expected.                               *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
A problem existed where requests to open new connections to
the database server were serialized.  Because the database
server has failed, each request must timeout resulting in long
wait times (approximately 40 seconds) between exceptions.
Problem conclusion
Removed synchronization around getConnection requests, causing
exceptions to be thrown in a timely manner.
Temporary fix Comments
APAR information
APAR number PQ65178
Reported component name WEBSPHERE AE NT
Reported component ID 5630A2201
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-08-12
Closed date 2002-09-05
Last modified date 2002-09-05

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

SRLS

Fix information
Fixed component name WEBSPHERE AE NT
Fixed component ID 5630A2201

Applicable component levels
R400 PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ65178
IBM Group: Software Group
Modified date: Sep 5, 2002