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:
- Log in to FusionInsight Manager.
- 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:
- Log in to FusionInsight Manager.
- 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.