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

GAUSS-02161 -- GAUSS-02170

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.