PQ56061: SESSION MANAGER ALWAYS CALLS GETCONNECTION WHEN IT RECEIVES STALECONNECTIONEXCEPTION, CAUSING IT TO LOOP INDEFINATELY

APAR status
Closed as program error.

Error description
The application is using persistant sessions.  The database goes
down, and the connection manager throws StaleConnectionExceptio
n.  The connection in the pool are marked stale.  The session ma
nager will always call getConnection when it recieves StaleConne
ctionException.  The connection manager recieves the connection
request, purges the pool, and attempts to reconnect.  Since the
database is down, if it maps the database error to a certain sql
state, it will throw StaleConnectionException again.  The sessio
n manager will recieve it and attempt to get a connection
.
The end result is that as long as the database is down, the conn
 mgr and sess mgr are stuck in an endless loop of throwing Stale
ConnectionException and attempting to get a connection.  This ca
uses a spike in CPU utilization, and system performance is affex
ted.
.
To Fix this the session manager needs to either limit the number
 of connection attempts when it recieves StaleConnectionExceptio
n, set an interval between connection attempts, or both.
Local fix Problem summary
rying to obtain connections if the databas went down and did not
recover immediately.This caused high CPU utilization and the JV
m to crash eventually.
Problem conclusion
tempt to obtain a new connection from the database fails. Now we
try to get a connection only thrice and if no connection is retu
rned we do not perform any database operations.
Temporary fix Comments
APAR information
APAR number PQ56061
Reported component name WEBSPHERE AE SO
Reported component ID 5630A2202
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2001-12-18
Closed date 2001-12-18
Last modified date 2001-12-18

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

APAR is sysrouted TO one or more of the following:

Modules/Macros
SESSIONS          

Fix information
Fixed component name WEBSPHERE AE SO
Fixed component ID 5630A2202

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 #: PQ56061
IBM Group: Software Group
Modified date: Dec 18, 2001