MogDB
Ecological Tools
Doc Menu

GAUSS-00401 – GAUSS-00500


GAUSS-00401 – GAUSS-00410


GAUSS-00401: "access method 'psort' does not support index expressions"

SQLSTATE: 0A000

Description: When psort is specified for the INDEX clause in the CREATE INDEX or ALTER TABLE syntax, the INDEX clause contains an expression.

Solution: Modify the syntax to ensure that the expression does not exist.

GAUSS-00402: "Partition key value can not be null"

SQLSTATE: 42601

Description: When a partitioned table is to be created, the partition key value specified using PARTATION BY RANGE (partition_key)(range_partition_definition_list) is null.

Solution: Ensure that the partition key value is valid.

GAUSS-00403: "partition key value must be const or const-evaluable expression"

SQLSTATE: 42601

Description: When a partitioned table is to be created, the partition key value specified using PARTATION BY RANGE (partition_key)(range_partition_definition_list) is not measurable.

Solution: Ensure that the specified value is a measurable constant or a constant expression.

GAUSS-00404: "argument name '%s' used more than once"

SQLSTATE: 42601

Description: Duplicate parameter names.

Solution: Rename the parameter.

GAUSS-00405: "positional argument cannot follow named argument"

SQLSTATE: 42601

Description: The positional parameter follows behind a named parameter.

Solution: Change the parameter position.

GAUSS-00406: "%s(*) specified, but %s is not an aggregate function"

SQLSTATE: 42809

Description: %s(*) is specified, but function is not an aggregate one.

Solution: Select a valid aggregate function.

GAUSS-00407: "DISTINCT specified, but %s is not an aggregate function"

SQLSTATE: 42809

Description:DISTINCT is specified, but the function is not an aggregate one.

Solution: Select a valid aggregate function.

GAUSS-00408: "ORDER BY specified, but %s is not an aggregate function"

SQLSTATE: 42809

Description:GROUP BY is specified, but the function is not an aggregate one.

Solution: Select a valid aggregate function.

GAUSS-00409: "OVER specified, but %s is not a window function nor an aggregate function"

SQLSTATE: 42809

Description:OVER is specified, but the function is not a window or aggregate one.

Solution: Select a valid window or aggregate function.

GAUSS-00410: "function %s is not unique"

SQLSTATE: 42725

Description: The function is not unique.

Solution: Specify the parameter type and select an optimum function based on the parameter type.


GAUSS-00411 – GAUSS-00420


GAUSS-00411: "function %s does not exist"

SQLSTATE: 42883

Description: The function does not exist.

Solution: Ensure that the required function has been defined.

GAUSS-00412: "%s(*) must be used to call a parameterless aggregate function"

SQLSTATE: 42809

Description: When a function or expression is created as an aggregate function, the function parameters are empty but not asterisks (*).

Solution: Use asterisks (*) if the function parameters are empty.

GAUSS-00413: "aggregates cannot return sets"

SQLSTATE: 42P13

Description: When a function or expression is created as an aggregate function, this function returns a set.

Solution: Check the function return type and ensure that no sets can be returned.

GAUSS-00414: "aggregates cannot use named arguments"

SQLSTATE: 0A000

Description: When a function or expression is called as an aggregate function, this function uses parameter names.

Solution: Use valid values instead of parameter names when calling an aggregate function.

GAUSS-00415: "window function call requires an OVER clause"

SQLSTATE: 42809

Description: When a function or expression is called as a window function, the OVER clause is not defined.

Solution: Define the OVER clause.

GAUSS-00416: "DISTINCT is not implemented for window functions"

SQLSTATE: 0A000

Description: When a function or expression is called as a window function, this window function contains a DISTINCT clause.

Solution: Check the syntax and delete the DISTINCT clause if any.

GAUSS-00417: "aggregate ORDER BY is not implemented for window functions"

SQLSTATE: 0A000

Description: When a function or expression is called as a window function, this function contains an ORDER BY clause.

Solution: Check the syntax and delete the ORDER BY clause if any.

GAUSS-00418: "window functions cannot return sets"

SQLSTATE: 42P13

Description: When a function or expression is created as a window function, this function returns a set.

Solution: Check the function return type and ensure that no sets can be returned.

GAUSS-00419: "window functions cannot use named arguments"

SQLSTATE: 0A000

Description: When you call a function or expression as a window function, this function uses parameter names.

Solution: Use valid values instead of parameter names when calling a window function.

GAUSS-00420: "not enough default arguments"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-00421 – GAUSS-00430


GAUSS-00421: "function %s asks parameters"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00422: "aggregate %s(*) does not exist"

SQLSTATE: 42883

Description: The aggregate function contains an invalid parameter.

Solution: Check whether the number of parameters is zero.

GAUSS-00423: "aggregate %s does not exist"

SQLSTATE: 42883

Description: The aggregate function is invalid.

Solution: Check whether the aggregate function is contained in the pg_proc table.

GAUSS-00424: "function %s is not an aggregate"

SQLSTATE: 42809

Description: The created function is not an invalid aggregate function.

Solution: Ensure that functions with asterisks (*) as parameters must be aggregate functions.

GAUSS-00426: "inconsistent types deduced for parameter $%d"

SQLSTATE: 42P08

Description: Usage not supported.

Solution: Modify the SQL statement.

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

SQLSTATE: 42P08

Description: The parameter data type cannot be recognized.

Solution: Change the parameter value to a value recognizable to the system. For the value types recognizable to the system, see en-us_topic_0237121926.html.

GAUSS-00428: "could not create syslogger data transfer thread: %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00429: "could not create pipe for syslog: %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00430: "could not redirect stdout: %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-00431 – GAUSS-00440


GAUSS-00431: "could not redirect stderr: %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00432: "checkpoint request failed"

SQLSTATE: XX000

Description: An internal checkpoint error occurs.

Solution:Contact technical support.

GAUSS-00433: "ForwardFsyncRequest must not be called in checkpointer"

SQLSTATE: XX000

Description: An internal checkpoint error occurs.

Solution:Contact technical support.

GAUSS-00434: "could not open archive status directory '%s': %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00435: "no free worker found"

SQLSTATE: XX000

Description: No threads are available to clear 2PC transactions.

Solution: Increase the value of autovacuum_max_workers.

GAUSS-00436: "cache lookup failed for database %u"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00437: "the options of -M is not recognized"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00438: "–%s requires a value"

SQLSTATE: 42601

Description: The value of a parameter is not specified in the command.

Solution: Assign a value to the parameter used in the command.

GAUSS-00439: "-c %s requires a value"

SQLSTATE: 42601

Description: The value of a parameter is not specified in the command.

Solution: Assign a value to the parameter used in the command.

GAUSS-00440: "invalid list syntax for 'listen_addresses'"

SQLSTATE: 22023

Description:Internal system error.

Solution:Contact technical support.


GAUSS-00441 – GAUSS-00450


GAUSS-00442: "could not create any TCP/IP sockets"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00444: "no socket created for listening"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00445: "could not create I/O completion port for child queue"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00446: "could not load pg_hba.conf"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00447: "%s: could not locate my own executable path"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00448: "%s: could not locate matching postgres executable"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00449: "could not open directory '%s': %m"

SQLSTATE: XX000

Description: Failed to open a directory.

Solution: Analyze the cause based on the error message. If the directory does not exist, create one. If the permission is incorrect, change the permission. If the directory is damaged, restore the file system or disk.

GAUSS-00450: "data directory '%s' does not exist"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-00451 – GAUSS-00460


GAUSS-00451: "could not read permissions of directory '%s': %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00452: "specified data directory '%s' is not a directory"

SQLSTATE: 55000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00453: "data directory '%s' has wrong ownership"

SQLSTATE: 55000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00454: "data directory '%s' has group or world access"

SQLSTATE: 55000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00457: "hot standby is not possible because wal_level was not set to 'hot_standby'"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00458: "when starting as dual mode, we must ensure wal_level was not 'minimal' and max_wal_senders was set at least 1"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.


GAUSS-00461 – GAUSS-00470


GAUSS-00466: "sorry, too many clients already"

SQLSTATE: 53300

Description:Internal system error.

Solution:Contact technical support.


GAUSS-00471 – GAUSS-00480


GAUSS-00474: "fcntl F_GETFD failed!"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00475: "fcntl F_SETFD failed!"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00476: "could not set timer for startup packet timeout"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00477: "could not disable timer for startup packet timeout"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00478: "out of memory"

SQLSTATE: 53200

Description: Failed to allocate the memory.

Solution: Ensure that the system has sufficient memory.


GAUSS-00481 – GAUSS-00490


GAUSS-00481: "parameter error in ParseHaListenAddr()"

SQLSTATE: XX000

Description: The function ParseHaListenAddr uses an incorrect parameter.

Solution: Find out the reason why the imported parameter pointer is null.

GAUSS-00482: "must be system admin to reset statistics counters"

SQLSTATE: 42501

Description: Only the system administrator has the permission to reset statistics counters.

Solution: Switch to a system administrator.

GAUSS-00483: "unrecognized reset target: '%s'"

SQLSTATE: 22023

Description: The target parameter to be reset is incorrect.

Solution: The parameter must be bgwriter.

GAUSS-00484: "could not read statistics message: %m"

SQLSTATE: XX000

Description:pgStat cannot read statistics messages.

Solution: Communication between threads in the database is abnormal. Contact technical support.

GAUSS-00485: "database hash table corrupted during cleanup — abort"

SQLSTATE: XX000

Description: The hash table is corrupted during the database cleanup.

Solution: This is an internal database error. Contact technical support.

GAUSS-00486: "could not create sysauditor data transfer thread: %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00487: "could not create pipe for sysaudit: %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00488: "could not write to audit file: %m"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00489: "set-valued function called in context that cannot accept a set"

SQLSTATE: 0A000

Description: The function that is expected to return a result set fails to return a result set.

Solution: Ensure that this function is defined to return a result set.

GAUSS-00490: "materialize mode required, but it is not allowed in this context"

SQLSTATE: 0A000

Description: The returned tuplestore is not supported in this context.

Solution: Change the return value type.


GAUSS-00491 – GAUSS-00500


GAUSS-00491: "return type must be a row type"

SQLSTATE: XX000

Description: The tuple descriptor constructed is not a row result message.

Solution: Query again. Check whether this error persists. Contact technical support.

GAUSS-00492: "attribute count of the return row type not matched"

SQLSTATE: XX000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00493: "permission denied to query audit"

SQLSTATE: 42501

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00494: "permission denied to delete audit"

SQLSTATE: 42501

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00495: "conflicting or redundant options"

SQLSTATE: 42601

Description:Internal system error.

Solution:Contact technical support.

GAUSS-00496: "option '%s' not recognized"

SQLSTATE: XX000

Description: The value of a copy option cannot be recognized.

Solution: Ensure that the value is correct.

GAUSS-00497: "%d is not a valid encoding code"

SQLSTATE: 42704

Description: When a character string is converted into ASCII code, the specified code identifier is not used.

Solution: Ensure that the No. of the specified code identifier is smaller than 42.

GAUSS-00498: "%s is not a valid encoding name"

SQLSTATE: 42704

Description: When a character string is converted to ASCII code, an invalid character encoding name is used.

Solution: Ensure that the code identifier name is valid.

GAUSS-00500: "permission denied to create database"

SQLSTATE: 42501

Description: You do not have permission to create a database.

Solution: Only the user having the CREATEDB permission or the system administrator has permission to create a database. Ensure that you have permission to create a database.