ALM-45429 Table Metadata Synchronization Failed on the Added ClickHouse Node¶
Note
This section applies only to MRS 3.1.2-LTS.6 or later.
Description¶
This alarm is generated when the local table corresponding to the distributed table fails to be created during ClickHouse capacity expansion.
Attribute¶
Alarm ID | Alarm Severity | Auto Clear |
|---|---|---|
45429 | Major | No |
Parameters¶
Name | Meaning |
|---|---|
Source | Specifies the cluster for which the alarm is generated. |
ServiceName | Specifies the service for which the alarm is generated. |
RoleName | Specifies the role for which the alarm is generated. |
HostName | Specifies the host for which the alarm is generated. |
Impact on the System¶
The distributed table fails to be queried.
Possible Causes¶
A node is stopped or faulty during capacity expansion.
Procedure¶
On FusionInsight Manager, choose Cluster > Services > ClickHouse > Instance.
Check whether an instance is stopped, decommissioned, or faulty.
Start the instance or rectify the instance fault until all instances are running properly.
On FusionInsight Manager, choose O&M > Alarm > Alarms, locate this alarm and the faulty host based on the location information.
Log in to the faulty host as user omm.
Run the following commands to initialize environment variables:
source Cluster installation directory/FusionInsight_ClickHouse_*/*_*_ClickHouseServer/etc/ENV_VARS
source Cluster installation directory/FusionInsight_ClickHouse_*/*_*_ClickHouseServer/etc/clickhouse-env.sh
export CLICKHOUSE_CONF_DIR=${CLICKHOUSE_CONF_DIR}
Run the following command to run the metadata synchronization tool to synchronize metadata from the existing node to the faulty node:
sh Cluster installation directory/FusionInsight_ClickHouse_*/install/FusionInsight-ClickHouse-*/clickhouse/sbin/clickhouse-create-meta.sh true
Run the following command to view the log information and check whether the metadata has been synchronized:
vim /var/log/Bigdata/clickhouse/clickhouseServer/start.log
On FusionInsight Manager, choose O&M > Alarm > Alarms. In the Alarm ID column, locate the corresponding alarm and click Clear in the Operation column. In the displayed dialog box, click OK to manually clear the alarm.
Collect the fault information.
On FusionInsight Manager, choose O&M. In the navigation pane on the left, choose Log > Download.
Expand the Service drop-down list, select ClickHouse for the target cluster, and click OK.
Choose the corresponding host form the host list.
Click
in the upper right corner, and set Start Date and End Date for log collection to 30 minutes ahead of and after the alarm generation time respectively. Then, click Download.Contact O&M personnel and provide the collected logs.
Alarm Clearing¶
This alarm needs to be manually cleared after the fault is rectified.