ERR-01044

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).

  SELECT name, value1 FROM v$property WHERE name LIKE '%TIMEOUT%';

• Modify the value.

  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.