What Can I Do If the Disk Status Is Abnormal in the System.disks Table?

Question

How do I do if the disk status displayed in the System.disks table is fault or abnormal?

Answer

This problem is caused by I/O errors on the disk. To rectify the fault, perform the following steps:

Method 1:

1. Log in to FusionInsight Manager.

   For details, see Accessing FusionInsight Manager.

2. Choose O&M > Alarm, and check whether an alarm is generated indicating that the disk I/O is abnormal. If yes, replace the faulty disk by referring to the alarm help.

Method 2:

1. Log in to FusionInsight Manager.
2. Choose Cluster > Services > ClickHouse. On the displayed page, click Instances, select the abnormal instances, and choose More > Restart Instance or Instance Rolling Restart to restart the ClickHouse instance and restore the disk status.
   

   If an I/O error occurs but the disk is not replaced, the disk status will still turn to fault or abnormal.