MogDB
Ecological Tools
Doc Menu

GAUSS-03301 – GAUSS-03400


GAUSS-03301 – GAUSS-03310


GAUSS-03301: "cannot lock cluster for backup in presence of %d uncommitted prepared transactions"

SQLSTATE: 55P03

Description: The cluster cannot be locked for backup when prepared transactions are uncommitted.

Solution: Lock the cluster for backup after prepared transactions are committed.

GAUSS-03302: "cannot lock cluster for backup, lock is already held"

SQLSTATE: 55P03

Description: The cluster cannot be locked for backup because the lock is not obtained.

Solution: Lock the cluster for backup after the relevant locked resources are released.

GAUSS-03304: "word is too long (%ld bytes, max %ld bytes)"

SQLSTATE: 54000

Description: The word exceeds the maximum length.

Solution: Use a word within the allowed length.

GAUSS-03305: "string is too long for tsvector (%ld bytes, max %ld bytes)"

SQLSTATE: 54000

Description: The string exceeds the maximum length.

Solution: Use a string within the allowed length.

GAUSS-03306: "positions array too long"

SQLSTATE: XX000

Description: The entered string length exceeds the maximum length allowed by the tsvector type (1<<20) - 1.

Solution: Shorten the string.

GAUSS-03307: "invalid size of tsvector"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03308: "invalid tsvector: lexeme too long"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03309: "invalid tsvector: maximum total lexeme length exceeded"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-03311 – GAUSS-03320


GAUSS-03311: "position information is misordered"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03312: "unrecognized LC category: %d"

SQLSTATE: XX004

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03313: "could not convert string to UTF-8: error code %lu"

SQLSTATE: 22021

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03314: "invalid LC_COLLATE setting"

SQLSTATE: D0011

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03315: "invalid LC_CTYPE setting"

SQLSTATE: D0011

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03316: "could not create locale '%s': %m"

SQLSTATE: 22023

Description: The locale cannot be created because the OS cannot find the specified locale name.

Solution: Ensure that the created locale is supported by the OS.

GAUSS-03317: "collations with different collate and ctype values are not supported on this platform"

SQLSTATE: 0A000

Description: The current OS does not support collations with different collate and ctype values.

Solution: The sorting rules of data in each column can be specified. When a collation is created, ensure that the values of LC_COLLATE and LC_CTYPE are the same.

GAUSS-03318: "nondefault collations are not supported on this platform"

SQLSTATE: 0A000

Description: Non-default collations are not supported.

Solution: Ensure that the default collation is used on this platform.

GAUSS-03319: "wcstombs_l is not available"

SQLSTATE: 22021

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03320: "mbstowcs_l is not available"

SQLSTATE: 22021

Description:Internal system error.

Solution:Contact technical support.


GAUSS-03321 – GAUSS-03330


GAUSS-03321: "invalid multibyte character for locale"

SQLSTATE: 22021

Description: The character to be converted is a multi-byte character. The locale specified by LC_CTYPE locale on the server is incompatible with the encoding of the database.

Solution: Change the server locale.

GAUSS-03322: "unsupported XML feature"

SQLSTATE: 0A000

Description: The XML feature is not supported.

Solution: Do not use XML feature-related functions.

GAUSS-03323: "invalid XML comment"

SQLSTATE: 2200S

Description: The XML comment is invalid.

Solution: Ensure that the XML comment format is <– … –>.

GAUSS-03324: "not an XML document"

SQLSTATE: 2200L

Description: The input XML document in the xmltotext function is invalid.

Solution: Correct the XML data.

GAUSS-03325: "invalid XML processing instruction"

SQLSTATE: 42601

Description: The XML processing instruction (PI) is invalid. The target name should not be xml (case insensitive).

Solution: Change the target name of PI in the XML document.

GAUSS-03326: "invalid XML processing instruction"

SQLSTATE: 42601

Description: The XML processing instruction (PI) is invalid. The target name should not be xml (case insensitive).

Solution: Change the target name of PI in the XML document.

GAUSS-03327: "xmlvalidate is not implemented"

SQLSTATE: 0A000

Description: The XMLVALIDATE function is not implemented.

Solution: Do not use the XMLVALIDATE function.

GAUSS-03328: "could not initialize XML library"

SQLSTATE: XX000

Description: A system error occurs. Failed to initialize the XML library.

Solution:Contact technical support.

GAUSS-03329: "could not set up XML error handler"

SQLSTATE: 0A000

Description: A system error occurs. Failed to set the XML error handler.

Solution:Contact technical support.

GAUSS-03330: "xml_ereport called with invalid PgXmlErrorContext"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-03331 – GAUSS-03340


GAUSS-03331: "xml_errorHandler called with invalid PgXmlErrorContext"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03332: "invalid query"

SQLSTATE: 22000

Description: The query is invalid.

Solution: Modify the query statement.

GAUSS-03333: "xpath expression result type %d is unsupported"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03334: "invalid array for XML namespace mapping"

SQLSTATE: 22000

Description: An internal error occurs. The array for XML namespace mapping is invalid. The array must be a two-dimensional array.

Solution:Contact technical support.

GAUSS-03335: "empty XPath expression"

SQLSTATE: 22000

Description: The Xpath expression is empty.

Solution: Provide a valid Xpath expression when the XML function is called.

GAUSS-03336: "neither namespace name nor URI may be null"

SQLSTATE: 22004

Description: Either the XML namespace or the corresponding URL is NULL.

Solution: Ensure that neither the XML namespace nor URL is NULL.

GAUSS-03338: "LIKE pattern must not end with escape character"

SQLSTATE: 22025

Description: The LIKE pattern should not be ended with an escape character.

Solution: Modify the LIKE pattern and ensure that it is not ended with an escape character.

GAUSS-03339: "invalid format specification for an interval value"

SQLSTATE: 22007

Description: The input parameter cannot be the interval type when the date/time field is converted to char.

Solution: Ensure that the input parameter is in the correct time format.

GAUSS-03340: "'EEEE' must be the last pattern used"

SQLSTATE: 42601

Description: The numeric format is incorrect. EEEE should appear at the last part.

Solution: Modify the value format and perform the operation again.


GAUSS-03341 – GAUSS-03350


GAUSS-03341: "'9' must be ahead of 'PR'"

SQLSTATE: 42601

Description: The numeric format is incorrect. 9 must be ahead of PR.

Solution: Modify the value format and perform the operation again.

GAUSS-03342: "'0' must be ahead of 'PR'"

SQLSTATE: 42601

Description: The numeric format is incorrect. 0 must be ahead of PR.

Solution: Modify the value format and perform the operation again.

GAUSS-03343: "multiple decimal points"

SQLSTATE: 42601

Description: The numeric format is incorrect. Multiple decimal points are forbidden.

Solution: Modify the value format and perform the operation again.

GAUSS-03345: "cannot use 'S' twice"

SQLSTATE: 42601

Description: The numeric format is incorrect. S cannot be used twice.

Solution:Contact technical support.

GAUSS-03346: "cannot use 'S' and 'PL'/'MI'/'SG'/'PR' together"

SQLSTATE: 42601

Description: The numeric format is incorrect. S cannot be used together with PL, MI, SG, and PR.

Solution: Modify the value format and perform the operation again.

GAUSS-03347: "cannot use 'S' and 'MI' together"

SQLSTATE: 42601

Description: The numeric format is incorrect. S and MI cannot be used together.

Solution: Modify the value format and perform the operation again.

GAUSS-03348: "cannot use 'S' and 'PL' together"

SQLSTATE: 42601

Description: The numeric format is incorrect. S and PL cannot be used together.

Solution: Modify the value format and perform the operation again.

GAUSS-03349: "cannot use 'S' and 'SG' together"

SQLSTATE: 42601

Description: The numeric format is incorrect. S and SG cannot be used together.

Solution: Modify the value format and perform the operation again.

GAUSS-03350: "cannot use 'PR' and 'S'/'PL'/'MI'/'SG' together"

SQLSTATE: 42601

Description: The numeric format is incorrect. PR cannot be used together with S, PL, MI, and SG.

Solution: Modify the value format and perform the operation again.


GAUSS-03351 – GAUSS-03360


GAUSS-03351: "cannot use 'EEEE' twice"

SQLSTATE: 42601

Description: The numeric format is incorrect. EEEE cannot be used twice.

Solution: Modify the value format and perform the operation again.

GAUSS-03352: "'EEEE' is incompatible with other formats"

SQLSTATE: 42601

Description: The value format is incorrect. EEEE is incompatible with other formats.

Solution: Modify the value format and perform the operation again.

GAUSS-03353: "invalid data for match in format string"

SQLSTATE: 22007

Description: When the data is converted to the timestamp format, the format parameter value does not comply with the timestamp format.

Solution: Modify the format string and ensure that it can correctly indicate the timestamp format. Perform the operation again.

GAUSS-03354: "'%s' is not a number"

SQLSTATE: 22P02

Description: A numeric string should not contain non-number characters.

Solution: Modify the numeric string and perform the operation again.

GAUSS-03355: "could not determine which collation to use for lower() function"

SQLSTATE: 42P22

Description: Failed to determine the collation used for calling the lower function.

Solution: Use the COLLATE clause to set the collation.

GAUSS-03356: "could not determine which collation to use for upper() function"

SQLSTATE: 42P22

Description: Failed to determine the collation used for calling the upper function.

Solution: Use the COLLATE clause to set the collation.

GAUSS-03357: "could not determine which collation to use for initcap() function"

SQLSTATE: 42P22

Description: Failed to determine the collation used for calling the initcap function.

Solution: Use the COLLATE clause to set the collation.

GAUSS-03358: " RR/RRRR should be between 0 - 9999"

SQLSTATE: 22008

Description: The date and time format is incorrect. The year value should range between 0 and 9999.

Solution: Correct the year value.

GAUSS-03359: "invalid combination of date conventions"

SQLSTATE: 22007

Description: The date and time format is incorrect. A combination of the Gregorian calendar and ISO week date format cannot be used.

Solution: Modify the date format. Use the Gregorian calendar or ISO week date.

GAUSS-03360: "conflicting values for '%s' field in formatting string"

SQLSTATE: 22007

Description: The date and time format is incorrect. The same field is repeatedly given conflicting values.

Solution: Do not set conflicting values. Cancel the second value assignment.


GAUSS-03361 – GAUSS-03370


GAUSS-03361: "source string too short for '%s' formatting field"

SQLSTATE: 22007

Description: The date and time format is incorrect. The length of the source string must be shorter than the length to be read.

Solution: Use the FM modifier if the source string does not have a fixed length.

GAUSS-03362: "invalid value '%s' for '%s'"

SQLSTATE: 22007

Description: The date and time format is incorrect. Failed to parse partial characters of the string.

Solution: Correct the date and time format of the string to be converted. If the string does not have a fixed length, use the FM modifier.

GAUSS-03363: "value for '%s' in source string is out of range"

SQLSTATE: 22008

Description: The date and time format is incorrect. The string value is out of range.

Solution: Correct the string value based on the prompt.

GAUSS-03364: "character does not match format string"

SQLSTATE: 22007

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03365: "input length of format 'US'/'us'/'FF'/'ff' must between 0 and 6"

SQLSTATE: 22008

Description: The date and time value is out of range. The length of the US/us/FF/ff format must range between 0 and 6.

Solution: Change the format length and ensure that the format range between 0 and 6.

GAUSS-03366: "'TZ'/'tz' format patterns are not supported in to_date"

SQLSTATE: 0A000

Description: The date in the TZ/tz format is not supported.

Solution: Modify the date format.

GAUSS-03367: "invalid input string for 'Y,YYY'"

SQLSTATE: 22007

Description: The input string fails to meet the date and time format requirements.

Solution: Ensure that the input string is in the Y,YYY format.

GAUSS-03368: "invalid data for match in date string"

SQLSTATE: 22007

Description: The date and time format is incorrect. The data for match in a date string is invalid.

Solution: Use valid string text to query the match.

GAUSS-03369: "invalid data for '%s = %d' ,value must be %s"

SQLSTATE: 22008

Description: The date and time format is incorrect. The input data is inconsistent with the specified value.

Solution: Input the data based on the specified value.

GAUSS-03370: " seconds of minute conflicts with seconds in day"

SQLSTATE: 22007

Description: The date and time format is incorrect. The second value of the minute conflicts with that of the day.

Solution: Modify the date and time format.


GAUSS-03371 – GAUSS-03380


GAUSS-03371: " minutes of hour conflicts with seconds in day"

SQLSTATE: 22007

Description: The date and time format is incorrect. The minute value of the hour conflicts with the second value of the day.

Solution: Modify the date and time format.

GAUSS-03372: "hour conflicts with seconds in day"

SQLSTATE: 22007

Description: The date and time format is incorrect. The hour value conflicts with the second value of the day.

Solution: Modify the date and time format.

GAUSS-03373: "hour '%d' is invalid for the 12-hour clock"

SQLSTATE: 22007

Description: The date and time format is incorrect. The hour value for the 12-hour clock is invalid.

Solution: Ensure that the hour value for the 12-hour clock ranges from 1 to 12.

GAUSS-03374: "inconsistent use of year %04d and 'BC'"

SQLSTATE: 22007

Description: The date and time format is incorrect. The BC year value must be a positive value.

Solution: Correct the year value.

GAUSS-03375: "year conflicts with Julian date"

SQLSTATE: 22007

Description: The date and time format is incorrect. The year value conflicts with the Julian date.

Solution: Modify the date and time format.

GAUSS-03376: "month conflicts with Julian date"

SQLSTATE: 22007

Description: The date and time format is incorrect. The month value conflicts with the Julian date.

Solution: Modify the date and time format.

GAUSS-03377: "day conflicts with Julian date"

SQLSTATE: 22007

Description: The date and time format is incorrect. The day value conflicts with the Julian date.

Solution: Modify the date and time format.

GAUSS-03378: "cannot calculate day of year without year information"

SQLSTATE: 22007

Description: The date and time format is incorrect. Failed to calculate days of a year because the year value is missing.

Solution: Modify the date and time format.

GAUSS-03379: "month conflicts with days of year"

SQLSTATE: 22007

Description: The date and time format is incorrect. The month value conflicts with the day value of a year.

Solution: Modify the date and time format.

GAUSS-03380: "days of month conflicts with days of year"

SQLSTATE: 22007

Description: The date and time format is incorrect. The day value of a month conflicts with that of a year.

Solution: Modify the date and time format.


GAUSS-03381 – GAUSS-03390


GAUSS-03381: "long_int_add inner error, addend or summand is null pointer"

SQLSTATE: XX000

Description: Internal system error. A null pointer is found when the long integer and the integer are added.

Solution: Contact technical support.

GAUSS-03382: "long_int_add inner error, length of long_int not support."

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03383: "'EEEE' not supported for input"

SQLSTATE: 0A000

Description: The input for a string converted to a number does not support the EEEE format.

Solution: Do not use EEEE as the format of a string to be converted to a number.

GAUSS-03384: "'RN' not supported for input"

SQLSTATE: 0A000

Description: The input for a string converted to a number does not support the RN format.

Solution: Do not use RN as the format of a string to be converted to a number.

GAUSS-03385: "'%c' not supported"

SQLSTATE: 0A000

Description: Failed to convert the character to a number.

Solution: Ensure that valid characters are used when a string is converted to a number.

GAUSS-03386: "to_number only support 16 bytes hex to decimal conversion or plen less than 0."

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03387: "invalid number format model"

SQLSTATE: 22023

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03388: "invalid number"

SQLSTATE: 22023

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03389: "ts_rewrite query must return two tsquery columns"

SQLSTATE: 22023

Description: A system error occurs. Two tsquery columns must be returned when a text search overwrite query is performed.

Solution: Check the query statement during the ts_rewrite function calling and ensure that only two columns are returned.

GAUSS-03390: "array_typanalyze was invoked for non-array type %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-03391 – GAUSS-03400


GAUSS-03391: "insufficient pg_statistic slots for array stats"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03392: "must be system admin or have the same role to cancel queries running in other server processes"

SQLSTATE: 42501

Description: You do not have the permission to cancel queries.

Solution: Cancel queries as a system administrator or an equivalent role.

GAUSS-03394: "must be system admin or have the same role to terminate other backend"

SQLSTATE: 42501

Description: You do not have the permission to terminate other backend processes.

Solution: Terminate queries as a system administrator or an equivalent role.

GAUSS-03395: "must be system admin to signal the postmaster"

SQLSTATE: 42501

Description: Only system administrators can reload database configuration parameters.

Solution: Reload database configuration parameters as a system administrator.

GAUSS-03396: "must be system admin to rotate log files"

SQLSTATE: 42501

Description: Only system administrators can rotate log files.

Solution: Rotate log files as a system administrator.

GAUSS-03397: "fail to drop the user"

SQLSTATE: 42501

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03398: "index '%s' already contains data"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-03399: "failed to re-find scan position within index '%s'"

SQLSTATE: XX000

Description: The offset is greater than the maximum internal offset.

Solution: A preventive error mechanism. Contact technical support.

GAUSS-03400: "hash does not support mark/restore"

SQLSTATE: XX000

Description: Hash does not support recording or restoring the scan position.

Solution: Do not perform this operation because the function is not supported.