Help Center/ Data Lake Insight/ FAQs/ Queue/ O&M Guide/ Why Is a Timeout Exception Reported When a DLI SQL Statement Fails to Be Executed on the Default Queue?
Updated on 2023-05-19 GMT+08:00
View PDF

Why Is a Timeout Exception Reported When a DLI SQL Statement Fails to Be Executed on the Default Queue?

Symptom

After a SQL job was submitted to the default queue, the job runs abnormally. The job log reported that the execution timed out. The exception logs are as follows: 
[ERROR] Execute DLI SQL failed. Please contact DLI service.
[ERROR] Error message:Execution Timeout

Possible Causes

The default queue is a public preset queue in the system for function trials. When multiple users submit jobs to this queue, traffic control might be triggered. As a result, the jobs fail to be submitted.

Solution

Buy a custom queue for your jobs. The procedure is as follows:

  1. In the navigation pane of the DLI management console, choose Queue Management.
  2. In the upper right corner of the Queue Management page, click Buy Queue to create a queue.
  3. On the Buy Queue page, set the required parameters as you need. Especially, set Type to For SQL.
  4. Submit your SQL jobs to the newly created queue.
Parent topic: O&M Guide