- About MogDB
- MogDB Introduction
- Comparison Between MogDB and openGauss
- MogDB Release Note
- High Availability and Performance
- Open Source Components
- Usage Limitations
- Terms of Use
- Quick Start
- Installation Guide
- Container Installation
- Standard Installation
- Installation Overview
- Preparing for Installation
- Installing the MogDB
- Verifying the Installation
- Uninstalling the MogDB
- Administrator Guide
- Routine Maintenance
- Primary and Standby Management
- MogHA Management
- MOT Engine
- Introducing MOT
- Using MOT
- Concepts of MOT
- Appendix
- Column-store Tables Management
- Backup and Restoration
- Importing and Exporting Data
- Importing Data
- Exporting Data
- Upgrade Guide
- Common Fault Locating Cases
- Core Fault Locating
- When the TPC-C is running and a disk to be injected is full, the TPC-C stops responding
- Standby Node in the Need Repair (WAL) State
- Insufficient Memory
- Service Startup Failure
- "Error:No space left on device" Is Displayed
- After You Run the du Command to Query Data File Size In the XFS File System, the Query Result Is Greater than the Actual File Size
- File Is Damaged in the XFS File System
- Primary Node Is Hung in Demoting During a Switchover
- Disk Space Usage Reaches the Threshold and the Database Becomes Read-only
- Slow Response to a Query Statement
- Analyzing the Status of a Query Statement
- Forcibly Terminating a Session
- Analyzing Whether a Query Statement Is Blocked
- Low Query Efficiency
- "Lock wait timeout" Is Displayed When a User Executes an SQL Statement
- Table Size Does not Change After VACUUM FULL Is Executed on the Table
- An Error Is Reported When the Table Partition Is Modified
- Different Data Is Displayed for the Same Table Queried By Multiple Users
- When a User Specifies Only an Index Name to Modify the Index, A Message Indicating That the Index Does Not Exist Is Displayed
- Reindexing Fails
- An Error Occurs During Integer Conversion
- "too many clients already" Is Reported or Threads Failed To Be Created in High Concurrency Scenarios
- B-tree Index Faults
- Security Guide
- Database Security Management
- Performance Tuning
- System Optimization
- SQL Optimization
- WDR Snapshot Schema
- Developer Guide
- Application Development Guide
- Development Specifications
- Development Based on JDBC
- Overview
- JDBC Package, Driver Class, and Environment Class
- Development Process
- Loading the Driver
- Connecting to a Database
- Connecting to the Database (Using SSL)
- Running SQL Statements
- Processing Data in a Result Set
- Closing a Connection
- Example: Common Operations
- Example: Retrying SQL Queries for Applications
- Example: Importing and Exporting Data Through Local Files
- Example 2: Migrating Data from a MY Database to MogDB
- Example: Logic Replication Code
- JDBC Interface Reference
- Development Based on ODBC
- Development Based on libpq
- Commissioning
- Appendices
- Stored Procedure
- User Defined Functions
- Application Development Guide
- Tool Reference
- System Catalogs and System Views
- Overview of System Catalogs and System Views
- System Catalogs
- GS_CLIENT_GLOBAL_KEYS
- GS_CLIENT_GLOBAL_KEYS_ARGS
- GS_COLUMN_KEYS
- GS_COLUMN_KEYS_ARGS
- GS_ENCRYPTED_COLUMNS
- GS_OPT_MODEL
- GS_WLM_INSTANCE_HISTORY
- GS_WLM_OPERATOR_INFO
- GS_WLM_PLAN_ENCODING_TABLE
- GS_WLM_PLAN_OPERATOR_INFO
- GS_WLM_USER_RESOURCE_HISTORY
- PG_AGGREGATE
- PG_AM
- PG_AMOP
- PG_AMPROC
- PG_APP_WORKLOADGROUP_MAPPING
- PG_ATTRDEF
- PG_ATTRIBUTE
- PG_AUTHID
- PG_AUTH_HISTORY
- PG_AUTH_MEMBERS
- PG_CAST
- PG_CLASS
- PG_COLLATION
- PG_CONSTRAINT
- PG_CONVERSION
- PG_DATABASE
- PG_DB_ROLE_SETTING
- PG_DEFAULT_ACL
- PG_DEPEND
- PG_DESCRIPTION
- PG_DIRECTORY
- PG_ENUM
- PG_EXTENSION
- PG_EXTENSION_DATA_SOURCE
- PG_FOREIGN_DATA_WRAPPER
- PG_FOREIGN_SERVER
- PG_FOREIGN_TABLE
- PG_INDEX
- PG_INHERITS
- PG_JOB
- PG_JOB_PROC
- PG_LANGUAGE
- PG_LARGEOBJECT
- PG_LARGEOBJECT_METADATA
- PG_NAMESPACE
- PG_OBJECT
- PG_OPCLASS
- PG_OPERATOR
- PG_OPFAMILY
- PG_PARTITION
- PG_PLTEMPLATE
- PG_PROC
- PG_RANGE
- PG_RESOURCE_POOL
- PG_REWRITE
- PG_RLSPOLICY
- PG_SECLABEL
- PG_SHDEPEND
- PG_SHDESCRIPTION
- PG_SHSECLABEL
- PG_STATISTIC
- PG_STATISTIC_EXT
- PG_TABLESPACE
- PG_TRIGGER
- PG_TS_CONFIG
- PG_TS_CONFIG_MAP
- PG_TS_DICT
- PG_TS_PARSER
- PG_TS_TEMPLATE
- PG_TYPE
- PG_USER_MAPPING
- PG_USER_STATUS
- PG_WORKLOAD_GROUP
- PLAN_TABLE_DATA
- STATEMENT_HISTORY
- System Views
- GS_SESSION_CPU_STATISTICS
- GS_SESSION_MEMORY_STATISTICS
- GS_SQL_COUNT
- GS_WLM_OPERATOR_HISTORY
- GS_WLM_OPERATOR_STATISTICS
- GS_WLM_PLAN_OPERATOR_HISTORY
- GS_WLM_REBUILD_USER_RESOURCE_POOL
- GS_WLM_RESOURCE_POOL
- GS_WLM_SESSION_HISTORY
- GS_WLM_SESSION_INFO_ALL
- GS_WLM_USER_INFO
- GS_WLM_SESSION_STATISTICS
- GS_STAT_SESSION_CU
- MPP_TABLES
- PG_AVAILABLE_EXTENSION_VERSIONS
- PG_AVAILABLE_EXTENSIONS
- PG_CURSORS
- PG_EXT_STATS
- PG_GET_INVALID_BACKENDS
- PG_GET_SENDERS_CATCHUP_TIME
- PG_GROUP
- PG_GTT_RELSTATS
- PG_GTT_STATS
- PG_GTT_ATTACHED_PIDS
- PG_INDEXES
- PG_LOCKS
- PG_MATVIEWS
- PG_NODE_ENV
- PG_OS_THREADS
- PG_PREPARED_STATEMENTS
- PG_PREPARED_XACTS
- PG_REPLICATION_SLOTS
- PG_RLSPOLICIES
- PG_ROLES
- PG_RULES
- PG_SECLABELS
- PG_SESSION_WLMSTAT
- PG_SESSION_IOSTAT
- PG_SETTINGS
- PG_SHADOW
- PG_STATS
- PG_STAT_ACTIVITY
- PG_STAT_ALL_INDEXES
- PG_STAT_ALL_TABLES
- PG_STAT_BAD_BLOCK
- PG_STAT_BGWRITER
- PG_STAT_DATABASE
- PG_STAT_DATABASE_CONFLICTS
- PG_STAT_USER_FUNCTIONS
- PG_STAT_USER_INDEXES
- PG_STAT_USER_TABLES
- PG_STAT_REPLICATION
- PG_STAT_SYS_INDEXES
- PG_STAT_SYS_TABLES
- PG_STAT_XACT_ALL_TABLES
- PG_STAT_XACT_SYS_TABLES
- PG_STAT_XACT_USER_FUNCTIONS
- PG_STAT_XACT_USER_TABLES
- PG_STATIO_ALL_INDEXES
- PG_STATIO_ALL_SEQUENCES
- PG_STATIO_ALL_TABLES
- PG_STATIO_SYS_INDEXES
- PG_STATIO_SYS_SEQUENCES
- PG_STATIO_SYS_TABLES
- PG_STATIO_USER_INDEXES
- PG_STATIO_USER_SEQUENCES
- PG_STATIO_USER_TABLES
- PG_THREAD_WAIT_STATUS
- PG_TABLES
- PG_TDE_INFO
- PG_TIMEZONE_NAMES
- PG_TOTAL_USER_RESOURCE_INFO
- PG_USER
- PG_USER_MAPPINGS
- PG_VIEWS
- PG_WLM_STATISTICS
- PLAN_TABLE
- GS_FILE_STAT
- GS_OS_RUN_INFO
- GS_REDO_STAT
- GS_SESSION_MEMORY
- GS_SESSION_MEMORY_DETAIL
- GS_SESSION_STAT
- GS_SESSION_TIME
- GS_THREAD_MEMORY_DETAIL
- GS_TOTAL_MEMORY_DETAIL
- PG_TIMEZONE_ABBREVS
- PG_TOTAL_USER_RESOURCE_INFO_OID
- PG_VARIABLE_INFO
- GS_INSTANCE_TIME
- Functions and Operators
- Logical Operators
- Comparison Operators
- Character Processing Functions and Operators
- Binary String Functions and Operators
- Bit String Functions and Operators
- Mode Matching Operators
- Mathematical Functions and Operators
- Date and Time Processing Functions and Operators
- Type Conversion Functions
- Geometric Functions and Operators
- Network Address Functions and Operators
- Text Search Functions and Operators
- JSON Functions
- SEQUENCE Functions
- Array Functions and Operators
- Range Functions and Operators
- Aggregate Functions
- Window Functions
- Security Functions
- Encrypted Equality Functions
- Set Returning Functions
- Conditional Expression Functions
- System Information Functions
- System Administration Functions
- Statistics Information Functions
- Trigger Functions
- Global Temporary Table Functions
- AI Feature Functions
- Other System Functions
- Supported Data Types
- SQL Syntax
- ABORT
- ALTER DATABASE
- ALTER DATA SOURCE
- ALTER DEFAULT PRIVILEGES
- ALTER DIRECTORY
- ALTER FOREIGN TABLE
- ALTER FUNCTION
- ALTER GROUP
- ALTER INDEX
- ALTER LARGE OBJECT
- ALTER MATERIALIZED VIEW
- ALTER ROLE
- ALTER ROW LEVEL SECURITY POLICY
- ALTER RULE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER SERVER
- ALTER SESSION
- ALTER SYNONYM
- ALTER SYSTEM KILL SESSION
- ALTER SYSTEM SET
- ALTER TABLE
- ALTER TABLE PARTITION
- ALTER TABLESPACE
- ALTER TEXT SEARCH CONFIGURATION
- ALTER TEXT SEARCH DICTIONARY
- ALTER TRIGGER
- ALTER TYPE
- ALTER USER
- ALTER USER MAPPING
- ALTER VIEW
- ANALYZE | ANALYSE
- BEGIN
- CALL
- CHECKPOINT
- CLOSE
- CLUSTER
- COMMENT
- COMMIT | END
- COMMIT PREPARED
- COPY
- CREATE CLIENT MASTER KEY
- CREATE COLUMN ENCRYPTION KEY
- CREATE DATABASE
- CREATE DATA SOURCE
- CREATE DIRECTORY
- CREATE FOREIGN TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INDEX
- CREATE MATERIALIZED VIEW
- CREATE ROW LEVEL SECURITY POLICY
- CREATE PROCEDURE
- CREATE ROLE
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SERVER
- CREATE SYNONYM
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLE PARTITION
- CREATE TABLESPACE
- CREATE TEXT SEARCH CONFIGURATION
- CREATE TEXT SEARCH DICTIONARY
- CREATE TRIGGER
- CREATE TYPE
- CREATE USER
- CREATE USER MAPPING
- CREATE VIEW
- CURSOR
- DEALLOCATE
- DECLARE
- DELETE
- DO
- DROP CLIENT MASTER KEY
- DROP COLUMN ENCRYPTION KEY
- DROP DATABASE
- DROP DATA SOURCE
- DROP DIRECTORY
- DROP FOREIGN TABLE
- DROP FUNCTION
- DROP GROUP
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP OWNED
- DROP ROW LEVEL SECURITY POLICY
- DROP PROCEDURE
- DROP ROLE
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP SERVER
- DROP SYNONYM
- DROP TABLE
- DROP TABLESPACE
- DROP TEXT SEARCH CONFIGURATION
- DROP TEXT SEARCH DICTIONARY
- DROP TRIGGER
- DROP TYPE
- DROP USER
- DROP USER MAPPING
- DROP VIEW
- EXECUTE
- EXPLAIN
- EXPLAIN PLAN
- FETCH
- GRANT
- INSERT
- LOCK
- MOVE
- MERGE INTO
- PREPARE
- PREPARE TRANSACTION
- REASSIGN OWNED
- REFRESH MATERIALIZED VIEW
- REINDEX
- RELEASE SAVEPOINT
- RESET
- REVOKE
- ROLLBACK
- ROLLBACK PREPARED
- ROLLBACK TO SAVEPOINT
- SAVEPOINT
- SELECT
- SELECT INTO
- SET
- SET CONSTRAINTS
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SHOW
- SHUTDOW
- START TRANSACTION
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- GUC Parameters
- GUC Parameter Usage
- File Location
- Connection and Authentication
- Resource Consumption
- Parallel Import
- Write Ahead Log
- HA Replication
- Memory Table
- Query Planning
- Error Reporting and Logging
- Alarm Detection
- Statistics During the Database Running
- Load Management
- Automatic Vacuuming
- Default Settings of Client Connection
- Lock Management
- Version and Platform Compatibility
- Faut Tolerance
- Connection Pool Parameters
- MogDB Transaction
- Developer Options
- Auditing
- Upgrade Parameters
- Miscellaneous Parameters
- Wait Events
- Query
- System Performance Snapshot
- Equality Query in a Fully-encrypted Database
- Global Temporary Table
- Appendix
- DBE_PERF
- DBE_PERF Overview
- OS
- Instance
- Memory
- File
- Object
- STAT_USER_TABLES
- SUMMARY_STAT_USER_TABLES
- GLOBAL_STAT_USER_TABLES
- STAT_USER_INDEXES
- SUMMARY_STAT_USER_INDEXES
- GLOBAL_STAT_USER_INDEXES
- STAT_SYS_TABLES
- SUMMARY_STAT_SYS_TABLES
- GLOBAL_STAT_SYS_TABLES
- STAT_SYS_INDEXES
- SUMMARY_STAT_SYS_INDEXES
- GLOBAL_STAT_SYS_INDEXES
- STAT_ALL_TABLES
- SUMMARY_STAT_ALL_TABLES
- GLOBAL_STAT_ALL_TABLES
- STAT_ALL_INDEXES
- SUMMARY_STAT_ALL_INDEXES
- GLOBAL_STAT_ALL_INDEXES
- STAT_DATABASE
- SUMMARY_STAT_DATABASE
- GLOBAL_STAT_DATABASE
- STAT_DATABASE_CONFLICTS
- SUMMARY_STAT_DATABASE_CONFLICTS
- GLOBAL_STAT_DATABASE_CONFLICTS
- STAT_XACT_ALL_TABLES
- SUMMARY_STAT_XACT_ALL_TABLES
- GLOBAL_STAT_XACT_ALL_TABLES
- STAT_XACT_SYS_TABLES
- SUMMARY_STAT_XACT_SYS_TABLES
- GLOBAL_STAT_XACT_SYS_TABLES
- STAT_XACT_USER_TABLES
- SUMMARY_STAT_XACT_USER_TABLES
- GLOBAL_STAT_XACT_USER_TABLES
- STAT_XACT_USER_FUNCTIONS
- SUMMARY_STAT_XACT_USER_FUNCTIONS
- GLOBAL_STAT_XACT_USER_FUNCTIONS
- STAT_BAD_BLOCK
- SUMMARY_STAT_BAD_BLOCK
- GLOBAL_STAT_BAD_BLOCK
- STAT_USER_FUNCTIONS
- SUMMARY_STAT_USER_FUNCTIONS
- GLOBAL_STAT_USER_FUNCTIONS
- Workload
- Session/Thread
- SESSION_STAT
- GLOBAL_SESSION_STAT
- SESSION_TIME
- GLOBAL_SESSION_TIME
- SESSION_MEMORY
- GLOBAL_SESSION_MEMORY
- SESSION_MEMORY_DETAIL
- GLOBAL_SESSION_MEMORY_DETAIL
- SESSION_STAT_ACTIVITY
- GLOBAL_SESSION_STAT_ACTIVITY
- THREAD_WAIT_STATUS
- GLOBAL_THREAD_WAIT_STATUS
- LOCAL_THREADPOOL_STATUS
- GLOBAL_THREADPOOL_STATUS
- SESSION_CPU_RUNTIME
- SESSION_MEMORY_RUNTIME
- STATEMENT_IOSTAT_COMPLEX_RUNTIME
- Transaction
- Query
- STATEMENT
- SUMMARY_STATEMENT
- STATEMENT_COUNT
- GLOBAL_STATEMENT_COUNT
- SUMMARY_STATEMENT_COUNT
- GLOBAL_STATEMENT_COMPLEX_HISTORY
- GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
- GLOBAL_STATEMENT_COMPLEX_RUNTIME
- STATEMENT_RESPONSETIME_PERCENTILE
- STATEMENT_USER_COMPLEX_HISTORY
- STATEMENT_COMPLEX_RUNTIME
- STATEMENT_COMPLEX_HISTORY_TABLE
- STATEMENT_COMPLEX_HISTORY
- STATEMENT_WLMSTAT_COMPLEX_RUNTIME
- STATEMENT_HISTORY
- Cache/IO
- STATIO_USER_TABLES
- SUMMARY_STATIO_USER_TABLES
- GLOBAL_STATIO_USER_TABLES
- STATIO_USER_INDEXES
- SUMMARY_STATIO_USER_INDEXES
- GLOBAL_STATIO_USER_INDEXES
- STATIO_USER_SEQUENCES
- SUMMARY_STATIO_USER_SEQUENCES
- GLOBAL_STATIO_USER_SEQUENCES
- STATIO_SYS_TABLES
- SUMMARY_STATIO_SYS_TABLES
- GLOBAL_STATIO_SYS_TABLES
- STATIO_SYS_INDEXES
- SUMMARY_STATIO_SYS_INDEXES
- GLOBAL_STATIO_SYS_INDEXES
- STATIO_SYS_SEQUENCES
- SUMMARY_STATIO_SYS_SEQUENCES
- GLOBAL_STATIO_SYS_SEQUENCES
- STATIO_ALL_TABLES
- SUMMARY_STATIO_ALL_TABLES
- GLOBAL_STATIO_ALL_TABLES
- STATIO_ALL_INDEXES
- SUMMARY_STATIO_ALL_INDEXES
- GLOBAL_STATIO_ALL_INDEXES
- STATIO_ALL_SEQUENCES
- SUMMARY_STATIO_ALL_SEQUENCES
- GLOBAL_STATIO_ALL_SEQUENCES
- GLOBAL_STAT_DB_CU
- GLOBAL_STAT_SESSION_CU
- Utility
- REPLICATION_STAT
- GLOBAL_REPLICATION_STAT
- REPLICATION_SLOTS
- GLOBAL_REPLICATION_SLOTS
- BGWRITER_STAT
- GLOBAL_BGWRITER_STAT
- GLOBAL_CKPT_STATUS
- GLOBAL_DOUBLE_WRITE_STATUS
- GLOBAL_PAGEWRITER_STATUS
- GLOBAL_RECORD_RESET_TIME
- GLOBAL_REDO_STATUS
- GLOBAL_RECOVERY_STATUS
- CLASS_VITAL_INFO
- USER_LOGIN
- SUMMARY_USER_LOGIN
- GLOBAL_GET_BGWRITER_STATUS
- Lock
- Wait Events
- Configuration
- Operator
- Workload Manager
- Global Plancache
- Appendix
- Error Code Reference
- Description of SQL Error Codes
- Third-Party Library Error Codes
- GAUSS-00001 - GAUSS-00100
- GAUSS-00101 - GAUSS-00200
- GAUSS 00201 - GAUSS 00300
- GAUSS 00301 - GAUSS 00400
- GAUSS 00401 - GAUSS 00500
- GAUSS 00501 - GAUSS 00600
- GAUSS 00601 - GAUSS 00700
- GAUSS 00701 - GAUSS 00800
- GAUSS 00801 - GAUSS 00900
- GAUSS 00901 - GAUSS 01000
- GAUSS 01001 - GAUSS 01100
- GAUSS 01101 - GAUSS 01200
- GAUSS 01201 - GAUSS 01300
- GAUSS 01301 - GAUSS 01400
- GAUSS 01401 - GAUSS 01500
- GAUSS 01501 - GAUSS 01600
- GAUSS 01601 - GAUSS 01700
- GAUSS 01701 - GAUSS 01800
- GAUSS 01801 - GAUSS 01900
- GAUSS 01901 - GAUSS 02000
- GAUSS 02001 - GAUSS 02100
- GAUSS 02101 - GAUSS 02200
- GAUSS 02201 - GAUSS 02300
- GAUSS 02301 - GAUSS 02400
- GAUSS 02401 - GAUSS 02500
- GAUSS 02501 - GAUSS 02600
- GAUSS 02601 - GAUSS 02700
- GAUSS 02701 - GAUSS 02800
- GAUSS 02801 - GAUSS 02900
- GAUSS 02901 - GAUSS 03000
- GAUSS 03001 - GAUSS 03100
- GAUSS 03101 - GAUSS 03200
- GAUSS 03201 - GAUSS 03300
- GAUSS 03301 - GAUSS 03400
- GAUSS 03401 - GAUSS 03500
- GAUSS 03501 - GAUSS 03600
- GAUSS 03601 - GAUSS 03700
- GAUSS 03701 - GAUSS 03800
- GAUSS 03801 - GAUSS 03900
- GAUSS 03901 - GAUSS 04000
- GAUSS 04001 - GAUSS 04100
- GAUSS 04101 - GAUSS 04200
- GAUSS 04201 - GAUSS 04300
- GAUSS 04301 - GAUSS 04400
- GAUSS 04401 - GAUSS 04500
- GAUSS 04501 - GAUSS 04600
- GAUSS 04601 - GAUSS 04700
- GAUSS 04701 - GAUSS 04800
- GAUSS 04801 - GAUSS 04900
- GAUSS 04901 - GAUSS 05000
- GAUSS 05001 - GAUSS 05100
- GAUSS 05101 - GAUSS 05200
- GAUSS 05201 - GAUSS 05300
- GAUSS 05301 - GAUSS 05400
- GAUSS 05401 - GAUSS 05500
- GAUSS 05501 - GAUSS 05600
- GAUSS 05601 - GAUSS 05700
- GAUSS 05701 - GAUSS 05800
- GAUSS 05801 - GAUSS 05900
- GAUSS 05901 - GAUSS 06000
- GAUSS 06001 - GAUSS 06100
- GAUSS 06101 - GAUSS 06200
- GAUSS 06201 - GAUSS 06300
- GAUSS 06301 - GAUSS 06400
- GAUSS 06401 - GAUSS 06500
- GAUSS 06501 - GAUSS 06600
- GAUSS 06601 - GAUSS 06700
- GAUSS 06701 - GAUSS 06800
- GAUSS 06801 - GAUSS 06900
- GAUSS 06901 - GAUSS 07000
- GAUSS 07001 - GAUSS 07100
- GAUSS 07101 - GAUSS 07200
- GAUSS 07201 - GAUSS 07300
- GAUSS 07301 - GAUSS 07400
- GAUSS 07401 - GAUSS 07480
- GAUSS 50000 - GAUSS 50999
- GAUSS 51000 - GAUSS 51999
- GAUSS 52000 - GAUSS 52999
- GAUSS 53000 - GAUSS 53699
- System Catalogs and System Views
- Glossary
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.