What Should I Do If a Query Is Performed on the BE Node Where Some Copies Are Lost or Damaged and an Error Is Reported?

Symptom

If multiple copies were lost from the disk, for example, mv was renamed, the kernel could not detect the loss of the copies. If the query request runs on the BE node where the copies are lost, the following error is reported:

Procedure

1. Log in to the node where MySQL is installed and connect to the Doris database.
2. Call check_tablet_segment_lost of the BE node to request automatic recovery of lost copies.

   curl -X POST http://192.168.67.78:29986/api/check_tablet_segment_lost?repair=true (

   In the preceding command, 192.168.67.78 indicates the IP address of the abnormal BE node, and 29986 indicates the service port of the HTTP server of the BE node. You can search for webserver_port on the Doris configuration page of Manager to view the port.

   

3. Run the following command to obtain DetailCmd:

   show tablet tabletId

   

4. Run DetailCmd. If the copies of the abnormal node have been removed, run the query again.