Skip to content

ERR-01044 Client's query exceeded the execution time limit#

Version#

7.1.0 or later

Explanation#

The query abnormally terminates.

Cause#

QUERY_TIMEOUT specifies the maximum amount of time allowed for a query to complete its execution.

This property prevents long-running queries from causing server load.

This error message is output when a query was executed for a longer time than the value specified for QUERY_TIMEOUT.

Information of the query is output to altibase_boot.log.

Action#

The best way to fix this error is to reduce the overall execution time by tuning the query (e.g., adding an index).

A quick workaround would be to increase QUERY_TIMEOUT to avoid the error.

  • Check the QUERY_TIMEOUT property value (default: 600 seconds).

    SELECT name, value1 FROM v$property WHERE name LIKE '%TIMEOUT%';
    
  • Modify the value.

    ALTER SYSTEM SET query_timeout = 1200;
    

Reference#

This error message can be attributed to various causes: high service traffic load or suddenly changed query plans can incur prolonged query execution time.

This error should be fixed by tuning queries.