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

 A fix is available

4.0.5: WebSphere Application Server Version 4.0 Fix Pack 5 (Version 4.0.5)



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 number PQ68152
Reported component name WEBSPHERE AE AI
Reported component ID 5630A2200
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-11-12
Closed date 2002-11-12
Last modified date 2002-11-12

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

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

SRLS

Fix information
Fixed component name WEBSPHERE AE AI
Fixed component ID 5630A2200

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 #: PQ68152
IBM Group: Software Group
Modified date: Nov 12, 2002