| Table of Contents |
|---|
Version
All versions
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
This error occurs when the query execution time exceeded QUERY_TIMEOUT.
QUERY_TIMEOUT is the maximum amount of time allowed for a query to complete its execution.
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 : 3600 seconds).
Code Block language sql SELECT name, value1 FROM v$property WHERE name LIKE '%TIMEOUT%';
- Modify the value.
Code Block language sql ALTER SYSTEM SET query_ timeout= desired value;
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.