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

GAUSS-02401 -- GAUSS-02410

GAUSS-02401: "cannot lock rows in view '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. The TOAST table cannot be locked.

Solution: Modify the SQL statement.

GAUSS-02402: "cannot lock rows in foreign table '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. The TOAST table cannot be locked.

Solution: Modify the SQL statement.

GAUSS-02403: "cannot lock rows in relation '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. The object cannot be locked.

Solution: Modify the SQL statement.

GAUSS-02404: "new row for relation '%s' violates check constraint '%s'"

SQLSTATE: 23514

Description: The new data conflicts with CHECK constraints.

Solution: Check for conflicts in CHECK constraints.

GAUSS-02405: "failed to find ExecRowMark for rangetable index %u"

SQLSTATE: XX000

Description: No ExecRowMark is found in Rangetable using the index.

Solution: Check the SQL statement and execution plan.

GAUSS-02406: "could not find junk %s column"

SQLSTATE: XX000

Description: The junk column cannot be found.

Solution: Check whether the SQL statement and execution plan are correct based on the column name.

GAUSS-02407: "t_xmin is uncommitted in tuple to be updated"

SQLSTATE: XX000

Description: The tuple xmin to be updated is not submitted.

Solution: Contact technical support.

GAUSS-02408: "abort transaction due to concurrent update"

SQLSTATE: 40001

Description: The transaction rolls back because concurrent updates of the same tuple are not allowed.

Solution: Do not perform concurrent updates to transactions.

GAUSS-02409: "EvalPlanQual doesn't support locking rowmarks"

SQLSTATE: XX000

Description: In READ COMMITED mode, the related table cannot be locked when the updated tuples are checked whether operations can be performed for them.

Solution: Contact technical support.

GAUSS-02410: "failed to fetch tuple for EvalPlanQual recheck"

SQLSTATE: 22P08

Description: The rule fails to be obtained when the updated tuple is rechecked.

Solution: Contact technical support.