GAUSS-01121 -- GAUSS-01130

GAUSS-01121: "cannot swap toast files by content when there's only one"

SQLSTATE: XX000

Description: During scale-out, the physical files of two tables fail to be exchanged using the gs_switch_relfilenode function, because the toast table in one of the tables is empty.

Solution: Delete the current table, rebuild it using CREATE TABLE, and rebuild its physical file.

GAUSS-01122: "cannot swap toast files by links for system catalogs"

SQLSTATE: XX000

Description: During scale-out, when the physical files of two tables are exchanged using the gs_switch_relfilenode function, the toast physical files of system catalogs cannot be exchanged.

Solution: During scale-out, the toast physical files of system catalogs cannot be exchanged using the gs_switch_relfilenode function. Check whether the function parameters contain any system catalog names.

GAUSS-01123: "expected one dependency record for TOAST table, found %ld"

SQLSTATE: XX000

Description: During scale-out, the physical files of two tables fail to be exchanged using the gs_switch_relfilenode function, because more than one object depends on the toast table.

Solution: Check whether more than one object depends on the toast table in the pg_depend table. If they do, delete the dependent objects and then exchange the physical files using the gs_switch_relfilenode function.

GAUSS-01124: "expected none dependency record for partiton's TOAST table, found %ld"

SQLSTATE: XX000

Description: While the partition files of two tables are exchanged during partitioned table rebuilding, toast table files (if any) in the two tables are also exchanged. The partition files fail to be exchanged because the toast tables have dependent objects.

Solution: Rebuild the required partitioned table using CREATE TABLE PARTITION.

GAUSS-01125: "expected one dependency record for CUDesc/Delta table, found %ld"

SQLSTATE: XX000

Description: During scale-out, the physical files of two column-store tables fail to be exchanged using the gs_switch_relfilenode function, because more than one object depends on the column-store tables.

Solution: Check whether more than one object depends on the column-store tables in the pg_depend table. If they do, delete the dependent objects and then exchange the physical files using the gs_switch_relfilenode function.

GAUSS-01126: "expected none dependency record for partiton's CUDesc/Delta table, found %ld"

SQLSTATE: XX000

Description: While the partition files are exchanged during partitioned table rebuilding, the partitioned column-store table files (if any) are also exchanged. The partition files fail to be exchanged because the partitioned column-store tables have dependent objects.

Solution: Rebuild the required partitioned table using CREATE TABLE PARTITION.

GAUSS-01127: "invalid statement name: must not be empty"

SQLSTATE: 42P14

Description: The statement name is empty.

Solution: Specify the statement name.

GAUSS-01128: "could not determine data type of parameter $%d"

SQLSTATE: 42P18

Description: The data type of the parameter cannot be recognized.

Solution: Use a data type that can be recognized by the system. For details, see "Data Types" in the SQL Syntax.

GAUSS-01129: "utility statements cannot be prepared"

SQLSTATE: 42P14

Description: DDL statements cannot use prepare.

Solution: Run the DDL statements without using prepare.

GAUSS-01130: "EXECUTE does not support variable-result cached plans"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.