PQ63031: WEBSPHERE INTERMITTANTLY HANGS UNDER HEAVY LOAD WHEN IT LOSES CONNECTION TO THE DATABASE.

Fixes are available
WebSphere Application Server Version 3.5 Fix Pack 7 (3.5.7)
3.5.4-3.5.7, 4.0.2-4.0.7: Component cumulative Connection Manager fix

APAR

APAR status
Closed as program error.

Error description
Customer application hangs after upgrading to 3.5.6. They have
a deadlock in WebSphere at a point where they get a
translateexception that is in the process of closing the
connections to the database for a staleconnectionexception. This
deadlocks with the alarm thread which is processing a rollback
for a transaction timeout.
Local fix
Problem summary
****************************************************************
* USERS AFFECTED: All WebSphere Application Server users of    *
*                 Connection Pooling                           *
****************************************************************
* PROBLEM DESCRIPTION: Users may see a hang condition          *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
A condition existed where a deadlock could happen when
a StaleConnectionException was closing a connection and
at the same time the Alarm thread for transaction
timeout was causing a rollback.
Problem conclusion
The problem was that the alarm had a lock on the connection
proxy and was trying to get a lock on the statement proxy,
the StaleConnectionException processing has a lock on the
statement proxy and was trying to get a lock on the
connection proxy.  Locking now has been revised so this
cannot happen.
Temporary fix
Comments
APAR information
APAR numberPQ63031
Reported component nameWAS ADVANCED AI
Reported component ID5648C8400
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2002-07-10
Closed date2002-08-20
Last modified date2002-11-12

APAR is sysrouted FROM one or more of the following:

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

PQ68152

Modules/Macros
JDBC
APAR is sysrouted TO one or more of the following:PQ68152Modules/Macros

Fix information
Fixed component nameWAS ADVANCED AI
Fixed component ID5648C8400

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ63031
IBM Group: Software Group
Modified date: 2002-11-12