What Should I Do If "Failed to find enough host with storage medium and tag" Occasionally Occurs During Table Creation Due to the Configuration of the SSD and HDD Data Directories?

Symptom

Error message "Failed to find enough host with storage medium and tag" was occasionally displayed during table creation.

Cause Analysis

Doris allows you to configure multiple storage paths for a BE node and specify the storage medium of the paths, such as SSDs or HDDs. Generally, only one storage path needs to be configured for each disk.

The default_storage_medium parameter of FE nodes is HDD by default. If only the SSD is specified in the be.conf file, an error is reported because no HDD medium is available during table creation. Doris does not automatically detect the actual storage medium of disks where the storage path is located. You need to explicitly indicate the storage medium in the path configuration. .HDD and .SSD are used only to identify the speed of the storage paths. They are not the actual storage medium types. If the storage medium of the BE node has no difference, you do not need to enter the suffix.

Procedure

• Change the value of default_storage_medium of the FE node to the correct storage medium and restart the FE node for the modification to take effect.
• Delete the explicit SSD configuration from the be.conf file.
• Add the properties parameter properties {"storage_medium" = "ssd"} when creating a table.