Environment
Vertica Analytics Platform 24.4
Situation
Vertica 24.4 has introduced Health Watchdog. User wants to know more details about Health Watchdog.
Resolution
If the database is under a high concurrent load, it leads to a bad health state on the server. The Health Watchdog is designed to mitigate the bad health state by doing the following:
-
Detecting the bad health state.
-
Stopping the transactions from adding to this bad state by blocking DDL/DML transactions.
-
Once the bad health state has been mitigated, allowing all blocked transactions to proceed.