What Should I Do If the Error Message "Failed to create partition [xxx] . Timeout" Is Displayed When I Create a Doris Data Table?

Symptom

The error message "Failed to create partition [xxx] . Timeout" is displayed during Doris data table creation.

Solution

Doris tables are created in sequence based on the partition granularity. This error message may appear when a partition creation task fails, but it could also appear in table creation tasks with no partitioning operations, because, as mentioned earlier, Doris will create an unmodifiable default partition for tables with no partitions specified.

This error usually pops up when the data fragment creation goes wrong in the BE nodes. You can follow the steps below for troubleshooting:

• In fe.log, search for the Failed to create partition log at the corresponding time point. The log file contains a series of number pairs that look like {10001-10010}. The first number of the pair is the Backend ID and the second number is the Tablet ID. As for {10001-10010}, it means that on Backend whose ID is 10001, the creation of Tablet whose ID is 10010 failed.
• Find the be.INFO log of the corresponding backend and search for the tablet ID-related records in the corresponding time period. The error information can be found.
• Common tablet creation failures include:
  • If the BE does not receive the creation task, no tablet ID-related records can be found in the be.INFO log or the table is successfully created on the BE but reported as failed.
  • Pre-allocated memory failure. The byte length of a row in the table may exceed 100 KB.
  • Too many open files. The number of opened file handles exceeds the Linux system limit. You need to modify the number of handles allowed by the Linux system.

  If the data fragment creation times out, you can also extend the timeout interval by setting tablet_create_timeout_second=xxx and max_create_table_timeout_second=xxx in fe.conf. The default value of tablet_create_timeout_second is 1 second, and that of max_create_table_timeout_second is 60 seconds. The overall timeout would be min(tablet_create_timeout_second * replication_num, max_create_table_timeout_second).