Vertica 24.4 has introduced Health Watchdog
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.
