Bug ID 853101: ERROR: syntax error at or near 'FROM' at character 17

Last Modified: Sep 13, 2023

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

Known Affected Versions:
15.0.0, 15.0.1, 15.0.1.1, 15.0.1.2, 15.0.1.3, 15.0.1.4, 15.1.0, 15.1.0.1, 15.1.0.2, 15.1.0.3, 15.1.0.4, 15.1.0.5, 15.1.1, 15.1.2

Fixed In:
16.0.0, 15.1.2.1

Opened: Nov 26, 2019

Severity: 4-Minor

Symptoms

After clicking UI Security :: Network Firewall : Active Rules, /var/log/ltm reports the following error message: --warning postgres ERROR: syntax error at or near 'FROM' at character 17.

Impact

-- Possible leak of postgres database connections. -- A warning log message is created, but the system continues to function normally.

Conditions

Enabled turboflex-security and AFM module.

Workaround

None.

Fix Information

Correct is AFMProvisioned check was added to wrap database connection deallocation

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips