MogDB
Ecological Tools
Doc Menu

GAUSS-02301 – GAUSS-02400


GAUSS-02301 – GAUSS-02310


GAUSS-02301: "frame starting offset must not be null"

SQLSTATE: 22004

Description: The start offset specified by the window frame clause is NULL.

Solution: Check the SQL statement to ensure that the start offset in the frame clause is not NULL.

GAUSS-02302: "frame starting offset must not be negative"

SQLSTATE: 22023

Description: The start offset specified by the window frame clause is negative.

Solution: Check the SQL statement to ensure that the start offset in the frame clause is not negative.

GAUSS-02303: "frame ending offset must not be null"

SQLSTATE: 22004

Description: The ending offset specified by the window frame clause is NULL.

Solution: Check the SQL statement to ensure that the ending offset in the frame clause is not NULL.

GAUSS-02304: "frame ending offset must not be negative"

SQLSTATE: 22023

Description: The ending offset specified by the window frame clause is negative.

Solution: Check the SQL statement to ensure that the ending offset in the frame clause is not negative.

GAUSS-02306: "WindowFunc with winref %u assigned to WindowAgg with winref %u"

SQLSTATE: 42804

Description: A plan error occurs. The sequence number of WindowFunc does not match that in WindowAgg.

Solution:Contact technical support.

GAUSS-02307: "aggregate %u needs to have compatible input type and transition type"

SQLSTATE: 42P13

Description: The type of the input parameter or the intermediate data is incompatible with the aggregate function.

Solution: Modify the type of the input parameter or intermediate data.

GAUSS-02308: "cannot fetch row before WindowObject's mark position"

SQLSTATE: 22P08

Description: Internal execution logic error.

Solution:Contact technical support.

GAUSS-02309: "cannot move WindowObject's mark position backward"

SQLSTATE: 0A000

Description: Internal execution logic error.

Solution:Contact technical support.

GAUSS-02310: "specified position is out of window: "

SQLSTATE: XX000

Description: Internal execution logic error.

Solution:Contact technical support.


GAUSS-02311 – GAUSS-02320


GAUSS-02312: "number of array dimensions (%d) exceeds the maximum allowed (%d)"

SQLSTATE: 54000

Description: The number of array dimensions exceeds the upper limit.

Solution: Ensure that the number of array dimensions is less than the upper limit displayed in the error information.

GAUSS-02313: "array subscript in assignment must not be null"

SQLSTATE: 22004

Description: The array subscript in the assignment statement cannot be NULL.

Solution: Use a proper array subscript.

GAUSS-02315: "no aggregates in this expression context"

SQLSTATE: 42P25

Description: Expressions do not contain any aggregate functions.

Solution: Check the AggRef expression in the SQL statement.

GAUSS-02316: "no window functions in this expression context"

SQLSTATE: 42P20

Description: Expressions do not contain any window functions.

Solution: Check the WindowFunc expression in the SQL statement.

GAUSS-02317: "attribute number %d exceeds number of columns %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02318: "attribute %d has wrong type"

SQLSTATE: 42P24

Description: The type does not match.

Solution: Check the SQL statement based on the reported error information.

GAUSS-02319: "table row type and query-specified row type do not match"

SQLSTATE: 42804

Description: Types of table rows do not match those defined in queries.

Solution: Modify types of table rows to match those defined in queries.


GAUSS-02321 – GAUSS-02330


GAUSS-02322: "attribute '%s' does not exist"

SQLSTATE: XX000

Description: The attribute column does not exist.

Solution: Check the SQL statement based on the column names.

GAUSS-02323: "set-return function not supported in vector eninge"

SQLSTATE: 0A000

Description: The feature is not supported.

Solution: Do not use this feature.

GAUSS-02324: "functions and operators can take at most one set argument"

SQLSTATE: 0A000

Description: The feature is not supported. Only a set value is allowed in function input parameters.

Solution: Use at most one set value for function input parameters.

GAUSS-02325: "function returning setof record called in context that cannot accept type record"

SQLSTATE: 0A000

Description: The feature is not supported. The function that returns a result set fails to receive a record type.

Solution: Do not use the record type for any functions that return result sets.

GAUSS-02326: "function return row and query-specified return row do not match"

SQLSTATE: 42804

Description: The number of tuple attributes returned by the function is inconsistent with that as expected.

Solution: Check whether the types and number of columns returned are consistent with those defined by the function.

GAUSS-02327: "table-function protocol for materialize mode was not followed"

SQLSTATE: 39P02

Description: Failed to use the function that returns a result set in the materialized mode.

Solution: Do not use the function that returns a result set in the materialized mode.

GAUSS-02328: "unrecognized table-function returnMode: %d"

SQLSTATE: 39P02

Description: Failed to recognize the return mode of the current table function.

Solution: Check whether the related code in the executor properly processes the return mode of the table function.

GAUSS-02329: "function returning set of rows cannot return null value"

SQLSTATE: 22004

Description: Dataset returned by the table function contains NULL.

Solution: Check whether NULL is properly filtered during expression processing.

GAUSS-02330: "rows returned by function are not all of the same row type"

SQLSTATE: 42804

Description: The tuple descriptors returned by the table function are not always the same.

Solution: Ensure the data consistency.


GAUSS-02331 – GAUSS-02340


GAUSS-02331: "IS DISTINCT FROM does not support set arguments"

SQLSTATE: 42804

Description: The IS DISTINCT FROM SQL statement does not support multiple parameters.

Solution: Check whether the SQL statement is properly used.

GAUSS-02333: "cannot merge incompatible arrays"

SQLSTATE: 42804

Description: Types of the two arrays are different.

Solution: Ensure that types of the two arrays in the SQL statement are same.

GAUSS-02334: "multidimensional arrays must have array expressions with matching dimensions"

SQLSTATE: 2202E

Description: Multi-dimensional arrays must be provided with dimension-matching expressions.

Solution: Check the input strings.

GAUSS-02335: "unrecognized RowCompareType: %d"

SQLSTATE: XX004

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02337: "NULLIF does not support set arguments"

SQLSTATE: 42804

Description: The NULLIF operator does not support returning parameters as a set.

Solution: Ensure that the parameters returned to the NULLIF function in the SQL statement are not a set.

GAUSS-02338: "domain %s does not allow null values"

SQLSTATE: 23502

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02339: "value for domain %s violates check constraint '%s'"

SQLSTATE: 23514

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02340: "unsupported reference to system column %d in FieldSelect"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-02341 – GAUSS-02350


GAUSS-02341: "CURRENT OF cannot be executed"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02342: "unrecognized paramkind: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02343: "Aggref found in non-Agg plan node"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02344: "WindowFunc found in non-WindowAgg plan node"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02345: "SubPlan found with no parent plan"

SQLSTATE: 42P27

Description: The AlternativeSubPlan expression does not have a parent node whose PlanState is empty.

Solution: Check whether the parent node is empty in the SQL statement or execution plan.

GAUSS-02346: "AlternativeSubPlan found with no parent plan"

SQLSTATE: 42P27

Description: The SubPlan expression does not have a parent node whose PlanState is empty.

Solution: Check whether the parent node is empty in the SQL statement or execution plan.

GAUSS-02347: "target type is not an array"

SQLSTATE: 22023

Description: Array is not the target type of an array-type conversion expression.

Solution: Ensure that array is the source and target types of an array-type conversion expression.

GAUSS-02348: "ROW() column has type %s instead of type %s"

SQLSTATE: 42804

Description: The row expression type does not match.

Solution: Check whether the type is modified by the alter column type operation.

GAUSS-02349: "could not identify a comparison function for type %s"

SQLSTATE: 42883

Description: Failed to define the type comparison functions in the MIN and MAX expressions.

Solution: Ensure that the MIN and MAX expressions are properly used.

GAUSS-02350: "CTE subplans should not be executed via ExecSubPlan"

SQLSTATE: XX000

Description: Generated plan error.

Solution:Contact technical support.


GAUSS-02351 – GAUSS-02360


GAUSS-02351: "cannot set parent params from subquery"

SQLSTATE: XX000

Description: Generated plan error.

Solution:Contact technical support.

GAUSS-02352: "hashed subplan with direct correlation not supported"

SQLSTATE: XX000

Description: The generated plan is incorrect. The hashed subplan does not support correlated subqueries.

Solution: Optimizer error. Contact technical support.

GAUSS-02353: "more than one row returned by a subquery used as an expression"

SQLSTATE: 21000

Description: A redundant row of data is returned by the subquery.

Solution: Check the subquery conditions to ensure that only one row of data is returned.

GAUSS-02354: "unrecognized testexpr type: %d"

SQLSTATE: XX000

Description: Failed to recognize the expression type.

Solution: Internal system error. Contact technical support.

GAUSS-02355: "ANY/ALL subselect unsupported as initplan"

SQLSTATE: XX000

Description: Failed to use the ANY or ALL as initplan in a subquery.

Solution: Check the query statement. Do not use ANY or ALL for non-correlated subqueries.

GAUSS-02356: "CTE subplans should not be executed via ExecSetParamPlan"

SQLSTATE: XX000

Description: The CTE cannot be used as the query for non-correlated subqueries.

Solution: Check the query statement. Do not use the CTE for non-correlated subqueries.

GAUSS-02357: "direct correlated subquery unsupported as initplan"

SQLSTATE: XX000

Description: Correlated subqueries cannot be used as InitPlans.

Solution: Internal system error. Contact technical support.

GAUSS-02358: "setParam list of initplan is empty"

SQLSTATE: XX000

Description: The parameter list of correlated subqueries is empty.

Solution: Internal system error. Contact technical support.

GAUSS-02359: "extParam set of initplan is empty"

SQLSTATE: XX000

Description: The parameter list of InitPlans is empty.

Solution: Internal system error. Contact technical support.

GAUSS-02360: "Unrecognized parttype as '%c' for relation '%s'"

SQLSTATE: XX000

Description: An incorrect partition type is detected and the internal protection mechanism is triggered.

Solution:Contact technical support.


GAUSS-02361 – GAUSS-02370


GAUSS-02361: "partition table delete conflict"

SQLSTATE: 40000

Description: The partitioned table is concurrently deleted.

Solution: Do not perform concurrent operations.

GAUSS-02362: "unrecognized heap_delete status: %u"

SQLSTATE: XX000

Description: The value returned after a tuple is deleted is not within the expected range. The tuple may be invisible.

Solution: Perform the delete operation again.

GAUSS-02363: "failed to fetch deleted tuple for DELETE RETURNING"

SQLSTATE: XX000

Description: Failed to obtain the deleted tuple using DELETE RETURNING.

Solution: Internal system error. Contact technical support.

GAUSS-02364: "cannot UPDATE during bootstrap"

SQLSTATE: XX000

Description: Failed to perform the update operation during initialization.

Solution: Internal system error. Contact technical support.

GAUSS-02365: "unrecognized heap_update status: %u"

SQLSTATE: XX000

Description: The value returned after a tuple is updated is not within the expected range. The tuple may be invisible.

Solution: Perform the delete operation again.

GAUSS-02366: "fail to update partitioned table '%s'"

SQLSTATE: XX000

Description:

  1. DISABLE ROW MOVEMENT is specified when the partitioned table is created.
  2. The data update exceeds the partition range.

Solution:

  1. Change DISABLE ROW MOVEMENT to ENABLE ROW MOVEMENT for the table. For example:

    ALTER TABLE table_name ENABLE ROW MOVEMENT
  2. Change the partition range.

GAUSS-02367: "partition table update conflict"

SQLSTATE: 40000

Description: Failed to concurrently update the partitioned table.

Solution: Specify DISABLE ROW MOVEMENT while creating the table.

GAUSS-02368: "unrecognized heap_update status: %u"

SQLSTATE: XX000

Description: The value returned after a tuple is updated is not within the expected range. The tuple may be invisible.

Solution: Perform the delete operation again.

GAUSS-02369: "unknown operation"

SQLSTATE: XX000

Description: Failed to recognize the operation type.

Solution: Internal system error. Contact technical support.

GAUSS-02370: "ModifyTable should not be called during EvalPlanQual"

SQLSTATE: XX000

Description: Internal system error.

Solution: Internal system error. Contact technical support.


