Bug ID 1132801: Database monitor marks pool member down if 'send' is configured but no 'receive' strings are configured

Last Modified: Dec 07, 2023

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

Known Affected Versions:
17.0.0.1, 17.0.0.2, 17.1.0, 17.1.0.1, 17.1.0.2, 17.1.0.3

Fixed In:
17.1.1

Opened: Jul 28, 2022

Severity: 1-Blocking

Symptoms

If an LTM database monitor type (MySQL, MSSQL, Oracle, or PostgreSQL database monitor type) is configured with a 'send' string but with no 'receive' string to issue a user-specified database query, pool members using this monitor are marked DOWN, even though a connection to the configured database completed successfully.

Impact

The database monitor marks the pool member down, even in cases where the pool member is actually pingable.

Conditions

-- An LTM pool or pool members is configured to use an LTM database (MySQL, MSSQL, Oracle or PostgreSQL) monitor type. -- A 'send' string is configured for the monitor. -- A 'receive' string is not configured. For BIG-IP versions earlier than v17.0.0, this issue has been addressed under ID912517.

Workaround

To work around this issue, configure 'send' and 'recv' strings for the database monitor that will always succeed when successfully connected to the specified database (with the configured username and password, if applicable).

Fix Information

Database monitor no longer marks pool member down if 'send' is configured but no 'receive' strings are configured.

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips