- 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-51000 - GAUSS-51999
GAUSS-51000 - GAUSS-51099
GAUSS-51000: "THP services must be shut down."
SQLSTATE: None
Description: The THP service is not disabled.
Solution: Disable the THP service.
GAUSS-51001: "Failed to obtain THP service."
SQLSTATE: None
Description: Failed to obtain THP service information.
Solution: Check whether the THP file exists.
GAUSS-51002: "Failed to close THP service."
SQLSTATE: None
Description: Failed to disable the THP service.
Solution: Check whether the THP file exists.
GAUSS-51100 - GAUSS-51199
GAUSS-51100: "Failed to verify SSH trust on these nodes: %s."
SQLSTATE: None
Description: Failed to verify the SSH mutual trust on each node.
Solution: Verify that the mutual trust between nodes is built.
GAUSS-51101: "SSH exception: \n%s"
SQLSTATE: None
Description: The remote connection is abnormal.
Solution: Ensure that the network connection is normal and that the remote server IP address, login username, and password are correct.
GAUSS-51102:"Failed to exchange SSH keys for user [%s] performing the %s operation."
SQLSTATE: None
Description: Failed to exchange the trust key.
Solution: Verify that the network connection is normal and the server IP address configuration is correct.
GAUSS-51103: "Failed to execute the PSSH command [%s]."
SQLSTATE: None
Description: Failed to run the PSSH command.
Solution: Verify that the PSSH tool is complete and the executed command is correct.
GAUSS-51104: "Failed to obtain SSH status."
SQLSTATE: None
Description: Failed to obtain the SSH status and result.
Solution: Verify that the network connection is normal and the connected server exists.
GAUSS-51105: "Failed to parse SSH output: %s."
SQLSTATE: None
Description: Failed to analyze the SSH result.
Solution: Verify that the SSH tool is complete and the parsed command is correct.
GAUSS-51106: "The SSH tool does not exist."
SQLSTATE: None
Description: The SSH tool does not exist.
Solution: Verify that the SSH tool exists.
GAUSS-51107: "Ssh Paramiko failed."
SQLSTATE: None
Description: The Paramiko mutual trust failed.
Solution:
- Check whether the network connection is normal.
- Check whether the Paramiko package exists.
- Check the following options in the /etc/ssh/sshd_config file:
- PasswordAuthentication=yes;
- MaxStartups=1000;
- UseDNS=no;
- ClientAliveInterval is greater than 10800 or equal to 0.
- Check whether the value of MaxSessions is too small when there are a large number of hosts in the cluster.
- After the modification is complete, restart the sshd service.
GAUSS-51108: "Ssh-keygen failed."
SQLSTATE: None
Description: Failed to run the Ssh-keygen command.
Solution: Verify that the ssh-keygen tool exists and that the network is normal.
GAUSS-51109: "Failed to check authentication."
SQLSTATE: None
Description: Identity authentication failed.
Solution: View the logs and check the cause of the identity authentication failure. Then, try the authentication again.
GAUSS-51110: "Failed to obtain RSA host key for local host."
SQLSTATE: None
Description: Failed to obtain the RSA host key of the local host.
Solution: Check the cause of the failure and try again.
GAUSS-51111: "Failed to append local ID to authorized_keys on remote node."
SQLSTATE: None
Description: Failed to add the local ID to the authorized_keys of the remote node.
Solution: Check the cause of the failure and try again.
GAUSS-51112: "Failed to exchange SSH keys for user[%s] using hostname."
SQLSTATE: None
Description: Failed to exchange the user name using the SSH private key.
Solution: Check whether the network is normal.
GAUSS-51200 - GAUSS-51299
GAUSS-51200: "The parameter [%s] in the XML file does not exist."
SQLSTATE: None
Description: Failed to find the %s parameter in the XML.
Solution: Check the configuration parameters in the XML.
GAUSS-51201: "Node names must be configured."
SQLSTATE: None
Description: The node name needs to be configured.
Solution: Configure the node name for the node.
GAUSS-51202: "Failed to add the %s instance."
SQLSTATE: None
Description: Failed to add the instance.
Solution: Ensure that the instance exists and the configuration is correct.
GAUSS-51203: "Failed to obtain the %s information from static configuration files."
SQLSTATE: None
Description: Failed to obtain the cluster information from the static configuration file.
Solution: Ensure that the static configuration file exists, that you have the access permission, and that the system is normal.
GAUSS-51204: " Invalid %s instance type: %d."
SQLSTATE: None
Description: The instance type is invalid.
Solution: Check and modify the instance type to be a valid one.
GAUSS-51205: "Failed to refresh the %s instance ID."
SQLSTATE: None
Description: Failed to update the instance ID.
Solution: Check whether the static configuration file of the current cluster exists or whether it has been broken, and check whether the user has the access permission. Update the CN ID of the new cluster based on this file.
GAUSS-51206: "The MPPRC file path must be an absolute path: %s."
SQLSTATE: None
Description: The MPPRC path must be an absolute path.
Solution: Change the MPPRC path to an absolute path.
GAUSS-51207: "Failed to obtain backIp from node [%s]."
SQLSTATE: None
Description: Failed to obtain the alternate IP address on the node.
Solution: Check and correctly configure the alternate IP address on the node.
GAUSS-51208: "Invalid %s number [%d]."
SQLSTATE: None
Description: The quantity is invalid.
Solution: Ensure that the quantity is valid.
GAUSS-51209: "Failed to obtain %s configuration on the host [%s]."
SQLSTATE: None
Description: Failed to obtain the configuration on this node.
Solution: Ensure that the configuration is correct on the node.
GAUSS-51210: "The obtained number does not match the instance number."
SQLSTATE: None
Description: The number of instances obtained does not match the actual instance number.
Solution: Check and modify the obtained number to match the actual instance number.
GAUSS-51211: "Failed to save a static configuration file."
SQLSTATE: None
Description: Failed to save the static configuration file.
Solution: Ensure that the static configuration file exists, that you have the access permission, and that the system is normal.
GAUSS-51212: "There is no information about %s."
SQLSTATE: None
Description: There is no information about %s.
Solution: Configure corresponding information for %s.
GAUSS-51213: "The port number of XML [%s] conflicted."
SQLSTATE: None
Description: The port number is occupied.
Solution: Check whether the occupied port process is available. If the process is unavailable, kill it, or change a new port number.
GAUSS-51214: "The number of capacity expansion DN nodes cannot be less than three or CN nodes cannot be less than one."
SQLSTATE: None
Description: The number of nodes before scale-out cannot be less than three.
Solution: Ensure that the number of nodes before scale-out is greater than or equal to three.
GAUSS-51215 : "The capacity expansion node [%s] cannot contain GTM/CM/ETCD."
SQLSTATE: None
Description: The GTM, CM, and ETCD cannot be contained on the scale-out node.
Solution: Delete the GTM, CM, and ETCD on the scale-out node.
GAUSS-51216: "The capacity expansion node [%s] must contain CN or DN."
SQLSTATE: None
Description: The node to be added to the cluster for scale-out does not have any CN or DN.
Solution: Add CN or DN on the scale-out node.
GAUSS-51217: "The cluster's static configuration does not match the new configuration file."
SQLSTATE: None
Description: The cluster's static configuration is inconsistent with the new configuration.
Solution: Modify the new XML configuration file, leaving it consistent with the cluster static configuration.
GAUSS-51218: "Failed to obtain initialized configuration parameter: %s."
SQLSTATE: None
Description: Failed to obtain the initialization configuration parameters.
Solution: Try to obtain the parameters again.
GAUSS-51219: "There is no CN in cluster."
SQLSTATE: None
Description: The CN is not installed in the cluster.
Solution: Reconfigure the XML file and execute the preparation and installation operations.
GAUSS-51220: "The IP address %s is incorrect."
SQLSTATE: None
Description: The IP address is incorrect.
Solution: Check whether the IP address configured in the XML file is correct.
GAUSS-51221: "Failed to configure hosts mapping information."
SQLSTATE: None
Description: Failed to configure the host mapping.
Solution: Check whether the /etc/hosts file exists and whether the host name and IP address configured in the file are consistent.
GAUSS-51222: "Failed to check hostname mapping."
SQLSTATE: None
Description: Failed to check the host mapping.
Solution: Check whether the mutual trust between nodes is normal.
GAUSS-51223: "Failed to obtain network inet addr on the node(%s)."
SQLSTATE: None
Description: Failed to obtain the inet address from the node.
Solution: Run the ifconfig command in the root directory to manually check whether the inet address exists. If it does, try to obtain the address again.
GAUSS-51224: "The ip(%s) has been used on other nodes."
SQLSTATE: None
Description: The IP address has been used on another node.
Solution: Check whether the IP address on each node in the XML file conflicts with each other.
GAUSS-51225: "Failed to set virtual IP."
SQLSTATE: None
Description: Failed to configure the virtual IP address.
Solution: Check whether the virtual IP address is used.
GAUSS-51226: "Virtual IP(s) and Back IP(s) do not have the same network segment."
SQLSTATE: None
Description: The virtual IP address and alternate IP address are not in the same network segment.
Solution: Set the virtual IP address and alternate IP address in the XML file to be in the same network segment.
GAUSS-51227: "The number of %s on all nodes are different."
SQLSTATE: None
Description: The number of alternate IP addresses on all nodes is different from that of the SSH IP addresses.
Solution: Set the number of alternate IP addresses in the XML file to be the same as that of the SSH IP address.
GAUSS-51228: "The number %s does not match %s number."
SQLSTATE: None
Description: The two numbers are different.
Solution: Set the two numbers to be the same.
GAUSS-51229: "The DN listenIp(%s) is not in the virtualIp or backIp on the node(%s)."
SQLSTATE: None
Description: The listen IP address on the DN is not the virtual IP address or alternate IP address.
Solution: Change the listen IP address to the virtual IP address or alternate IP address in the XML file.
GAUSS-51230: "The number of %s must %s."
SQLSTATE: None
Description: The number of CM servers, GTMs, or ETCDs is incorrect.
Solution: Configure correct numbers for CM servers, GTMs, and ETCDs in the XML file.
GAUSS-51231: "Old nodes is less than 2."
SQLSTATE: None
Description: The number of old nodes is less than two.
Solution: Set the number of the configured nodes in the XML file to be greater than or equal to 3.
GAUSS-51232: "XML configuration and static configuration are the same."
SQLSTATE: None
Description: The XML configuration and static configuration files are the same.
Solution: Before the scale-out, scale-in, and CN management operations, ensure that the XML is different from that of the installed clusters.
GAUSS-51233: "The Port(%s) is invalid on the node(%s)."
SQLSTATE: None
Description: The port is invalid.
Solution: Check whether the port number configured in the XML file is correct.
GAUSS-51234 : "The configuration file [%s] contains parsing errors."
SQLSTATE: None
Description: The XML file is analyzed incorrectly.
Solution: Check whether the configuration file is broken. If the file has been broken, copy a file from another node. If the file has not been broken, reinstall the cluster.
GAUSS-51235: "Invalid directory [%s]."
SQLSTATE: None
Description: The directory is invalid.
Solution: Check whether the directory is correct.
GAUSS-51236: "Failed to parsing xml."
SQLSTATE: None
Description: Failed to parse the XML file.
Solution: Check whether the XML file is opened successfully.
GAUSS-51239: "Failed to parse json. gs_collect configuration file (%s) is invalid , check key in json file"
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51240: "gs_collect configuration file is invalid, TypeName or content must in config file."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51241: "The parameter %s(%s) formate is wrong, or value is less than 0."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51242: "gs_collect configuration file is invalid: %s, the key: (%s) is invalid."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51243: "content(%s) does not match the typename(%s) in gs_collect configuration file(%s)."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51244: "(%s) doesn't yet support."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51245: "There are duplicate key(%s)."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51246: "%s info only support one time collect."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51247: "These virtual IP(%s) are not accessible after configuring."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51248: "gs_collector does not support '%s' view collection. please check key in json file."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51300 - GAUSS-51399
GAUSS-51300: "Failed to execute SQL: %s."
SQLSTATE: None
Description: Failed to execute the SQL statement.
Solution: Ensure that the SQL statement is correct. Check whether the database status is normal. Check whether the user has the execution permission. Check whether the database object exists.
GAUSS-51301 : "Execute SQL time out. \nSql: %s."
SQLSTATE: None
Description: The execution of the SQL statement times out.
Solution: Ensure that the SQL statement is correct. Check whether the database status is normal. Check whether the user has the execution permission. Check whether the network is normal.
GAUSS-51302: "The table '%s.%s' does not exist or is private table!"
SQLSTATE: None
Description: The table does not exist or is a private table.
Solution: 1. Ensure that the table exists in the database. 2. If the table is a private table, use gs_dump to back up the table.
GAUSS-51303: "Query·'%s'·has·no·record!."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51304: "Query '%s' result '%s' is incorrect!."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51305: "The table '%s.%s' exists!"
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51400 - GAUSS-51499
GAUSS-51400: "Failed to execute the command: %s."
SQLSTATE: None
Description: Failed to run the command.
Solution: Check whether the command is correct and whether you have the permission to run the command.
GAUSS-51401: "Failed to do %s.sh."
SQLSTATE: None
Description: Failed to execute the shell script.
Solution: Check whether the command is correct and whether you have the permission to run the command. Ensure that the shell script exists.
GAUSS_50402: "The usage of INODE cannot be greater than %s."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51500 - GAUSS-51599
GAUSS-51500: "Failed to call the interface %s. Exception: %s."
SQLSTATE: None
Description: Failed to invoke the interface.
Solution: Check whether the network connection is normal, whether the path is correct, and whether the invoked interface is open.
GAUSS-51600 - GAUSS-51699
GAUSS-51600: "Failed to obtain the cluster status."
SQLSTATE: None
Description: Failed to obtain the cluster status.
Solution: Check whether the cluster has been set up. Check whether the created cluster is started as expected.
GAUSS-51601: "Failed to check %s status."
SQLSTATE: None
Description: Failed to check the cluster or local node status.
Solution: Check whether the cluster or local node status is normal.
GAUSS-51602: "The cluster status is Abnormal."
SQLSTATE: None
Description: The cluster status is abnormal.
Solution: Check whether the cluster status is not restored because the tool script command is not executed.
GAUSS-51603: "Failed to obtain peer %s instance."
SQLSTATE: None
Description: Failed to obtain the peer instance.
Solution: Ensure that the gtm.conf path exists if you want to obtain GTM. Check whether the configuration is correct.
GAUSS-51604: "There is no HA status for %s."
SQLSTATE: None
Description: No HA status is available in the instance.
Solution: Ensure that the cluster status and network connection are normal.
GAUSS-51605: "Failed to check whether the %s process exists."
SQLSTATE: None
Description: Failed to check whether the process exists.
Solution: Ensure that the user has the permission to check the process and that the process is correctly checked.
GAUSS-51606: "Failed to kill the %s process.
SQLSTATE: None
Description: Failed to kill the process.
Solution: Ensure that the user has the permission to kill the process and that the execution command is correct.
GAUSS-51607: "Failed to start %s."
Description: Failed to start the cluster, node, or instance.
Solution: Ensure that the network connection is normal and that the configuration file is correct.
GAUSS-51608: "Failed to lock cluster"
SQLSTATE: None
Description: Failed to lock the cluster.
Solution: Do not perform the closure or stop operations before the session is complete.
GAUSS-51609: "Failed to unlock cluster"
SQLSTATE: None
Description: Failed to unlock the cluster.
Solution: Do not perform the closure or stop operations before the session is complete.
GAUSS-51610: "Failed to stop %s."
SQLSTATE: None
Description: Failed to stop the cluster, node, or instance.
Solution: Ensure that the command is correctly executed and that the cluster, node, or instance is normal.
GAUSS-51611: "Failed to create %s instance."
SQLSTATE: None
Description: Failed to create the instance.
Solution: Check whether the CN in the XML file is correctly configured.
GAUSS-51612: "The instance IDs [%s] are not found in %s."
SQLSTATE: None
Description: The ID of an instance is not found in the node information.
Solution: Check whether the CN in the XML file is correctly configured when you add or delete the CN.
GAUSS-51613: "There is no instance in %s to be built."
SQLSTATE: None
Description: No instance needs to be created.
Solution: The XML file is incorrectly configured when the user manages the CN. No instance is configured on the new node in the XML file.
GAUSS-51614: "Received signal[%d]."
SQLSTATE: None
Description: Received the signal %d.
Solution: Try to receive the signal again.
GAUSS-51615: "Failed to initialize instance."
SQLSTATE: None
Description: Failed to initialize the instance.
Solution: Ensure that the gs_initdb or gs_initcm utility exists. Ensure that the gs_initdb or gs_initcm command is correct. Ensure that the cluster, node, or instance is normal.
GAUSS-51616: "Failed to dump %s schema."
SQLSTATE: None
Description: Failed to dump the CN or DN schema.
Solution: Ensure that the dumpall or dump tool exists. Ensure that the dumpall or dump command is correctly executed. Ensure that the cluster, node, or instance is normal.
GAUSS-51617: "Failed to rebuild %s."
SQLSTATE: None
Description: Failed to rebuild.
Solution: Run the command again.
GAUSS-51618: "Failed to get all hostname."
SQLSTATE: None
Description: Failed to obtain all the host names.
Solution: Ensure that the SSH mutual trust is normal.
GAUSS-51619: "The host·name [%s] is not in the cluster."
SQLSTATE: None
Description: The current node is not in the cluster.
Solution: Check whether the node is configured in the XML file.
GAUSS-51620: "Failed to obtain %s instance information."
SQLSTATE: None
Description: Failed to obtain the instance information.
Solution: Ensure that the XML file is correctly configured and that the cluster, host, or instance is normal.
GAUSS-51621: "HA IP is empty."
SQLSTATE: None
Description: The HA IP address is empty.
Solution: Check the configuration information in the XML file. If the HA IP address is configured in the XML file, you need to ensure that the value is correctly configured. If the HA IP address is not configured in the XML file, the alternate IP address will be used by default, and you need to ensure that the alternate IP address is correctly configured in the XML file.
GAUSS-51622: "There is no %s on %s node."
SQLSTATE: None
Description: No CN/DN instance exists on the node.
Solution: Check whether the CN or DN instance is configured on the node in the XML file. Ensure that the current cluster, host, or instance is normal.
GAUSS-51623: "Failed to obtain version."
SQLSTATE: None
Description: Failed to obtain the cluster version.
Solution: Ensure that the version.cfg file exists. Check whether the data format of the version.cfg file is correct. Check whether the current cluster, host, or instance is normal.
GAUSS-51624: "Failed to get CN connections."
SQLSTATE: None
Description: Failed to obtain the number of CN connections.
Solution: Ensure that the cluster, node, and instance are running properly.
GAUSS-51625: "Cluster is running."
SQLSTATE: None
Description: The cluster is running.
Solution: Stop this cluster.
GAUSS-51626: "Failed to rollback."
SQLSTATE: None
Description: Failed to roll back.
Solution: Ensure that the command is correctly executed. Ensure that the current cluster, host, or instance is normal. View the corresponding log information.
GAUSS-51627: "Configuration failed."
SQLSTATE: None
Description: Configuration failed.
Solution: Perform the configuration again.
GAUSS-51628: "The version number of new cluster is [%s]. It should be float."
SQLSTATE: None
Description: The version number format of the new cluster is incorrect.
Solution: Ensure that the version.cfg file exists. Check whether the data format of the version.cfg file is correct. Check whether the current cluster, host, or instance is normal.
GAUSS-51629: "The version number of new cluster is [%s]. It should be greater than or equal to the old version."
SQLSTATE: None
Description: The version number of the new cluster is incorrect. It should be later than or equal to the old version number.
Solution: Ensure that the version.cfg file exists. Check whether the version number in the version.cfg file is earlier than that of the existing cluster. Ensure that the cluster, node, or instance is normal.
GAUSS-51630: "No node named %s."
SQLSTATE: None
Description: The node name does not exist.
Solution: Check whether the node is configured in the XML file. Ensure that the cluster, node, or instance is normal.
GAUSS-51631: "Failed to delete the %s instance."
SQLSTATE: None
Description: Failed to delete the CN.
Solution: Ensure that SSH mutual trust is normal, that the command is correctly executed, and that the cluster, node, or instance is normal.
GAUSS-51632: "Failed to do %s."
SQLSTATE: None
Description: Failed to execute the Python script.
Solution: Ensure that the Python script exists, that the command is correctly executed, and that the cluster, node, or instance is normal.
GAUSS-51633: "The·step·of·upgrade·number·%s·is·incorrect."
SQLSTATE: None
Description: The ID must be composed of digits.
Solution: Ensure that the specified instance exists, that the command is correctly executed, and that the cluster, node, or instance is normal.
GAUSS-51634: "Waiting node synchronizing timeout lead to failure."
SQLSTATE: None
Description: Waiting for the node synchronization results times out.
Solution: Ensure that the command is correctly executed and that the cluster, node, or instance is normal.
GAUSS-51635: "Failed to check SHA256."
SQLSTATE: None
Description: Failed to check SHA-256.
Solution: Ensure that the SHA-256 file exists. Ensure that the command is correctly executed. Ensure that the cluster, node, or instance is normal.
GAUSS-51636: "Failed to obtain %s node information."
SQLSTATE: None
Description: Failed to obtain the node information.
Solution: Ensure that the node is configured in the XML file, that the command is correctly executed, and that the cluster, node, or instance is normal.
GAUSS-51637: "The %s does not match with %s."
SQLSTATE: None
Description: The cluster information does not match.
Solution: Ensure that the two parties to be matched are updated simultaneously. Ensure that the command is correctly executed. Ensure that the cluster, node, or instance is normal.
GAUSS-51638: "Failed to append instance on host [%s]."
SQLSTATE: None
Description: Failed to add an instance on the node.
Solution: Check whether the XML file is correctly configured and whether the path conflict exists. Ensure that the cluster, node, or instance is normal.
GAUSS-51639: "Failed to obtain %s status of local node."
SQLSTATE: None
Description: Failed to obtain the local node status.
Solution: Rectify the fault.
GAUSS-51640: "Can't connect to cm_server, cluster is not running possibly."
SQLSTATE: None
Description:cm_server is not connected and the cluster is probably not running.
Solution: Restart the cluster.
GAUSS-51641: "Cluster redistributing status is not accord with expectation."
SQLSTATE: None
Description: The redistribution status does not meet the requirements.
Solution: Check whether the cluster status is normal. Ensure that the cluster, node, or instance is normal.
GAUSS-51642: "Failed to promote peer instances."
SQLSTATE: None
Description: Failed to start the peer instance.
Solution: Ensure that the specified instance exists, that the command is correctly executed, and that the cluster, node, or instance is normal.
GAUSS_51643: "Cluster is in read-only mode."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS_51644: "Failed to set resource control for the cluster."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51645: "Failed to restart %s."
SQLSTATE: None
Description: Failed to restart the cluster or logical cluster.
Solution: Ensure that the network connection is normal and that the configuration file is correct.
GAUSS-51646: "The other OM operation is currently being performed in the cluster node:"" '%s'."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51647: "The operation step of OM components in current cluster nodes do not match"" with each other: %s."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51648: "Waiting for redistribution process to end timeout."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51649: "Capture exceptions '%s' : %s."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51650: "Unclassified exceptions: %s."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51651: "The node '%s' status is Abnormal."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51652: "The package version on some nodes are inconsistent."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51653: "The %s can not exist in %s."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51654: "The standbyIp %s should different Kerberos server IP %s."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51655: "The %s has already installed."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51656: "Failed to make server.key.cipher and server.key.rand"
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51700 - GAUSS-51799
GAUSS-51704: "Failed to set Cgroup."
SQLSTATE: None
Description: Failed to configure cgroups.
Solution: Configure cgroups again.
GAUSS-51706: "Failed to check Cgroup."
SQLSTATE: None
Description: Failed to check cgroups.
Solution: Check whether the database status is normal.
GAUSS-51707: "Failed to install Cgroup."
SQLSTATE: None
Description: Failed to install cgroups.
Solution: Check whether the cgroups component has been mounted to the database.
GAUSS-51708: "Failed to uninstall Cgroup."
SQLSTATE: None
Description: Failed to uninstall cgroups.
Solution: Uninstall cgroups again.
GAUSS-51709: "Failed to clean Cgroup configuration file."
SQLSTATE: None
Description: Failed to clear the cgroups configuration file.
Solution: Run the clearance command again.
GAUSS-51800 - GAUSS-51899
GAUSS-51800: "The environmental variable %s is empty.·or·variable·has·exceeded·maximum·length"
SQLSTATE: None
Description: Environment variable is null.
Solution: Ensure that the environment variable is successfully written.
GAUSS-51801: "The environment variable %s exists."
SQLSTATE: None
Description: The environment variable exists.
Solution: Check why the environment variable exists in the .bashrc file and confirm whether it is because the variable has been added in the file.
GAUSS-51802: "Failed to obtain the environment variable %s."
SQLSTATE: None
Description: Failed to obtain the environment variable.
Solution: Ensure that the environment variable configuration is complete. Check that whether the environment variable path is correct.
GAUSS-51803: "Failed to delete the environment variable %s."
SQLSTATE: None
Description: Failed to delete the environment variable.
Solution: Ensure that the deletion command is correct and that you have the permission to delete objects.
GAUSS-51804: "Failed to set the environment variable %s."
SQLSTATE: None
Description: Failed to set the environment variables.
Solution: Check whether the permission is correct. Check whether the network connection is normal. Check whether the command of setting the environment variable is correct.
GAUSS-51805: "The environmental variable [%s]'s value is invalid."
SQLSTATE: None
Description: The environment variable value is invalid.
Solution: Check whether the network connection is normal. Check whether the command of setting the environment variable is correct. Check whether the value of the $GAUSS_ENV environment variable in the ./bashrc file is correct.
GAUSS-51806: "The cluster has been installed."
SQLSTATE: None
Description: The cluster has been installed.
Solution: Check whether the value of the $GAUSS_ENV environment variable in the .bashrc file is 2.
GAUSS-51807: "$GAUSSHOME of user is not equal to installation path."
SQLSTATE: None
Description: The GAUSSHOME path is inconsistent with that of the cluster installation path.
Solution: Ensure that you have the path access permission and that the network connection is normal. Ensure that the command used for setting the environment variable is correct and that the value of the $GAUSSHOME environment variable in the ./bashrc file is the same as the path configured in the XML file.
GAUSS-51808: "The env file contains errmsg: %s."
SQLSTATE: None
Description: The environment variable file package /etc/profile contains error or output flows.
Solution: Check the files mentioned in the error information, run source to find the corresponding output and delete the corresponding shell.
GAUSS-51809: "The variable [%s] context [%s] is invalid."
SQLSTATE: None
Description:Internal system error.
Solution:Contact technical support.
GAUSS-51900 - GAUSS-51999
GAUSS-51900: "The current OS is not supported."
SQLSTATE: None
Description: The current OS cannot be used.
Solution: Check and switch to the OS that is supported for further operations.
GAUSS-51901: "The OS versions are different among cluster nodes."
SQLSTATE: None
Description: The OSs between cluster nodes are inconsistent.
Solution: Keep all nodes in the cluster use the same version of OS.