GAUSS-02371 – GAUSS-02380


GAUSS-02372: "tableoid is null when update partitioned table"

SQLSTATE: XX000

Description: The obtained junk column is NULL.

Solution: Internal system error. Contact technical support.

GAUSS-02374: "could not find junk ctid column"

SQLSTATE: XX000

Description: Failed to find the junk column.

Solution: Internal system error. Contact technical support.

GAUSS-02375: "could not find junk tableoid column"

SQLSTATE: XX000

Description: Failed to find the junk column.

Solution: Internal system error. Contact technical support.

GAUSS-02376: "could not find junk wholerow column"

SQLSTATE: XX000

Description: Failed to find the junk column.

Solution: Internal system error. Contact technical support.

GAUSS-02377: "ExecReScanModifyTable is not implemented"

SQLSTATE: XX000

Description: Failed to implement the rescan function of MODIFY TABLE.

Solution: Plan error. Contact technical support.

GAUSS-02378: "expected valid OLD tuple for triggers"

SQLSTATE: XX000

Description: An internal trigger error occurs.

Solution: Internal system error. Contact technical support.

GAUSS-02380: "indexqual doesn't have key on left side"

SQLSTATE: XX002

Description: The left operand of the index expression is not a variable where an index has been created.

Solution: Check whether indexes have been created for related columns in the system catalog.


GAUSS-02381 – GAUSS-02390


GAUSS-02381: "bogus index qualification"

SQLSTATE: XX002

Description: The attribute number of the left operand for the index expression is greater than the number of attributes for which indexes have been created.

Solution: Check the system catalog and execution plan.

GAUSS-02384: "NullTest indexqual has wrong key"

SQLSTATE: XX002

Description: The left operand of the index expression is not a variable where an index has been created.

Solution: Check whether indexes have been created for related columns in the system catalog.

GAUSS-02387: "unrecognized operation code: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02388: "whole-row update is not implemented"

SQLSTATE: XX000

Description: Failed to update an entire column.

Solution: Check the SQL statement.

GAUSS-02390: "cannot change sequence '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. Failed to modify the sequence by using the INSERT, UPDATE, or DELETE statement.

Solution: Modify the SQL statement.


GAUSS-02391 – GAUSS-02400


GAUSS-02391: "cannot change TOAST relation '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. Failed to modify the TOAST table by using the INSERT, UPDATE, or DELETE statement.

Solution: Modify the SQL statement.

GAUSS-02392: "cannot insert into foreign table '%s'"

SQLSTATE: 0A000

Description: Failed to perform the insert operation for foreign tables.

Solution: Do not perform the insert operation for foreign tables.

GAUSS-02393: "foreign table '%s' does not allow inserts"

SQLSTATE: 55000

Description: Failed to perform the insert operation for foreign tables.

Solution: Do not perform the insert operation for foreign tables.

GAUSS-02394: "cannot update foreign table '%s'"

SQLSTATE: 0A000

Description: Failed to perform the update operation for foreign tables.

Solution: Do not perform the update operation for foreign tables.

GAUSS-02395: "foreign table '%s' does not allow updates"

SQLSTATE: 55000

Description: Failed to perform the update operation for foreign tables.

Solution: Do not perform the update operation for foreign tables.

GAUSS-02396: "cannot delete from foreign table '%s'"

SQLSTATE: 0A000

Description: Failed to perform the delete operation for foreign tables.

Solution: Do not perform the delete operation for foreign tables.

GAUSS-02397: "foreign table '%s' does not allow deletes"

SQLSTATE: 55000

Description: Failed to perform the delete operation for foreign tables.

Solution: Do not perform the delete operation for foreign tables.

GAUSS-02398: "cannot change relation '%s'"

SQLSTATE: 42809

Description: The object type is incorrect. Failed to modify the object type by using the INSERT, UPDATE, or DELETE statement.

Solution: Modify the SQL statement.

GAUSS-02399: "cannot lock rows in sequence '%s'"

SQLSTATE: 42809

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

Solution: Modify the SQL statement.

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

SQLSTATE: 42809

Description: The object type is incorrect. Failed to lock the TOAST table.

Solution: Modify the SQL statement.