Bug ID 469742: Intermittent instances of SQL monitor database connections hanging

Last Modified: May 29, 2024

Affected Product(s):
BIG-IP LTM(all modules)

Known Affected Versions:
11.4.0

Opened: Jun 30, 2014

Severity: 3-Major

Symptoms

You might intermittently encounter instances of SQL monitor database connections hanging.

Impact

Connections might hang intermittently. Note: Because this release contains no SQL monitors commands to check the status of outstanding pings and cached connections, it might be difficult to debug the issues.

Conditions

This occurs with monitors that access SQL databases, such as Oracle monitors.

Workaround

None.

Fix Information

None

Behavior Change

A new command has been added to help diagnose the state of the SQL monitors: -- /usr/share/monitors/DB_monitor cmd status [RD] [debug] -- RD: optional, the route domain for the desired Java daemon (each route domain gets a separate daemon) -- debug: optional, do debug logging Examples: -- /usr/share/monitors/DB_monitor cmd status -- /usr/share/monitors/DB_monitor cmd status 0 -- /usr/share/monitors/DB_monitor cmd status 17 -- /usr/share/monitors/DB_monitor cmd status 9 debug

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips