On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00501 -- GAUSS-00600/ GAUSS-00561 -- GAUSS-00570

GAUSS-00561 -- GAUSS-00570

Updated on 2024-03-15 GMT+08:00

View PDF

GAUSS-00561: "views cannot be unlogged because they do not have storage"

SQLSTATE: 42601

Description: The view to be defined is set to UNLOGGED.

Solution: Do not set the view to be defined to UNLOGGED because it does not have actual storage.

GAUSS-00562: "unrecognized value for EXPLAIN option '%s': '%s'"

SQLSTATE: 22023

Description: The EXPLAIN FORMAT parameter cannot be recognized.

Solution: Ensure that the value of the EXPLAIN FORMAT parameter is TEXT, XML, JSON, or YAML.

GAUSS-00563: "unrecognized EXPLAIN option '%s'"

SQLSTATE: 42601

Description: The parameter of EXPLAIN cannot be recognized.

Solution: Ensure that the parameter of EXPLAIN is ANALYZE, VERBOSE, COSTS, BUFFERS, NODES, NUM_NODES, TIMING, CPU, DETAIL, PERFORMANCE, or FORMAT.

GAUSS-00564: "EXPLAIN option BUFFERS requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN BUFFERS.

Solution: Specify ANALYZE for EXPLAIN BUFFERS.

GAUSS-00565: "EXPLAIN option CPU requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN CPU.

Solution: Specify ANALYZE for EXPLAIN CPU.

GAUSS-00566: "EXPLAIN option DETAIL requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN DETAIL.

Solution: Specify ANALYZE for EXPLAIN DETAIL.

GAUSS-00567: "EXPLAIN option TIMING requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN TIMING.

Solution: Specify ANALYZE for EXPLAIN TIMING.

GAUSS-00568: "EXPLAIN %s requires ANALYZE"

SQLSTATE: 22023

Description: ANALYZE is not specified for EXPLAIN CREATE TABLE AS SELECT or EXPLAIN SELECT INTO.

Solution: Specify ANALYZE for EXPLAIN CREATE TABLE AS SELECT or EXPLAIN SELECT INTO.

GAUSS-00569: "no tlist entry for key %d"

SQLSTATE: XX000

Description: The generated plan is incorrect.

Solution: Contact technical support.

GAUSS-00570: "cache lookup failed for index %u"

SQLSTATE: XX000

Description: Indexes fail to be found in the system catalog cache.

Solution: Ensure that the index names are correct.

Parent topic: GAUSS-00501 -- GAUSS-00600

Previous topic: GAUSS-00551 -- GAUSS-00560

Next topic: GAUSS-00571 -- GAUSS-00580

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel