PM72148: VALIDATENEWCONNECTIONTIMEOUT DOES NOT WORK FOR EXISTING ORACLE CONNECTIONS WHEN THE DATABASE IS IN A HUNG STATE

Fixes are available

APAR status

Closed as program error.

Error description

When validating an existing connection where the Database
server is in a "hung" state - that is, the Database is accepting
connections but not processing them in a timely manner,
documentation of validateNewConnectionTimeout implies the pool
manager should time out,  but that does not appear to be
happening.

The issue can be reproduced by putting a proxy between the
application server and database server that has the ability to
continue to accept data being sent by the application server,
but stop sending responses producing a hung state.

Local fix

```
N/A
```

Problem summary

****************************************************************
* USERS AFFECTED:  All users of IBM WebSphere Application      *
*                  Server                                      *
****************************************************************
* PROBLEM DESCRIPTION: Database server hang renders the        *
*                      connection close thread hung while      *
*                      destroying connections.                 *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When the database is hung , the call to close physical
connection to database hangs as part of destroying the pool as
per connection pool settings. Check to validate if the
connection is valid before closing the physical connection
needs
to be done so that cleanup thread does not hang.

Problem conclusion

The isValid method has a timeout of 2 seconds as this
method could be called multiple times as part of destroying
the pool and the total time to cleanup the pool may take many
seconds.

Note : This APAR is not enabled by default and in order to
enable the APAR you will have to define a datasource custom
property on the respective datasources
Navigate to:
Resources > JDBC > JDBC providers > JDBC_provider > Data
sources > (data_source) > Custom properties
Define the following custom property :
Property Name : closeValidConnections
Value : true
Restart the servers for the custom property to take effect.

The fix for this APAR is currently targeted for inclusion in
fix packs 8.5.0.2 , 8.0.0.6 and 7.0.0.29.  Please refer to the
Recommended Updates page for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Temporary fix

Comments

APAR Information

APAR number
PM72148
Reported component name
WEBS APP SERV N
Reported component ID
5724H8800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-09-04
Closed date
2012-12-17
Last modified date
2013-05-28

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
WEBS APP SERV N
Fixed component ID
5724H8800

Applicable component levels

R700 PSY
UP
R800 PSY
UP
R850 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
28 April 2022

Tips

PM72148: VALIDATENEWCONNECTIONTIMEOUT DOES NOT WORK FOR EXISTING ORACLE CONNECTIONS WHEN THE DATABASE IS IN A HUNG STATE

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

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

Fixed component ID

Applicable component levels

R700 PSY

R800 PSY

R850 PSY

Document Information

Share your feedback

Need support?