Updated on 2023-12-22 GMT+08:00

OE000

GAUSS-OE000: "Object no longer exists."

SQLSTATE: OE000

Description: The query statement in execution is canceled, and ddl_select_concurrent_mode is enabled. When the SELECT statement blocks subsequent DDL statements, the DDL statements are executed first and the SELECT statement is interrupted.

Solution:

  1. Run the query statement again.
  2. Disable the GUC parameter ddl_select_concurrent_mode. When ddl_select_concurrent_mode is disabled, DDL statements are blocked by the SELECT statement. As a result, other DML statements are also blocked and the system is suspended. When this problem occurs, run the query statement again.