ALTER CLUSTER RESET ALERTER
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Statements for MariaDB Xpand
Topics on this page:
Overview
A description for this SQL Statement has not yet been added to this Documentation.
DETAILS
Any time that changes are made to the system.alerts_parameters or system.alerts_subscriptions table(s), the Alerter must be RESET. Your changes will not take effect until this is done.
To reset the Alerter:
ALTER CLUSTER RESET ALERTER;
This will not cause a group change on your deployment.
If invalid information is provided, you may encounter the following error:
ALTER CLUSTER RESET ALERTER;
ERROR 1 (HY000): [64512] Bad configuration for alerts:
Check clustrix.log for more information. Here is an example where the smtp_server parameter was not specified:
2018-10-11 21:07:51.068524 UTC karma068.example.com clxnode:
ERROR cluster/alerter.ct:219 prepare_write(): Couldn't write alerter
config: Bad configuration for alerts: No smtp_server specified