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

GAUSS-04411 -- GAUSS-04420

GAUSS-04411: "Multi-column combined informational constraint is forbidden."

SQLSTATE: 0A000

Description: Multi-column combined informational constraint is forbidden.

Solution: Create an information constraint on a column.

GAUSS-04412: "unrecognized node type %d"

SQLSTATE: XX000

Description: The operation type cannot be recognized.

Solution: Change the node type.

GAUSS-04414: "The number of %s distribute key can not exceed 1"

SQLSTATE: 42601

Description: A non-hash table cannot have multiple distribution columns.

Solution: Modify the table creation statement and specify one column as the distribution column.

GAUSS-04415: "Compatibility args %s is invalid\n"

SQLSTATE: 22023

Description: The specified compatibility line parameter is incorrect.

Solution: Set the parameter to ORA or TD.

GAUSS-04416: "GROUP BY position is not supported in multiple-column update clause"

SQLSTATE: 42601

Description: GROUP BY + digits cannot be used in a statement used for updating multiple columns.

Solution: Use GROUP BY + column name in statements for updating multiple columns.

GAUSS-04417: "Alias '%s' reference with window function included is not supported."

SQLSTATE: 42703

Description: During alias reference, the referenced expression cannot contain window functions.

Solution: Modify the SQL statement.

GAUSS-04418: "Alias '%s' reference with volatile function included is not supported."

SQLSTATE: 42703

Description: During alias reference, the referenced expression cannot contain volatile functions.

Solution: Modify the SQL statement.

GAUSS-04419: "Alias '%s' is ambiguous."

SQLSTATE: 42703

Description: The alias has been used.

Solution: Change the alias.

GAUSS-04420: "Secondary standby xlog's crc is different from standby's"

SQLSTATE: XX000

Description: Xlog files exist on the secondary server, but the CRC is different from that of the standby server log.

Solution: Restore the original primary server. If it cannot be restored and the standby server needs to forcibly take over services from the original primary server. Delete Xlog files on the secondary server, and perform failover for the standby server.