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 2024-06-13 GMT+08:00

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.

For how to create a queue, see Creating an Elastic Resource Pool and Adding Queues to the Pool.