Last Modified: Nov 07, 2023
BIG-IP DNS, GTM, LTM
Known Affected Versions:
220.127.116.11, 18.104.22.168, 17.1.0, 22.214.171.124, 126.96.36.199, 188.8.131.52
Opened: Jul 28, 2022 Severity: 1-Blocking
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.
The database monitor marks the pool member down, even in cases where the pool member is actually pingable.
-- 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.
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).
Database monitor no longer marks pool member down if 'send' is configured but no 'receive' strings are configured.