Bug ID 803629: SQL monitor fails with 'Analyze Response failure' message even if recv string is correct

Last Modified: Sep 13, 2023

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

Known Affected Versions:
11.6.0, 11.6.1, 11.6.2, 11.6.3,,,,, 11.6.4, 11.6.5,,,, 12.0.0, 12.0.0 HF1, 12.1.0 HF1, 12.0.0 HF2, 12.1.0 HF2, 12.0.0 HF3, 12.0.0 HF4, 12.1.1 HF1, 12.1.1 HF2, 12.1.2 HF1, 12.1.2 HF2, 12.1.0, 12.1.1, 12.1.2, 12.1.3,,,,,,,, 12.1.4,, 12.1.5,,,, 12.1.6, 13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1, 13.1.0,,,,,,,,, 13.1.1,,,,, 13.1.3,,,,,,, 13.1.4,, 14.0.0,,,,,, 14.0.1,, 14.1.0,,,,,, 14.1.2,,,,,,,,, 14.1.3,, 14.1.4,,,,, 15.0.0, 15.0.1,,,,, 15.1.0,,,,,, 15.1.1, 15.1.2,, 15.1.3,, 15.1.4

Fixed In:
16.1.0,,,, 13.1.5

Opened: Jul 10, 2019

Severity: 3-Major


For a database (mssql, mysql, postgresql or oracle) monitor type, with a 'recv' string configured, a pool member configured to use the DB monitor may be marked down even if the server is working and includes the configured response string among the response data. Debug logging of the SQL monitor indicates the following: ... [DBPinger-3778] - Response from server: Database: 'db1'Database: 'information_schema' ... [DBPinger-3778] - Checking for recv string: information_schema ... [DBPinger-3778] - Analyze Response failure The log shows 'Analyze Response failure' error message even when the configured 'recv' string appears within the response message from the DB server.


The DB monitor fails, and the DB server (node) is marked as down even though it is reachable and responding correctly per the configured 'recv' string.


This occurs when the string matching the configured 'recv' string value does not appear in the response from the DB server in the row indicated by the 'recv-row' value configured for the monitor. The default value of 'none' for the 'recv-row' monitor configuration value is actually interpreted as 'row 1' by the DB monitor core implementation. Therefore, with the default configuration, any 'recv' string configured must appear in the first row of the DB server response in order to be recognized as a match.


You may use one of the following methods to work around this issue: 1. Configure the DB monitor's 'recv' string to match on the first row in the server response message. 2. Configure the 'recv-row' value in the DB monitor to match the row of the DB server's response which contains the configured 'recv' string. 3. Do not configure 'send' or 'recv' string for the DB monitor.

Fix Information


Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips