MogDB
Ecological Tools
Doc Menu

GAUSS-01301 – GAUSS-01400


GAUSS-01301 – GAUSS-01310


GAUSS-01301: "access method '%s' does not support NULLS FIRST/LAST options"

SQLSTATE: 0A000

Description: The NULLS, FIRST, or LAST option cannot be used for index processing.

Solution: Rebuild the index and set the access method (amcanorder in pg_am) of the index column to true.

GAUSS-01302: "operator class '%s' does not exist for access method '%s'"

SQLSTATE: 42704

Description: The operator cannot be used for index processing.

Solution: Ensure that the operator is supported for index processing.

GAUSS-01303: "there are multiple default operator classes for data type %s"

SQLSTATE: 42710

Description: The default operator classes of data types are excessive.

Solution: The operator definition in the pg_opclass system catalog is incorrect. Contact technical support.

GAUSS-01304: "'%s' does not mean oid '%u'"

SQLSTATE: XX000

Description: The obtained OID of the partitioned table is incorrect.

Solution: Rebuild the index using ALTER INDEX…REBUILD.

GAUSS-01305: "'%u' is not a child of '%u'"

SQLSTATE: XX000

Description: The child partition is not in the partitioned table.

Solution: Rebuild the index using ALTER INDEX…REBUILD.

GAUSS-01308: "fail to get index info for index %u"

SQLSTATE: XX000

Description: The index information about the partitioned table cannot be obtained.

Solution: Failed to query the index table (index information of the pg_index system catalog) of the partitioned table in the cache. The cache is abnormal. Contact technical support.

GAUSS-01309: "unable to find attribute %d for relation %u."

SQLSTATE: XX000

Description: The attribute information about the table cannot be found.

Solution: Failed to find the attribute column of the partitioned index table in the cache. The cache is abnormal. Contact technical support.

GAUSS-01310: "cache %d lookup failed for relation %u"

SQLSTATE: XX000

Description: Failed to find the index table in the pg_class table.

Solution: The index table corresponding to the pg_class system catalog in the cache is abnormal. Contact technical support.


GAUSS-01311 – GAUSS-01320


GAUSS-01311: "collation attribute '%s' not recognized"

SQLSTATE: 42601

Description: The Create Collation syntax is used.

Solution: Do not use the syntax.

GAUSS-01314: "collation '%s' for encoding '%s' already exists in schema '%s'"

SQLSTATE: 42710

Description: The sorting rule for a character set exists.

Solution: Do not create duplicate sorting rules for a character set.

GAUSS-01315: "collation '%s' already exists in schema '%s'"

SQLSTATE: 42710

Description: The sorting rule exists in the schema.

Solution: Do not create duplicate sorting rules in a schema.

GAUSS-01316: "unlogged sequences are not supported"

SQLSTATE: 0A000

Description: Unlogged sequences cannot be created.

Solution: Do not create unlogged sequences.

GAUSS-01317: "GTM error, could not create sequence"

SQLSTATE: 08006

Description: A GTM error occurs, resulting in a failure in creating a sequence.

Solution: Run gs_om -t status –detail to check GTM status. If the GTM is abnormal, troubleshoot it as described in the Troubleshooting Guide and create a sequence again.

GAUSS-01318: "GTM error, could not alter sequence"

SQLSTATE: 08006

Description: A GTM error occurs, resulting in a failure in modifying a sequence.

Solution: Run gs_om -t status –detail to check GTM status. If the GTM is abnormal, troubleshoot it as described in the Troubleshooting Guide and create a sequence again.

GAUSS-01319: "permission denied for sequence %s"

SQLSTATE: 42501

Description: You do not have permission to access the sequence.

Solution: Ensure that you have permission to access the sequence.

GAUSS-01320: "nextval: reached maximum value of sequence '%s' (%s)"

SQLSTATE: 55000

Description: The maximum sequence value is reached.

Solution: Internal system error. Contact technical support.


GAUSS-01321 – GAUSS-01330


GAUSS-01321: "nextval: reached minimum value of sequence '%s' (%s)"

SQLSTATE: 55000

Description: The minimum sequence value is reached.

Solution: Internal system error. Contact technical support.

GAUSS-01323: "lastval is not yet defined in this session"

SQLSTATE: 55000

Description: The LASTVAL of the sequence is not defined in this session.

Solution: Ensure that the LASTVAL of the sequence is defined in this session.

GAUSS-01324: "setval: value %s is out of bounds for sequence '%s' (%s..%s)"

SQLSTATE: 22003

Description: The configured sequence value is out of the valid range.

Solution: Ensure that the configured sequence value is within the range.

GAUSS-01325: "GTM error, could not obtain sequence value"

SQLSTATE: 08006

Description: A GTM error occurs, resulting in a failure in obtaining the sequence value.

Solution: Run gs_om -t status –detail to check GTM status. If the GTM is abnormal, troubleshoot it as described in the Troubleshooting Guide and create a sequence again.

GAUSS-01326: "bad magic number in sequence '%s': %08X"

SQLSTATE: XX000

Description: Internal system error. The magic number in the opened sequence table is different from expected.

Solution: The sequence table may be abnormal. Contact technical support.

GAUSS-01327: "INCREMENT must not be zero"

SQLSTATE: 22023

Description: Ensure that the increment in the sequence is not 0.

Solution: The increment in the sequence cannot be 0.

GAUSS-01328: "MINVALUE (%s) must be less than MAXVALUE (%s)"

SQLSTATE: 22023

Description: The minimum sequence value must be less than the maximum value.

Solution: Ensure that the minimum sequence value is less than the maximum value.

GAUSS-01329: "START value (%s) cannot be less than MINVALUE (%s)"

SQLSTATE: 22023

Description: The minimum sequence value must be less than the maximum value.

Solution: Ensure that the initial sequence value is greater than or equal to the minimum value.

GAUSS-01330: "START value (%s) cannot be greater than MAXVALUE (%s)"

SQLSTATE: 22023

Description: The initial sequence value cannot be greater than the maximum value.

Solution: Ensure that the initial sequence value is less than the maximum value.


GAUSS-01331 – GAUSS-01340


GAUSS-01331: "RESTART value (%s) cannot be less than MINVALUE (%s)"

SQLSTATE: 22023

Description: In the RESTART clause, the value of RESTART is less than the minimum value.

Solution: Change the RESTART clause to ensure that the value of RESTART is greater than or equal to the minimum value.

GAUSS-01332: "RESTART value (%s) cannot be greater than MAXVALUE (%s)"

SQLSTATE: 22023

Description: In the RESTART clause, the value of RESTART is greater than the maximum value.

Solution: Change the RESTART clause to ensure that the value of RESTART is equal to or less than the maximum value.

GAUSS-01334: "invalid OWNED BY option"

SQLSTATE: 42601

Description: The specified value in the OWNED BY clause is not none.

Solution: Change the OWNED BY clause to ensure that the specified value is none.

GAUSS-01335: "sequence must have same owner as table it is linked to"

SQLSTATE: 55000

Description: The sequence and its associated table do not belong to the same owner.

Solution: In the OWNED BY clause, ensure that the sequence and its associated table belong to the same owner.

GAUSS-01336: "sequence must be in same schema as table it is linked to"

SQLSTATE: 55000

Description: The sequence and its associated table do not have the same schema.

Solution: In the OWNED BY clause, ensure that the sequence and its associated table have the same schema.

GAUSS-01337: "seq_redo: unknown op code %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01338: "seq_redo: failed to add item to page"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01340: "unrecognized attribute for text search parser: %d"

SQLSTATE: XX000

Description: While a full-text retrieval parser is created using the CREATE TEXT SEARCH CONFIGURATION PARSER syntax, a specified table fails to be obtained from the pg_ts_parser system catalog.

Solution: The attribute information in pg_ts_parser is incorrect due to system exception or manual attribute modification. Contact technical support.


GAUSS-01341 – GAUSS-01350


GAUSS-01341: "function %s should return type %s"

SQLSTATE: 42P17

Description: The return value type of the specified function is inconsistent with the expected one during the creation of a text search parser.

Solution: While creating a text search parser, modify the return value type of the specified function based on the error message so that the modified value is consistent with that described in the error message.

GAUSS-01342: "must be system admin to create text search parsers"

SQLSTATE: 42501

Description: A non-administrator user creates a text search parser.

Solution: Create a text search parser as a system administrator.

GAUSS-01343: "text search parser parameter '%s' not recognized"

SQLSTATE: 42601

Description: An unrecognized function is defined during the creation of a text search parser.

Solution: Specify the function whose name is start/gettoken/end/headline/lextypes while creating a text search parser.

GAUSS-01345: "text search parser gettoken method is required"

SQLSTATE: 42P17

Description: The gettoken method is not defined during the creation of a text search parser.

Solution: While creating a text search parser, define the gettoken method.

GAUSS-01347: "text search parser lextypes method is required"

SQLSTATE: 42P17

Description: The lextypes method is not defined during the creation of a text search parser.

Solution: While creating a text search parser, define the lextypes method.

GAUSS-01348: "cache lookup failed for text search parser %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01349: "must be system admin to rename text search parsers"

SQLSTATE: 42501

Description: A non-administrator user changes the text search parser name.

Solution: Change the text search parser name as a system administrator.


GAUSS-01351 – GAUSS-01360


GAUSS-01351: "cache lookup failed for text search template %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01352: "text search template '%s' does not accept options"

SQLSTATE: 42601

Description: The init method is not specified but options are specified during the creation or change of a text search dictionary.

Solution: While creating or altering a text search dictionary, specify the init method and options simultaneously, or do not specify options in any cases.

GAUSS-01353: "text search template is required"

SQLSTATE: 42P17

Description: No template is provided during the creation of a text search dictionary.

Solution: Provide a template while creating a text search dictionary.

GAUSS-01354: "cache lookup failed for text search dictionary %u"

SQLSTATE: XX000

Description: The full-text search dictionary corresponding to the ID is not found in the system catalog.

Solution: Check whether the DROP operation is concurrently performed on the dictionary.

GAUSS-01355: "text search dictionary '%s' already exists"

SQLSTATE: 42710

Description: A conflict occurs when changing the text search dictionary name.

Solution: Rename the text search dictionary.

GAUSS-01356: "unrecognized attribute for text search template: %d"

SQLSTATE: XX000

Description: While a full-text search template is created, a specified column fails to be obtained from the pg_ts_template system catalog.

Solution: The attribute information in pg_ts_template is incorrect due to system exception or manual attribute modification. Contact technical support.

GAUSS-01357: "must be system admin to create text search templates"

SQLSTATE: 42501

Description: A non-administrator user creates a text search template.

Solution: Create a text search template as a system administrator.

GAUSS-01358: "text search template parameter '%s' not recognized"

SQLSTATE: 42601

Description: Unrecognized template parameters are provided during the creation of a text search template.

Solution: Provide init or lexize template parameters only.

GAUSS-01359: "text search template lexize method is required"

SQLSTATE: 42P17

Description: The lexize method provided during the creation of a text search template is invalid.

Solution: Provide a valid lexize method during the creation of a text search template.

GAUSS-01360: "must be system admin to rename text search templates"

SQLSTATE: 42501

Description: A non-administrator user changes the text search template name.

Solution: Change the text search template name as a system administrator.


GAUSS-01361 – GAUSS-01370


GAUSS-01362: "cache lookup failed for text search configuration %u"

SQLSTATE: XX000

Description: The full-text search configuration corresponding to the ID is not found in the system catalog.

Solution: Check whether the DROP operation is concurrently performed on the configuration.

GAUSS-01363: "text search configuration parameter '%s' not recognized"

SQLSTATE: 42601

Description: Unrecognized configuration parameters are provided during the creation of a text search configuration.

Solution: Provide parser or copy configuration parameters only.

GAUSS-01364: "cannot specify both PARSER and COPY options"

SQLSTATE: 42601

Description:PARSER and COPY are specified simultaneously during the creation of a text search configuration.

Solution: Do not specify PARSER and COPY simultaneously during the creation of a text search configuration.

GAUSS-01365: "text search parser is required"

SQLSTATE: 42P17

Description: The text search parser cannot be found during the creation of a text search configuration because the PARSER or Copy is incorrectly configured.

Solution: Configure PARSER or COPY correctly so that the text search parser can be found during the creation of a text search configuration.

GAUSS-01366: "text search configuration '%s' already exists"

SQLSTATE: 42710

Description: A conflict occurs when changing the text search configuration.

Solution: Rename the text search configuration.

GAUSS-01367: "text search configuration '%s' does not exist"

SQLSTATE: 42704

Description: The configuration of the specified name does not exist during the change of the text search configuration.

Solution: Ensure that the configuration of the specified name exists.

GAUSS-01368: "method lextype isn't defined for text search parser %u"

SQLSTATE: XX000

Description: The required prslextype definition in the pg_ts_parser system catalog is incorrect.

Solution: The attribute information in pg_ts_parser is incorrect. Contact technical support.

GAUSS-01369: "token type '%s' does not exist"

SQLSTATE: 22023

Description: The token type does not exist during the change of the text search configuration (add/alter/drop mapping).

Solution: Specify an existing token type during the change of the text search configuration (add/alter/drop mapping).

GAUSS-01370: "mapping for token type '%s' does not exist"

SQLSTATE: 42704

Description: The mapping for a token type does not exist during the change of the text search configuration (drop mapping).

Solution: Specify an existing mapping during the change of the text search configuration (drop mapping).


GAUSS-01371 – GAUSS-01380


GAUSS-01371: "invalid parameter list format: '%s'"

SQLSTATE: 42601

Description: During dictionary deserialization, the list format is invalid, and a space is missing after the equal sign (=).

Solution: Add a space after the equal sign (=) in the list.

GAUSS-01372: "unrecognized deserialize_deflist state: %d"

SQLSTATE: XX000

Description: The deserialization process state machine of the full text retrieval directory cannot be identified.

Solution: Internal system error. Contact technical support.

GAUSS-01375: "Bad socket."

SQLSTATE: XX000

Description: Internal system error. Socket reading is invalid.

Solution: Ensure that the network connection between GDS and DNs, network environment, and the system ports of nodes are normal.

GAUSS-01376: "Unexpected EOF on GDS connection '%s': %m"

SQLSTATE: XX000

Description: Internal system error. An error occurs while the database exchanges data with GDS.

Solution: Ensure that the network connection between GDS and DNs, network environment, and the system ports of nodes are normal. Check the GDS warning and error logs to identify the cause.

GAUSS-01377: "Unexpected connection EOF from '%s':%m"

SQLSTATE: XX000

Description: Internal system error. An error occurs while the database exchanges data with GDS.

Solution: Ensure that the network connection between GDS and DNs, network environment, and the system ports of nodes are normal. Check the GDS warning and error logs to identify the cause.

GAUSS-01378: "invalid URI '%s'"

SQLSTATE: XX000

Description: The URI of the GDS foreign table is invalid.

Solution: Check and correct the location settings of the GDS foreign table.

GAUSS-01380: "'%s' is a table"

SQLSTATE: 42809

Description: INSTEAD OF triggers are defined on tables.

Solution: Define only BEFORE or AFTER triggers on tables.


GAUSS-01381 – GAUSS-01390


GAUSS-01381: "'%s' is a view"

SQLSTATE: 42809

Description: Row-level BEFORE, AFTER trigger, or TRUNCATE triggers are defined on views.

Solution: Define only INSTEAD OF triggers on views.

GAUSS-01382: "'%s' is not a table or view"

SQLSTATE: 42809

Description: Triggers are not defined on tables and views.

Solution: Define triggers only on tables and views.

GAUSS-01383: "TRUNCATE FOR EACH ROW triggers are not supported"

SQLSTATE: 0A000

Description: Row-level TRUNCATE triggers are defined.

Solution: Do not define row-level TRUNCATE triggers.

GAUSS-01385: "INSTEAD OF triggers cannot have WHEN conditions"

SQLSTATE: 0A000

Description:WHEN clauses are added to INSTEAD OF triggers.

Solution: Do not add WHEN clauses to INSTEAD OF triggers.

GAUSS-01386: "INSTEAD OF triggers cannot have column lists"

SQLSTATE: 0A000

Description: INSTEAD OF triggers are defined on the columns of tables.

Solution: Do not define INSTEAD OF triggers on the columns of tables.

GAUSS-01387: "cannot use subquery in trigger WHEN condition"

SQLSTATE: 0A000

Description: A subquery is used in the WHEN clause for triggers.

Solution: Do not use a subquery in the WHEN clause for triggers.

GAUSS-01388: "cannot use aggregate function in trigger WHEN condition"

SQLSTATE: 42803

Description: An aggregate function is used in the WHEN clause for triggers.

Solution: Do not use an aggregate function in the WHEN clause for triggers.

GAUSS-01389: "cannot use window function in trigger WHEN condition"

SQLSTATE: 42P20

Description: A window function is used in the WHEN clause for triggers.

Solution: Do not use a window function in the WHEN clause for triggers.

GAUSS-01390: "statement trigger's WHEN condition cannot reference column values"

SQLSTATE: 42P17

Description: Column values are quoted in the WHEN clause for statement triggers.

Solution: Do not quote column values in the WHEN clause for statement triggers.


GAUSS-01391 – GAUSS-01400


GAUSS-01391: "INSERT trigger's WHEN condition cannot reference OLD values"

SQLSTATE: 42P17

Description: Old values are quoted in the WHEN clause for INSERT triggers.

Solution: Do not quote old values in the WHEN clause for INSERT triggers.

GAUSS-01392: "DELETE trigger's WHEN condition cannot reference NEW values"

SQLSTATE: 42P17

Description: New values are quoted in the WHEN clause for DELETE triggers.

Solution: Do not quote new values in the WHEN clause for DELETE triggers.

GAUSS-01393: "BEFORE trigger's WHEN condition cannot reference NEW system columns"

SQLSTATE: 0A000

Description: New system column values are quoted in the WHEN clause for BEFORE triggers.

Solution: Do not quote new system column values in the WHEN clause for BEFORE triggers.

GAUSS-01394: "trigger WHEN condition cannot contain references to other relations"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01395: "function %s must return type 'trigger'"

SQLSTATE: 42P17

Description: The return value of the trigger function is not a trigger type.

Solution: Ensure that the return value of the trigger function is a trigger type.

GAUSS-01396: "trigger '%s' for relation '%s' already exists"

SQLSTATE: 42710

Description: The trigger with the same name is defined on the relational table.

Solution: Modify the trigger name so that it is different from the existing one.

GAUSS-01397: "confused about RI update function"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01398: "confused about RI delete function"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01399: "could not find tuple for trigger %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-01400: "trigger '%s' for table '%s' does not exist"

SQLSTATE: 42704

Description: Failed to find a trigger by name.

Solution: Specify an existing trigger name.