Last Modified: Nov 22, 2021
Known Affected Versions:
Opened: Aug 13, 2014 Severity: 3-Major Related Article:
Related Article: K57250454
SQL (MSSQL, MySQL, Oracle, Postgres) monitors may occasionally hang for unknown reasons.
MSSQL, MySQL, Oracle, Postgres monitors may occasionally hang.
This occurs when using MSSQL, MySQL, Oracle, and Postgres monitors.
Many small minor fixes have been made which mitigate the situations where the problem has been reproducible. In addition, two debugging aids have been added: 1. Logging has been significantly enhanced. 2. A new command has been added to help diagnose the state of the SQL monitors: /usr/share/monitors/DB_monitor cmd status [RD] [debug] RD: optional, the route domain for the desired Java daemon (each route domain gets a separate daemon). debug: optional, do debug logging. Examples: -- /usr/share/monitors/DB_monitor cmd status. -- /usr/share/monitors/DB_monitor cmd status 0. -- /usr/share/monitors/DB_monitor cmd status 17. -- /usr/share/monitors/DB_monitor cmd status 9 debug.
Addition of "cmd status" debugging command.