MogDB
Ecological Tools
Doc Menu

GAUSS-03701 – GAUSS-03800


GAUSS-03701 – GAUSS-03710


GAUSS-03701: "spg_redo: unknown op code %u"

SQLSTATE: XX000

Description: The redo operation type is incorrect.

Solution: A preventive error mechanism. Contact technical support.

GAUSS-03702: "inconsistent tuple chain links in page %u of index '%s'"

SQLSTATE: XX000

Description: The internal tuple chain list of the SPGiST index is incorrect.

Solution: A preventive error mechanism. Contact technical support.

GAUSS-03703: "unexpected SPGiST tuple state: %d"

SQLSTATE: XX000

Internal system error.

Solution:Contact technical support.

GAUSS-03704: "inconsistent counts of deletable tuples"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03705: "redirection leads to root page of index '%s'"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03706: "allTheSame should not occur for k-d trees"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03707: "spgmerge: unimplemented"

SQLSTATE: XX000

Description: Failed to perform the merge operation for SPGIN indexes because this function has not been implemented.

Solution:Contact technical support.

GAUSS-03708: "SPGiST does not support mark/restore"

SQLSTATE: XX000

Internal system error.

Solution:Contact technical support.

GAUSS-03709: "inconsistent inner_consistent results for allTheSame inner tuple"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03710: "SP-GiST only supports forward scan direction"

SQLSTATE: XX000

Internal system error.

Solution:Contact technical support.


GAUSS-03711 – GAUSS-03720


GAUSS-03711: "getQuadrant: impossible case"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03712: "failed to find requested node %d in SPGiST inner tuple"

SQLSTATE: XX000

Internal system error.

Solution:Contact technical support.

GAUSS-03715: "failed to divide leaf tuple groups across pages"

SQLSTATE: XX000

Description: Leaf nodes are stored on different pages.

Solution: A preventive error mechanism. Contact technical support.

GAUSS-03716: "cannot enlarge root tuple any more"

SQLSTATE: XX000

Description: The root tuple cannot be expanded.

Solution: A preventive error mechanism. Contact technical support.

GAUSS-03718: "SPGiST inner-tuple split must not produce longer prefix"

SQLSTATE: XX000

Internal system error.

Solution:Contact technical support.

GAUSS-03719: "SPGiST index page %u has wrong nulls flag"

SQLSTATE: XX000

Internal system error.

Solution:Contact technical support.

GAUSS-03720: "cannot add a node to an allTheSame inner tuple"

SQLSTATE: XX000

Description: A node cannot be added to identical internal tuples.

Solution: A preventive error mechanism. Contact technical support.


GAUSS-03721 – GAUSS-03730


GAUSS-03721: "cannot add a node to an inner tuple without node labels"

SQLSTATE: XX000

Description: When you add a node to an internal tuple, the node label cannot be empty.

Solution: A preventive error mechanism. Contact technical support.

GAUSS-03722: "unrecognized SPGiST choose result: %d"

SQLSTATE: XX000

Internal system error.

Solution:Contact technical support.

GAUSS-03723: "row is too big: size %lu, maximum size %lu"

SQLSTATE: 54000

Description: The length of a single tuple exceeds the specification, and the TOAST technology cannot be used for storage.

Solution: Split a large table with a large number of columns into multiple small tables before data storage. You can also change certain data types to string for storage. The 64-bit XID system changes the page specification. If an error occurs in the old table, you need to split the large table with a large number of columns into multiple small tables before data storage, or you can also change certain data types to string for storage.

GAUSS-03724: "failed to add tuple"

SQLSTATE: XX000

Description: Internal error. Failed to insert the tuple.

Solution: Try again.

GAUSS-03725: "wrong buffer passed to visibilitymap_clear"

SQLSTATE: XX000

Description: An internal error occurs. Failed to check the validity of the page and page number before the visibility table operation.

Solution: Try again.

GAUSS-03728: "found toasted toast chunk for toast value %u in %s"

SQLSTATE: XX014

Description: An internal exception occurs in the TOAST data storage.

Solution:Contact technical support.

GAUSS-03729: "unexpected chunk number %d (expected %d) for toast value %u in %s"

SQLSTATE: XX014

Description: An internal error occurs. The number of chunks in TOAST data storage is different from expected.

Solution:Contact technical support.

GAUSS-03730: "unexpected chunk size %d (expected %d) in chunk %d of %d for toast value %u in %s"

SQLSTATE: XX014

Description: An internal exception occurs in the TOAST data storage.

Solution:Contact technical support.


GAUSS-03731 – GAUSS-03740


GAUSS-03731: "unexpected chunk size %d (expected %d) in final chunk %d for toast value %u in %s"

SQLSTATE: XX014

Description: An internal exception occurs in the TOAST data storage.

Solution:Contact technical support.

GAUSS-03732: "unexpected chunk number %d (out of range %d..%d) for toast value %u in %s"

SQLSTATE: XX014

Description: An internal exception occurs in the TOAST data storage.

Solution:Contact technical support.

GAUSS-03733: "missing chunk number %d for toast value %u in %s"

SQLSTATE: XX014

Description: An internal exception occurs in the TOAST data storage.

Solution:Contact technical support.

GAUSS-03734: "unexpected chunk size %d (expected %d) in chunk %d of %d for toast value %u in %s when fetching slice"

SQLSTATE: XX014

Description: The chunk size of the TOAST table is different from expected.

Solution: Check the TOAST table.

GAUSS-03735: "unexpected chunk size %d (expected %d) in final chunk %d for toast value %u in %s when fetching slice"

SQLSTATE: XX014

Description: The chunk size of the TOAST table is different from expected.

Solution: Check the TOAST table.

GAUSS-03736: "could not open relation with OID %u"

SQLSTATE: XX000

Description: The relation OID is invalid.

Solution: Query the table name and OID in pg_class.

GAUSS-03737: "block number %u is out of range for relation '%s'"

SQLSTATE: XX000

Description: The block number exceeds the maximum block number in the table.

Solution: Check the file length of the table.

GAUSS-03738: "attempted to delete invisible tuple"

SQLSTATE: XX000

Description: The tuple to be deleted is invisible.

Solution: Check whether other operations are concurrently performed on the table.

GAUSS-03739: "tuple already updated by self"

SQLSTATE: XX000

Description: The tuple has been updated by the current transaction.

Solution:Contact technical support.

GAUSS-03740: "tuple concurrently updated"

SQLSTATE: XX000

Description: The tuple is concurrently updated or deleted.

Solution: Check whether other operations are concurrently performed on the table.


GAUSS-03741 – GAUSS-03750


GAUSS-03741: "attempted to update invisible tuple"

SQLSTATE: XX000

Description: The tuple to be updated is invisible.

Solution: Check whether other operations are concurrently performed on the table.

GAUSS-03742: "attempted to lock invisible tuple"

SQLSTATE: XX000

Description: The tuple to be locked is invisible.

Solution: Check whether other operations are concurrently performed on the table.

GAUSS-03743: "could not obtain lock on row in relation '%s'"

SQLSTATE: 55P03

Description: Failed to add a lock.

Solution: Check whether other operations are concurrently performed on the table.

GAUSS-03744: "heap_inplace_update: invalid lp"

SQLSTATE: XX000

Description: The tuple pointer of the update operation is invalid.

Solution:Contact technical support.

GAUSS-03745: "heap_inplace_update: wrong tuple length"

SQLSTATE: XX000

Description: The tuple length of the update operation is invalid.

Solution:Contact technical support.

GAUSS-03746: "heap_delete_redo: invalid lp"

SQLSTATE: XX000

Description: The tuple pointer during the redo delete operation is invalid.

Solution: Ensure that the .xlog file is correct.

GAUSS-03747: "heap_insert_redo: invalid max offset number"

SQLSTATE: XX000

Description: The page offset of the redo insert operation is invalid.

Solution: Ensure that the .xlog file is correct.

GAUSS-03748: "heap_insert_redo: failed to add tuple"

SQLSTATE: XX000

Description: Failed to add a tuple during the redo insert operation.

Solution: Ensure that the .xlog file is correct.

GAUSS-03749: "heap_multi_insert_redo: invalid max offset number"

SQLSTATE: XX000

Description: The page offset of the redo multi insert operation is invalid.

Solution: Ensure that the .xlog file is correct.

GAUSS-03750: "heap_multi_insert_redo: failed to add tuple"

SQLSTATE: XX000

Description: Failed to add a tuple during the redo multi insert operation.

Solution: Ensure that the .xlog file is correct.


GAUSS-03751 – GAUSS-03760


GAUSS-03751: "heap_update_redo: invalid lp"

SQLSTATE: XX000

Description: The tuple pointer during the redo update operation is invalid.

Solution: Ensure that the .xlog file is correct.

GAUSS-03752: "heap_update_redo: invalid max offset number"

SQLSTATE: XX000

Description: The page offset during the redo update tuple operation is invalid.

Solution: Ensure that the .xlog file is correct.

GAUSS-03753: "heap_update_redo: failed to add tuple"

SQLSTATE: XX000

Description: Failed to add a tuple during the redo update operation.

Solution: Ensure that the .xlog file is correct.

GAUSS-03754: "heap_lock_redo: invalid lp"

SQLSTATE: XX000

Description: The tuple pointer during the redo lock operation is invalid.

Solution: Ensure that the .xlog file is correct.

GAUSS-03755: "heap_inplace_redo: invalid lp"

SQLSTATE: XX000

Description: The tuple pointer during the redo inplace operation is invalid.

Solution: Ensure that the .xlog file is correct.

GAUSS-03756: "heap_inplace_redo: wrong tuple length"

SQLSTATE: XX000

Description: The tuple length during the redo inplace operation is invalid.

Solution: Ensure that the .xlog file is correct.

GAUSS-03759: "relation '%s' is not table or index"

SQLSTATE: XX000

Description: The relation of the operation is not a table or index.

Solution: Check whether the object of the SQL operation is a table or index.


GAUSS-03761 – GAUSS-03770


GAUSS-03761: "openning partition %u, but relation %s %u is neither table nor index"

SQLSTATE: XX000

Description: The partition of the operation is not a table or an index.

Solution: Check whether the object of the SQL operation is a table or index.

GAUSS-03762: "closing partition %u, but relation %u is neither table nor index"

SQLSTATE: 2200X

Description: The closed partition is not a table or an index.

Solution: Check whether the object of the SQL operation is a table or index.

GAUSS-03763: "failed to add tuple to page"

SQLSTATE: XX000

Description: Failed to add a tuple to the page.

Solution:Contact technical support.

GAUSS-03764: "page %u of relation '%s' should be empty but is not"

SQLSTATE: XX000

Description: The page must be empty.

Solution:Contact technical support.

GAUSS-03765: "tuple is too big: size %lu"

SQLSTATE: XX000

Description: The tuple length is greater than the free space on the page.

Solution:Contact technical support.

GAUSS-03767: "This query is not supported by optimizer in CStore"

SQLSTATE: XX000

Description: The column-store query is run on the CN.

Solution: Check whether the column-store table is queried on the CN.


GAUSS-03771 – GAUSS-03780


GAUSS-03771: "could not write cache file '%s': %m"

SQLSTATE: XX000

Description: Failed to write data to the cache file when data is inserted to a column-store partitioned table.

Solution: Rectify the fault based on the error information about writing files.

GAUSS-03772: "could not read cache file '%s': %m"

SQLSTATE: XX000

Description: Failed to read data from the cache file when data is inserted to a column-store partitioned table.

Solution: Rectify the fault based on the error information about reading files.

GAUSS-03774: "Column store don't support"

SQLSTATE: XX000

Description: Column-store tables do not support querying the system column.

Solution: Delete unsupported system columns.

GAUSS-03775: "unsupported datatype branch"

SQLSTATE: XX000

Description: Column-store tables do not support querying the data type.

Solution: Check the data type.

GAUSS-03777: "Non-deterministic UPDATE"

SQLSTATE: 21000

Description: The update is non-deterministic.

Solution: Ensure that no row is updated multiple times.

GAUSS-03778: "These rows have been deleted or updated"

SQLSTATE: 21000

Description: Data is deleted or updated multiple times.

Solution: Ensure that no row is deleted or updated multiple times.


GAUSS-03781 – GAUSS-03790


GAUSS-03781: "CStore: unrecognized heap_update status: %u"

SQLSTATE: XX000

Description: Failed to recognize the tuple update status of the CUDesc table.

Solution:Contact technical support.

GAUSS-03785: "WITH query name '%s' appears in both a rule action and the query being rewritten"

SQLSTATE: 0A000

Description: The name of the WITH statement appears in both the rule action and the rewriting statement.

Solution: Use different names of the WITH statement for the rule action and the rewriting statement.

GAUSS-03786: "cannot have RETURNING lists in multiple rules"

SQLSTATE: 0A000

Description: Multiple rules have RETURNING lists.

Solution: Modify the rule syntax and eliminate inappropriate lists.

GAUSS-03787: "bogus resno %d in targetlist"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03788: "multiple assignments to same column '%s'"

SQLSTATE: 42601

Description: Multiple value assignments to the same column occur (if FieldStore or ArrayRef assigns the value, this is not an error).

Solution: Modify the UPDATE statement syntax to avoid multiple value assignments to the same column.

GAUSS-03789: "cannot happen"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03790: "expected just one rule action"

SQLSTATE: XX000

Description: The rule has more than one action.

Solution: Correct the corresponding primary foreign key constraint.


GAUSS-03791 – GAUSS-03800


GAUSS-03792: "cannot handle per-attribute ON SELECT rule"

SQLSTATE: XX000

Description: The rule action must be a table-level action.

Solution: Correct the corresponding primary foreign key constraint.

GAUSS-03793: "unrecognized commandType: %d"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03794: "infinite recursion detected in rules for relation '%s'"

SQLSTATE: 42P17

Description: Infinite recursion is detected in rules.

Solution: Check the usage of rules.

GAUSS-03795: "DO INSTEAD NOTHING rules are not supported for data-modifying statements in WITH"

SQLSTATE: 0A000

Description: The data-modifying statements do not support the DO INSTEAD NOTHING rules.

Solution: Check the usage of rules.

GAUSS-03796: "conditional DO INSTEAD rules are not supported for data-modifying statements in WITH"

SQLSTATE: 0A000

Description: The data-modifying statements do not support the conditional DO INSTEAD NO rules.

Solution: Check the usage of rules.

GAUSS-03797: "DO ALSO rules are not supported for data-modifying statements in WITH"

SQLSTATE: 0A000

Description: The data-modifying statements do not support the DO ALSO rules.

Solution: Check the usage of rules.

GAUSS-03799: "cannot perform INSERT RETURNING on relation '%s'"

SQLSTATE: 0A000

Description: An error occurs when the insert returning operation is performed on a table because the INSTEAD rule contains RETURNING but the original statement does not.

Solution: Use the unconditional ON INSERT DO INSTEAD rule that contains the RETURNING clause.

GAUSS-03800: "cannot perform UPDATE RETURNING on relation '%s'"

SQLSTATE: 0A000

Description: An error occurs when the update returning operation is performed on a table because the INSTEAD rule contains RETURNING but the original statement does not.

Solution: Use the unconditional ON UPDATE DO INSTEAD rule that contains the RETURNING clause.