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.