Bug ID 1952557: DB monitor incorrectly marks pool member UP if recv string configured but no results from DB server

Last Modified: Jun 28, 2025

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

Known Affected Versions:
16.1.5, 16.1.5.1, 16.1.5.2, 16.1.6, 17.1.2, 17.1.2.1, 17.1.2.2, 17.5.0, 17.5.1

Opened: May 19, 2025

Severity: 3-Major

Symptoms

A database monitor (mssql, mysql, oracle, postgresql) may incorrectly mark a pool member as UP if the monitor is configured with a 'recv' string, but the query configured in the 'send' string does not return any results from the database server. In this case, the DB (database) monitor attempts to match the 'recv' string to the result set from the database server, and fails to mark an empty result set as a mismatch.

Impact

Pool members may be incorrectly marked UP.

Conditions

-- A DB (database) monitor (mssql, mysql, oracle, postgresql) is configured and applied to an LTM or GTM pool. -- The DB monitor has a 'send' string configured with a query that does not return any results from the database server. -- The DB monitor has a 'recv' string configured.

Workaround

In the DB monitor configuration, modify the query in the 'send' to return a result that does not match the 'recv' string.

Fix Information

None

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips