- About MogDB
- Quick Start
- MogDB Playground
- Container-based MogDB Installation
- Installation on a Single Node
- MogDB Access
- Use CLI to Access MogDB
- Use GUI to Access MogDB
- Use Middleware to Access MogDB
- Use Programming Language to Access MogDB
- Using Sample Dataset Mogila
- Characteristic Description
- High Performance
- High Availability (HA)
- Maintainability
- Database Security
- Access Control Model
- Separation of Control and Access Permissions
- Database Encryption Authentication
- Data Encryption and Storage
- Database Audit
- Network Communication Security
- Resource Label
- Unified Audit
- Dynamic Data Anonymization
- Row-Level Access Control
- Password Strength Verification
- Equality Query in a Fully-encrypted Database
- Ledger Database Mechanism
- Enterprise-Level Features
- Support for Functions and Stored Procedures
- SQL Hints
- Full-Text Indexing
- Copy Interface for Error Tolerance
- Partitioning
- Support for Advanced Analysis Functions
- Materialized View
- HyperLogLog
- Creating an Index Online
- Autonomous Transaction
- Global Temporary Table
- Pseudocolumn ROWNUM
- Stored Procedure Debugging
- JDBC Client Load Balancing and Read/Write Isolation
- In-place Update Storage Engine
- Application Development Interfaces
- AI Capabilities
- Installation Guide
- Container Installation
- Simplified Installation Process
- Standard Installation
- Manual Installation
- Administrator Guide
- Routine Maintenance
- Starting and Stopping MogDB
- Using the gsql Client for Connection
- Routine Maintenance
- Checking OS Parameters
- Checking MogDB Health Status
- Checking Database Performance
- Checking and Deleting Logs
- Checking Time Consistency
- Checking The Number of Application Connections
- Routinely Maintaining Tables
- Routinely Recreating an Index
- Data Security Maintenance Suggestions
- Log Reference
- Primary and Standby 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
- Routine Maintenance
- AI Features Guide
- Overview
- Predictor: AI Query Time Forecasting
- X-Tuner: Parameter Optimization and Diagnosis
- SQLdiag: Slow SQL Discovery
- A-Detection: Status Monitoring
- Index-advisor: Index Recommendation
- DeepSQL
- AI-Native Database (DB4AI)
- Security Guide
- 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
- Managing Logs
- 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
- Example: Parameters for Connecting to the Database in Different Scenarios
- JDBC API Reference
- java.sql.Connection
- java.sql.CallableStatement
- java.sql.DatabaseMetaData
- java.sql.Driver
- java.sql.PreparedStatement
- java.sql.ResultSet
- java.sql.ResultSetMetaData
- java.sql.Statement
- javax.sql.ConnectionPoolDataSource
- javax.sql.DataSource
- javax.sql.PooledConnection
- javax.naming.Context
- javax.naming.spi.InitialContextFactory
- CopyManager
- Development Based on ODBC
- Development Based on libpq
- Development Based on libpq
- libpq API Reference
- Database Connection Control Functions
- Database Statement Execution Functions
- Functions for Asynchronous Command Processing
- Functions for Canceling Queries in Progress
- Example
- Connection Characters
- Psycopg-Based Development
- Commissioning
- Appendices
- Stored Procedure
- User Defined Functions
- PL/pgSQL-SQL Procedural Language
- Scheduled Jobs
- Autonomous Transaction
- Logical Replication
- Logical Decoding
- Foreign Data Wrapper
- Materialized View
- Materialized View Overview
- Full Materialized View
- Incremental Materialized View
- Resource Load Management
- Overview
- Resource Management Preparation
- Application Development Guide
- Performance Tuning Guide
- System Optimization
- SQL Optimization
- WDR Snapshot Schema
- TPCC Performance Tuning Guide
- Reference Guide
- System Catalogs and System Views
- Overview of System Catalogs and System Views
- System Catalogs
- GS_AUDITING_POLICY
- GS_AUDITING_POLICY_ACCESS
- GS_AUDITING_POLICY_FILTERS
- GS_AUDITING_POLICY_PRIVILEGES
- GS_CLIENT_GLOBAL_KEYS
- GS_CLIENT_GLOBAL_KEYS_ARGS
- GS_COLUMN_KEYS
- GS_COLUMN_KEYS_ARGS
- GS_ENCRYPTED_COLUMNS
- GS_ENCRYPTED_PROC
- GS_GLOBAL_CHAIN
- GS_MASKING_POLICY
- GS_MASKING_POLICY_ACTIONS
- GS_MASKING_POLICY_FILTERS
- GS_MATVIEW
- GS_MATVIEW_DEPENDENCY
- GS_OPT_MODEL
- GS_POLICY_LABEL
- GS_RECYCLEBIN
- GS_TXN_SNAPSHOT
- GS_WLM_INSTANCE_HISTORY
- GS_WLM_OPERATOR_INFO
- GS_WLM_PLAN_ENCODING_TABLE
- GS_WLM_PLAN_OPERATOR_INFO
- GS_WLM_EC_OPERATOR_INFO
- 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_SYNONYM
- 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
- GET_GLOBAL_PREPARED_XACTS
- GS_AUDITING
- GS_AUDITING_ACCESS
- GS_AUDITING_PRIVILEGE
- GS_CLUSTER_RESOURCE_INFO
- GS_INSTANCE_TIME
- GS_LABELS
- GS_MASKING
- GS_MATVIEWS
- GS_SESSION_MEMORY
- GS_SESSION_CPU_STATISTICS
- GS_SESSION_MEMORY_CONTEXT
- GS_SESSION_MEMORY_DETAIL
- GS_SESSION_MEMORY_STATISTICS
- GS_SQL_COUNT
- GS_WLM_CGROUP_INFO
- GS_WLM_PLAN_OPERATOR_HISTORY
- GS_WLM_REBUILD_USER_RESOURCE_POOL
- GS_WLM_RESOURCE_POOL
- GS_WLM_USER_INFO
- GS_STAT_SESSION_CU
- GS_TOTAL_MEMORY_DETAIL
- MPP_TABLES
- PG_AVAILABLE_EXTENSION_VERSIONS
- PG_AVAILABLE_EXTENSIONS
- PG_COMM_DELAY
- PG_COMM_RECV_STREAM
- PG_COMM_SEND_STREAM
- PG_COMM_STATUS
- PG_CONTROL_GROUP_CONFIG
- 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_NODE_ENV
- PG_OS_THREADS
- PG_PREPARED_STATEMENTS
- PG_PREPARED_XACTS
- PG_REPLICATION_SLOTS
- PG_RLSPOLICIES
- PG_ROLES
- PG_RULES
- PG_SECLABELS
- 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_TABLES
- PG_TDE_INFO
- PG_THREAD_WAIT_STATUS
- PG_TIMEZONE_ABBREVS
- PG_TIMEZONE_NAMES
- PG_TOTAL_MEMORY_DETAIL
- PG_TOTAL_USER_RESOURCE_INFO
- PG_TOTAL_USER_RESOURCE_INFO_OID
- PG_USER
- PG_USER_MAPPINGS
- PG_VARIABLE_INFO
- PG_VIEWS
- PLAN_TABLE
- GS_FILE_STAT
- GS_OS_RUN_INFO
- GS_REDO_STAT
- GS_SESSION_STAT
- GS_SESSION_TIME
- GS_THREAD_MEMORY_CONTEXT
- 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/JSONB Functions and Operators
- HLL Functions and Operators
- SEQUENCE Functions
- Array Functions and Operators
- Range Functions and Operators
- Aggregate Functions
- Window Functions
- Security Functions
- Ledger Database Functions
- Encrypted Equality Functions
- Set Returning Functions
- Conditional Expression Functions
- System Information Functions
- System Administration Functions
- Configuration Settings Functions
- Universal File Access Functions
- Server Signal Functions
- Backup and Restoration Control Functions
- Snapshot Synchronization Functions
- Database Object Functions
- Advisory Lock Functions
- Logical Replication Functions
- Segment-Page Storage Functions
- Other Functions
- Undo System Functions
- Statistics Information Functions
- Trigger Functions
- Hash Function
- Prompt Message Function
- Global Temporary Table Functions
- Fault Injection System Function
- AI Feature Functions
- Dynamic Data Masking Functions
- Other System Functions
- Internal Functions
- Obsolete Functions
- Supported Data Types
- Numeric Types
- Monetary Types
- Boolean Types
- Enumerated Types
- Character Types
- Binary Types
- Date/Time Types
- Geometric
- Network Address Types
- Bit String Types
- Text Search Types
- UUID
- JSON/JSONB Types
- HLL
- Array Types
- Range
- OID Types
- Pseudo-Types
- Data Types Supported by Column-store Tables
- XML Types
- Data Type Used by the Ledger Database
- SQL Syntax
- ABORT
- ALTER AGGREGATE
- ALTER AUDIT POLICY
- ALTER DATABASE
- ALTER DATA SOURCE
- ALTER DEFAULT PRIVILEGES
- ALTER DIRECTORY
- ALTER EXTENSION
- ALTER FOREIGN TABLE
- ALTER FUNCTION
- ALTER GROUP
- ALTER INDEX
- ALTER LANGUAGE
- ALTER LARGE OBJECT
- ALTER MASKING POLICY
- ALTER MATERIALIZED VIEW
- ALTER OPERATOR
- ALTER RESOURCE LABEL
- ALTER RESOURCE POOL
- 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 TABLE SUBPARTITION
- 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
- CLEAN CONNECTION
- CLOSE
- CLUSTER
- COMMENT
- COMMIT | END
- COMMIT PREPARED
- CONNECT BY
- COPY
- CREATE AGGREGATE
- CREATE AUDIT POLICY
- CREATE CAST
- CREATE CLIENT MASTER KEY
- CREATE COLUMN ENCRYPTION KEY
- CREATE DATABASE
- CREATE DATA SOURCE
- CREATE DIRECTORY
- CREATE EXTENSION
- CREATE FOREIGN TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INCREMENTAL MATERIALIZED VIEW
- CREATE INDEX
- CREATE LANGUAGE
- CREATE MASKING POLICY
- CREATE MATERIALIZED VIEW
- CREATE MODEL
- CREATE OPERATOR
- CREATE PACKAGE
- CREATE ROW LEVEL SECURITY POLICY
- CREATE PROCEDURE
- CREATE RESOURCE LABEL
- CREATE RESOURCE POOL
- CREATE ROLE
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SERVER
- CREATE SYNONYM
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLE PARTITION
- CREATE TABLE SUBPARTITION
- CREATE TABLESPACE
- CREATE TEXT SEARCH CONFIGURATION
- CREATE TEXT SEARCH DICTIONARY
- CREATE TRIGGER
- CREATE TYPE
- CREATE USER
- CREATE USER MAPPING
- CREATE VIEW
- CREATE WEAK PASSWORD DICTIONARY
- CURSOR
- DEALLOCATE
- DECLARE
- DELETE
- DO
- DROP AGGREGATE
- DROP AUDIT POLICY
- DROP CAST
- DROP CLIENT MASTER KEY
- DROP COLUMN ENCRYPTION KEY
- DROP DATABASE
- DROP DATA SOURCE
- DROP DIRECTORY
- DROP EXTENSION
- DROP FOREIGN TABLE
- DROP FUNCTION
- DROP GROUP
- DROP INDEX
- DROP LANGUAGE
- DROP MASKING POLICY
- DROP MATERIALIZED VIEW
- DROP MODEL
- DROP OPERATOR
- DROP OWNED
- DROP PACKAGE
- DROP PROCEDURE
- DROP RESOURCE LABEL
- DROP RESOURCE POOL
- DROP ROW LEVEL SECURITY POLICY
- 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
- DROP WEAK PASSWORD DICTIONARY
- EXECUTE
- EXECUTE DIRECT
- EXPLAIN
- EXPLAIN PLAN
- FETCH
- GRANT
- INSERT
- LOCK
- MOVE
- MERGE INTO
- PREDICT BY
- PREPARE
- PREPARE TRANSACTION
- PURGE
- REASSIGN OWNED
- REFRESH INCREMENTAL MATERIALIZED VIEW
- 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
- SHUTDOWN
- SNAPSHOT
- START TRANSACTION
- TIMECAPSULE TABLE
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- SQL Reference
- MogDB SQL
- Keywords
- Constant and Macro
- Expressions
- Type Conversion
- Full Text Search
- Introduction
- Tables and Indexes
- Controlling Text Search
- Additional Features
- Parser
- Dictionaries
- Configuration Examples
- Testing and Debugging Text Search
- Limitations
- System Operation
- Controlling Transactions
- DDL Syntax Overview
- DML Syntax Overview
- DCL Syntax Overview
- Appendix
- 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
- Security Configuration
- Global Temporary Table
- HyperLogLog
- Scheduled Task
- Thread Pool
- User-defined Functions
- Backup and Restoration
- Undo
- DCF Parameters Settings
- Flashback
- Rollback Parameters
- Reserved Parameters
- AI Features
- Appendix
- Schema
- Information Schema
- 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
- LOCAL_ACTIVE_SESSION
- 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
- GLOBAL_SINGLE_FLUSH_DW_STATUS
- GLOBAL_CANDIDATE_STATUS
- Lock
- Wait Events
- Configuration
- Operator
- Workload Manager
- Global Plancache
- RTO
- Appendix
- DBE_PLDEBUGGER Schema
- Overview
- DBE_PLDEBUGGER.turn_on
- DBE_PLDEBUGGER.turn_off
- DBE_PLDEBUGGER.local_debug_server_info
- DBE_PLDEBUGGER.attach
- DBE_PLDEBUGGER.next
- DBE_PLDEBUGGER.continue
- DBE_PLDEBUGGER.abort
- DBE_PLDEBUGGER.print_var
- DBE_PLDEBUGGER.info_code
- DBE_PLDEBUGGER.step
- DBE_PLDEBUGGER.add_breakpoint
- DBE_PLDEBUGGER.delete_breakpoint
- DBE_PLDEBUGGER.info_breakpoints
- DBE_PLDEBUGGER.backtrace
- DBE_PLDEBUGGER.finish
- DBE_PLDEBUGGER.set_var
- DB4AI Schema
- Tool Reference
- Tool Overview
- Client Tool
- Server Tools
- Tools Used in the Internal System
- gaussdb
- gs_backup
- gs_basebackup
- gs_ctl
- gs_initdb
- gs_install
- gs_install_plugin
- gs_install_plugin_local
- gs_postuninstall
- gs_preinstall
- gs_sshexkey
- gs_tar
- gs_uninstall
- gs_upgradectl
- gs_expansion
- gs_dropnode
- gs_probackup
- gstrace
- kdb5_util
- kadmin.local
- kinit
- klist
- krb5kdc
- kdestroy
- pg_config
- pg_controldata
- pg_recvlogical
- pg_resetxlog
- pg_archivecleanup
- pssh
- pscp
- transfer.py
- FAQ
- System Catalogs and Views Supported by gs_collector
- Extension Reference
- 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
- Error Log Reference
- System Catalogs and System Views
- Common Faults and Identification Guide
- Common Fault Locating Methods
- Common Fault Locating Cases
- Core Fault Locating
- Permission/Session/Data Type Fault Location
- Service/High Availability/Concurrency Fault Location
- Table/Partition Table Fault Location
- File System/Disk/Memory Fault Location
- 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
- Insufficient Memory
- "Error:No space left on device" Is Displayed
- When the TPC-C is running and a disk to be injected is full, the TPC-C stops responding
- Disk Space Usage Reaches the Threshold and the Database Becomes Read-only
- SQL Fault Location
- Index Fault Location
- Source Code Parsing
- FAQs
- Glossary
GAUSS-04201 - GAUSS-04300
GAUSS-04201 - GAUSS-04210
GAUSS-04201: "unsupported portal strategy"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04202: "bogus direction"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04203: "invalid argument size %d in function call message"
SQLSTATE: 08P01
Description: An invalid parameter value (argsize is less than -1) is entered when the function is called.
Solution: Check the number of parameters called by the function.
GAUSS-04204: "function %s has more than %d arguments"
SQLSTATE: XX000
Description: The SQL parameter is incorrect.
Solution: Modify the SQL statement.
GAUSS-04205: "current transaction is aborted, commands ignored until end of transaction block"
SQLSTATE: 25P02
Description: Non-commit and rollback commands are run when the transaction is rolled back.
Solution: Ensure that the previous transaction has been submitted or rolled back when the SQL statement is executed.
GAUSS-04206: "function call message contains %d arguments but function requires %d"
SQLSTATE: 08P01
Description: When the function is called, the number of parameters entered is inconsistent with that defined by the function.
Solution: Check the number of parameters called by the function.
GAUSS-04207: "function call message contains %d argument formats but %d arguments"
SQLSTATE: 08P01
Description: When the function is called, the number of formatted parameters entered is inconsistent with that defined by the function.
Solution: Check the number of parameters called by the function.
GAUSS-04208: "incorrect binary data format in function argument %d"
SQLSTATE: 22P03
Description: Incorrect binary data format is found in the parameters of the function.
Solution: Check the format of parameters called by the function.
GAUSS-04209: "invalid frontend message type %d"
SQLSTATE: 08P01
Description: The message type is invalid.
Solution: Ensure that the input message type is valid.
GAUSS-04210: "could not set timer for session timeout"
SQLSTATE: 58000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04211 - GAUSS-04220
GAUSS-04211: "could not disable timer for session timeout"
SQLSTATE: 58000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04214: "bind message has %d parameter formats but %d parameters"
SQLSTATE: 08P01
Description: The number of bound parameters is inconsistent with the number of accepted parameters when the API is used.
Solution: Ensure that the number of accepted parameters is consistent with the number of predicted parameters.
GAUSS-04215: "cannot insert multiple commands into a prepared statement"
SQLSTATE: 42601
Description: Multiple commands are inserted in the prepared statement.
Solution: Insert only one command.
GAUSS-04217: "bind message supplies %d parameters, but prepared statement '%s' requires %d"
SQLSTATE: 08P01
Description: The number of parameters provided by the bind message is incorrect.
Solution: Provide the correct parameter.
GAUSS-04218: "incorrect binary data format in bind parameter %d"
SQLSTATE: 22P03
Description: Incorrect binary data is found in the bind parameter.
Solution: Provide the correct parameter.
GAUSS-04219: "portal '%s' does not exist"
SQLSTATE: 34000
Description: The portal does not exist.
Solution: Specify a correct portal name.
GAUSS-04220: "floating-point exception"
SQLSTATE: 22P01
Description: The floating point number is incorrect. For example, the value is out of range or divided by 0.
Solution: Enter a valid floating point number.
GAUSS-04221 - GAUSS-04230
GAUSS-04221: "unrecognized conflict mode: %d"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04222: "terminating autovacuum process due to administrator command"
SQLSTATE: 57P01
Description: The autovacuum process is terminated by the administrator.
Solution: Contact the system administrator to check whether the autovacuum process is terminated. Let the administrator to restart the process if it has been terminated.
GAUSS-04223: "terminating connection due to conflict with recovery"
SQLSTATE: 40001
Description: The current request conflicts with the data recovery process performed on the database server. The requested connection fails.
Solution: Try to reconnect the database later and run the command again.
GAUSS-04224: "terminating connection due to conflict with recovery"
SQLSTATE: 57P04
Description: The current request conflicts with the data recovery process performed on the database server. The requested connection fails.
Solution: Try to reconnect the database later and run the command again.
GAUSS-04225: "terminating connection due to administrator command"
SQLSTATE: 57P01
Description: The administrator terminates the current connection.
Solution: Contact the system administrator to obtain the reason why the connection is terminated.
GAUSS-04226: "connection to client lost"
SQLSTATE: 08006
Description: The connection is lost.
Solution: Check whether the network connection is normal.
GAUSS-04229: "canceling autovacuum task"
SQLSTATE: 57014
Description: The autovauum task is cancelled.
Solution: Find the reason why the process is cancelled.
GAUSS-04230: "canceling statement due to conflict with recovery"
SQLSTATE: 40001
Description: The connection is cancelled due to the conflict with recovery.
Solution: Reconnect to the database and enter the command again.
GAUSS-04231 - GAUSS-04240
GAUSS-04231: "canceling statement due to %s request"
SQLSTATE: 57014
Description: The user or a CN cancels this operation.
Solution: Ensure that the reason to cancel the operation is valid. If the operation needs to be canceled, ignore the error. If the operation cancellation is abnormal, analyze the error and rectify it.
GAUSS-04232: "stack depth limit exceeded"
SQLSTATE: 54001
Description: The stack depth exceeds the upper limit, that is, the value of max_stack_depth_bytes (the default value is 100x1024).
Solution: Ensure that the depth of the recursive call function is proper. If the depth is out of limit, expand max_stack_depth_bytes.
GAUSS-04233: "local xids can be used only in single user mode"
SQLSTATE: 42601
Description: The local XID can be used only in single-user mode.
Solution: The -single parameter needs to be added.
GAUSS-04235: "invalid command-line argument for server process: %s"
SQLSTATE: 42601
Description: An invalid command-line parameter is entered for the server process.
Solution: Use -help to check the parameter function and enter the correct parameter.
GAUSS-04236: "%s: invalid command-line argument: %s"
SQLSTATE: 42601
Description: An invalid command-line parameter is entered when the database is being connected.
Solution: Use -help to check the parameter function and enter the correct parameter.
GAUSS-04238: "%s: no database nor user name specified"
SQLSTATE: 22023
Description: Neither the database nor the username is specified when the database is being connected.
Solution: Add the database and username parameter.
GAUSS-04239: "invalid CLOSE message subtype %d"
SQLSTATE: 08P01
Description: An invalid CLOSE command is entered in the front end or the standard input.
Solution: Ensure the type of CLOSE is S or P.
GAUSS-04240: "invalid DESCRIBE message subtype %d"
SQLSTATE: 08P01
Description: An invalid DESCRIBE command is entered in the front end or the standard input.
Solution: Ensure the type of DESCRIBE is S or P.
GAUSS-04241 - GAUSS-04250
GAUSS-04241: "Invalid command received"
SQLSTATE: XX000
Description: An invalid command capitalized with b (not bP, bX, or bE) is entered in the front end or the standard input.
Solution: Enter the correct command.
GAUSS-04242: "cannot execute %s in a read-only transaction"
SQLSTATE: 25006
Description: The update database type operation is performed in a read-only transaction.
Solution: Ensure that the update type operation is performed in non-read-only transactions.
GAUSS-04243: "cannot execute %s during recovery"
SQLSTATE: 25006
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04244: "cannot execute %s within security-restricted operation"
SQLSTATE: 42501
Description: Security-restricted operations are executed.
Solution:Contact technical support.
GAUSS-04245: "Invalid transaciton_id to prepare."
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04247: "non-DECLARE CURSOR PlannedStmt passed to ProcessUtility"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04248: "CREATE not supported for TEMP and non-TEMP objects"
SQLSTATE: 0A000
Description: A statement is used for supporting both temporary and non-temporary objects.
Solution: Change the SQL statement and use multiple statements to support temporary and non-temporary objects.
GAUSS-04249: "Postgres-XC does not support FOREIGN DATA WRAPPER yet"
SQLSTATE: 0A000
Description: The FOREIGN DATA WRAPPER is not supported.
Solution: Internal system error.Contact technical support.
GAUSS-04250: "Postgres-XC does not support USER MAPPING yet"
SQLSTATE: 0A000
Description: The CREATE USER MAPPING is not supported.
Solution: Do not use CREATE USER MAPPING.
GAUSS-04251 - GAUSS-04260
GAUSS-04251: "PGXC does not support concurrent INDEX yet"
SQLSTATE: 0A000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04253: "unrecognized alter domain type: %d"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04254: "PGXC does not support GRANT on multiple object types"
SQLSTATE: 0A000
Description: The MogDB GRANT syntax does not support performing the view and table operations at the same time.
Solution: Specify only one type of objects (table or view) at a time.
GAUSS-04255: "unrecognized define stmt type: %d"
SQLSTATE: XX000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04257: "DROP not supported for TEMP and non-TEMP objects"
SQLSTATE: 0A000
Description: The DROP statement cannot drop temporary and non-temporary objects at the same time.
Solution: Drop temporary objects and non-temporary objects respectively.
GAUSS-04258: "%s is not yet supported."
SQLSTATE: 0A000
Description: The features in the blacklist are not supported when the support_extended_features switch is set to off.
Solution: Set the support_extended_features switch to on and do not perform the alter or delete operation on the objects in the blacklist.
GAUSS-04260: "Failed to send snapshot to Datanode %u"
SQLSTATE: XX000
Description: Internal system error. Failed to send the snapshot to the DN.
Solution: Internal system error. Contact technical support.
GAUSS-04261 - GAUSS-04270
GAUSS-04261: "Failed to send queryid to Datanode %u"
SQLSTATE: XX000
Description: Communication error.
Solution: Check the network status or whether any node fault occurs.
GAUSS-04265: "delete or update failed because lock conflict"
SQLSTATE: XX000
Description: The deletion and update conditions are complex. As a result, the two rows in the same CU are deleted or updated with a long interval, and a lock conflict occurs while a tuple is deleted or updated.
Solution: Modify the deletion and update conditions to simplify execution.
GAUSS-04266: "delete or update row conflict"
SQLSTATE: XX000
Description: Data is deleted or updated multiple times.
Solution: Ensure that no row is deleted or updated multiple times.
GAUSS-04267: "GiST page split into too many halves (%d, maximum %d)"
SQLSTATE: XX000
Description: Internal system error.
Solution:Contact technical support.
GAUSS-04270: "PER NODE REJECT LIMIT must be greater than 0"
SQLSTATE: 42601
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04271 - GAUSS-04280
GAUSS-04271: "Invalid name '%s' in REMOTE LOG"
SQLSTATE: 42601
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04272: "PER NODE REJECT LIMIT only available on READ ONLY foreign table"
SQLSTATE: 42601
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04273: "PER NODE REJECT LIMIT only available with LOG INTO or REMOTE LOG"
SQLSTATE: 42601
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04275: "REMOTE LOG only available on in NORMAL mode"
SQLSTATE: 42601
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04276: "FILL_MISSING_FIELDS only available on READ ONLY foreign table"
SQLSTATE: 42601
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04277: "MODE only available on READ ONLY foreign table"
SQLSTATE: 42601
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04279: "can not specify relative local locations"
SQLSTATE: 0A000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04280: "could not fetch expected length:%m"
SQLSTATE: XX000
Description: An error occurs when error data is recorded in the error table.
Solution: Locate the data row where the error occurred based on the error context and check whether invalid characters exist. Contact technical support.
GAUSS-04281 - GAUSS-04290
GAUSS-04283: "pg_largeobject entry for OID %u, page %d has invalid data field size %d"
SQLSTATE: XX001
Description: The length of the fragment of a large object is invalid and the data is damaged.
Solution: Contact technical support. Alternatively, try using backup data to restore the data.
GAUSS-04284: "exceeded maxAllocatedDescs (%d) while trying to open file '%s:%d'"
SQLSTATE: 53000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04285: "exceeded maxAllocatedDescs (%d) while trying to open file '%s'"
SQLSTATE: 53000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04286: "exceeded maxAllocatedDescs (%d) while trying to open directory '%s'"
SQLSTATE: 53000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04287: "must have at least one column"
SQLSTATE: 0A000
Description: The CREATE TABLE syntax does not specify the column information of the table.
Solution: Ensure that at least one column is specified in the CREATE TABLE table_name*({column_name data_type}*) syntax.
GAUSS-04290: "length of field '%s' longer than limit of '%d'"
SQLSTATE: 22P04
Description: The length of the column in a GDS foreign table exported in FIXED format is greater than the declared table length.
Solution: Modify the foreign table definition based on the error message.
GAUSS-04291 - GAUSS-04300
GAUSS-04291: "tsquery is too large"
SQLSTATE: 54000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04292: "bit string length exceeds the maximum allowed (%d)"
SQLSTATE: 54000
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04293: "language validation function %u called for language %u instead of %u"
SQLSTATE: 42501
Description:Internal system error.
Solution:Contact technical support.
GAUSS-04294:"The name of memory context is too long(>=%dbytes)"
SQLSTATE: 42602
Description: The name of the memory context exceeds the limit MEMORY_CONTEXT_NAME_LEN.
Solution: Ensure that the memory context is valid.
GAUSS-04295:"Fail to send signal to backend(tid:%lu). "
SQLSTATE: XX000
Description: Failed to send an internal signal to the backend thread.
Solution: The backend may have exited. Let the user check whether the backend exists.
GAUSS-04296:"out of memory when preparing zlib encoder. "
SQLSTATE: 53200
Description: Failed to allocate a large volume of memory required for compression because the system memory is insufficient.
Solution: Release unnecessary processes in the system and import data again.
GAUSS-04297:"level %d is invalid when preparing zlib encoder. "
SQLSTATE: XX000
Description: The zlib compression level is incorrect.
Solution: Use the low or middle compression level during the import.
GAUSS-04298: "version is incompatible when preparing zlib encoder."
SQLSTATE: XX000
Description: Internal system error.
Solution:Contact technical support.
GAUSS-04299:"error %d occurs when preparing zlib encoder. "
SQLSTATE: XX000
Description: System resources are insufficient.
Solution: Release unnecessary memory in the system and import data again.
GAUSS-04300:"RLE decompress failed, expected bytes %d, real size %d "
SQLSTATE: XX001
Description: The data is damaged.
Solution: Use backed up data for restoration.