On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02101 -- GAUSS-02200/ GAUSS-02161 -- GAUSS-02170

GAUSS-02161 -- GAUSS-02170

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

View PDF

GAUSS-02161: "PGXC Node %s: cannot drop local node"

SQLSTATE: 42601

Description: A syntax error occurs. The local node cannot be dropped.

Solution: Do not remove the local node.

GAUSS-02162: "coordinator cannot identify itself"

SQLSTATE: XX000

Description: An internal system error occurs. The pgxc_node system catalog may have been damaged or the user has modified the pgxc_node_name parameter of the failed node.

Solution: It is not recommended that users modify the pgxc_node_name parameter. If the fault is caused by incorrect parameter modification, perform the following operations: 1. Enable the CN in restore mode. Obtain the nodename by querying the pgxc_node system table. Restore the configuration parameter based on the nodename obtained. 2. Restore the configuration parameter using the standard log name of this instance generated in OM mode. "

GAUSS-02163: "invalid Datanode number: %d, NumDataNodes: %d"

SQLSTATE: XX000

Description: An internal system error occurs. The pgxc_node system catalog is damaged.

Solution: Manually restore the pgxc_node table. Alternatively, replace the node.

GAUSS-02164: "invalid coordinator number: %d, NumCoords: %d"

SQLSTATE: XX000

Description: An internal system error occurs. The pgxc_node system catalog is damaged.

Solution: Manually restore the pgxc_node table. Alternatively, replace the node.

GAUSS-02165: "failed to get pooled connections"

SQLSTATE: 53000

Description: Fails to request DN connections from the pooler manager thread.

Solution: Locate the root cause by viewing the pooler manager logs close to the error log. Perform restoration based on such logs.

GAUSS-02166: "invalid coordinator number: %d,NumCoords: %d"

SQLSTATE: XX000

Description: An internal system error occurs. The pgxc_node system catalog is damaged.

Solution: Manually restore the pgxc_node table. Alternatively, replace the node.

GAUSS-02167: "Can not connect to pool manager"

SQLSTATE: 58030

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02168: "failed to connect to pool manager: %m"

SQLSTATE: 08006

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02169: "Clean connections not completed"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02170: "Set command process failed"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

Parent topic: GAUSS-02101 -- GAUSS-02200

Previous topic: GAUSS-02151 -- GAUSS-02160

Next topic: GAUSS-02171 -- GAUSS-02180

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