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

GAUSS-02141 -- GAUSS-02150

GAUSS-02141: "port1 value is out of range"

SQLSTATE: 22003

Description: The specified port1 value is out of range.

Solution: Adjust the port value in the SQL statement.

GAUSS-02142: "sctp_port1 value is out of range"

SQLSTATE: 22003

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02143: "control_port1 value is out of range"

SQLSTATE: 22003

Description: Internal system error.

Solution: Contact technical support.

GAUSS-02144: "type value is incorrect, specify 'coordinator or 'datanode'"

SQLSTATE: 22023

Description: The specified type is incorrect. The specified type must be either the coordinator type or datanode type.

Solution: Modify the SQL statement.

GAUSS-02145: "incorrect option: %s"

SQLSTATE: 42601

Description: The specified option is incorrect.

Solution: Modify the SQL statement.

GAUSS-02146: "PGXC node %s: cannot be a primary node, it has to be a Datanode"

SQLSTATE: 42601

Description: The coordinator (CN) cannot be specified as the primary node by executing the create node or alter node statement.

Solution: Do not perform the operation.

GAUSS-02147: "PGXC node %s: cannot be a preferred node, it has to be a Datanode"

SQLSTATE: 42601

Description: The preferred node must be a DN, not a CN.

Solution: Do not perform the operation.

GAUSS-02148: "PGXC node %s: Node type not specified"

SQLSTATE: 42601

Description: A syntax error occurs. with option of the create node statement does not contain a type field.

Solution: Modify the statement to be executed.

GAUSS-02149: "Please choose different node name."

SQLSTATE: 42P17

Description: The unique node ID for the node name specified by the create node statement cannot be generated in hash mode.

Solution: Modify the specified node name.

GAUSS-02150: "must be system admin to create cluster nodes"

SQLSTATE: 42501

Description: The current user does not have sufficient rights. Only the system administrator has the rights to execute the create node statement.

Solution: Execute the statement as a system administrator.