v1.1
- About MogDB
- MogDB Introduction
- Comparison Between MogDB and openGauss
- MogDB Release Note
- High Availability and Performance
- Open Source Components
- Usage Limitations
- Terms of Use
- Quick Start
- Installation Guide
- Container Installation
- Standard Installation
- Installation Overview
- Preparing for Installation
- Installing the MogDB
- Verifying the Installation
- Uninstalling the MogDB
- Administrator Guide
- Routine Maintenance
- Primary and Standby Management
- MogHA Management
- MOT Engine
- Introducing MOT
- Using MOT
- Concepts of MOT
- Appendix
- Column-store Tables Management
- Backup and Restoration
- Importing and Exporting Data
- Importing Data
- Exporting Data
- Upgrade Guide
- Common Fault Locating Cases
- Core Fault Locating
- When the TPC-C is running and a disk to be injected is full, the TPC-C stops responding
- Standby Node in the Need Repair (WAL) State
- Insufficient Memory
- Service Startup Failure
- "Error:No space left on device" Is Displayed
- After You Run the du Command to Query Data File Size In the XFS File System, the Query Result Is Greater than the Actual File Size
- File Is Damaged in the XFS File System
- Primary Node Is Hung in Demoting During a Switchover
- Disk Space Usage Reaches the Threshold and the Database Becomes Read-only
- Slow Response to a Query Statement
- Analyzing the Status of a Query Statement
- Forcibly Terminating a Session
- Analyzing Whether a Query Statement Is Blocked
- Low Query Efficiency
- "Lock wait timeout" Is Displayed When a User Executes an SQL Statement
- Table Size Does not Change After VACUUM FULL Is Executed on the Table
- An Error Is Reported When the Table Partition Is Modified
- Different Data Is Displayed for the Same Table Queried By Multiple Users
- When a User Specifies Only an Index Name to Modify the Index, A Message Indicating That the Index Does Not Exist Is Displayed
- Reindexing Fails
- An Error Occurs During Integer Conversion
- "too many clients already" Is Reported or Threads Failed To Be Created in High Concurrency Scenarios
- B-tree Index Faults
- Security Guide
- Database Security Management
- Performance Tuning
- System Optimization
- SQL Optimization
- WDR Snapshot Schema
- Developer Guide
- Application Development Guide
- Development Specifications
- Development Based on JDBC
- Overview
- JDBC Package, Driver Class, and Environment Class
- Development Process
- Loading the Driver
- Connecting to a Database
- Connecting to the Database (Using SSL)
- Running SQL Statements
- Processing Data in a Result Set
- Closing a Connection
- Example: Common Operations
- Example: Retrying SQL Queries for Applications
- Example: Importing and Exporting Data Through Local Files
- Example 2: Migrating Data from a MY Database to MogDB
- Example: Logic Replication Code
- JDBC Interface Reference
- Development Based on ODBC
- Development Based on libpq
- Commissioning
- Appendices
- Stored Procedure
- User Defined Functions
- Application Development Guide
- Tool Reference
- System Catalogs and System Views
- Overview of System Catalogs and System Views
- System Catalogs
- GS_CLIENT_GLOBAL_KEYS
- GS_CLIENT_GLOBAL_KEYS_ARGS
- GS_COLUMN_KEYS
- GS_COLUMN_KEYS_ARGS
- GS_ENCRYPTED_COLUMNS
- GS_OPT_MODEL
- GS_WLM_INSTANCE_HISTORY
- GS_WLM_OPERATOR_INFO
- GS_WLM_PLAN_ENCODING_TABLE
- GS_WLM_PLAN_OPERATOR_INFO
- GS_WLM_USER_RESOURCE_HISTORY
- PG_AGGREGATE
- PG_AM
- PG_AMOP
- PG_AMPROC
- PG_APP_WORKLOADGROUP_MAPPING
- PG_ATTRDEF
- PG_ATTRIBUTE
- PG_AUTHID
- PG_AUTH_HISTORY
- PG_AUTH_MEMBERS
- PG_CAST
- PG_CLASS
- PG_COLLATION
- PG_CONSTRAINT
- PG_CONVERSION
- PG_DATABASE
- PG_DB_ROLE_SETTING
- PG_DEFAULT_ACL
- PG_DEPEND
- PG_DESCRIPTION
- PG_DIRECTORY
- PG_ENUM
- PG_EXTENSION
- PG_EXTENSION_DATA_SOURCE
- PG_FOREIGN_DATA_WRAPPER
- PG_FOREIGN_SERVER
- PG_FOREIGN_TABLE
- PG_INDEX
- PG_INHERITS
- PG_JOB
- PG_JOB_PROC
- PG_LANGUAGE
- PG_LARGEOBJECT
- PG_LARGEOBJECT_METADATA
- PG_NAMESPACE
- PG_OBJECT
- PG_OPCLASS
- PG_OPERATOR
- PG_OPFAMILY
- PG_PARTITION
- PG_PLTEMPLATE
- PG_PROC
- PG_RANGE
- PG_RESOURCE_POOL
- PG_REWRITE
- PG_RLSPOLICY
- PG_SECLABEL
- PG_SHDEPEND
- PG_SHDESCRIPTION
- PG_SHSECLABEL
- PG_STATISTIC
- PG_STATISTIC_EXT
- PG_TABLESPACE
- PG_TRIGGER
- PG_TS_CONFIG
- PG_TS_CONFIG_MAP
- PG_TS_DICT
- PG_TS_PARSER
- PG_TS_TEMPLATE
- PG_TYPE
- PG_USER_MAPPING
- PG_USER_STATUS
- PG_WORKLOAD_GROUP
- PLAN_TABLE_DATA
- STATEMENT_HISTORY
- System Views
- GS_SESSION_CPU_STATISTICS
- GS_SESSION_MEMORY_STATISTICS
- GS_SQL_COUNT
- GS_WLM_OPERATOR_HISTORY
- GS_WLM_OPERATOR_STATISTICS
- GS_WLM_PLAN_OPERATOR_HISTORY
- GS_WLM_REBUILD_USER_RESOURCE_POOL
- GS_WLM_RESOURCE_POOL
- GS_WLM_SESSION_HISTORY
- GS_WLM_SESSION_INFO_ALL
- GS_WLM_USER_INFO
- GS_WLM_SESSION_STATISTICS
- GS_STAT_SESSION_CU
- MPP_TABLES
- PG_AVAILABLE_EXTENSION_VERSIONS
- PG_AVAILABLE_EXTENSIONS
- PG_CURSORS
- PG_EXT_STATS
- PG_GET_INVALID_BACKENDS
- PG_GET_SENDERS_CATCHUP_TIME
- PG_GROUP
- PG_GTT_RELSTATS
- PG_GTT_STATS
- PG_GTT_ATTACHED_PIDS
- PG_INDEXES
- PG_LOCKS
- PG_MATVIEWS
- PG_NODE_ENV
- PG_OS_THREADS
- PG_PREPARED_STATEMENTS
- PG_PREPARED_XACTS
- PG_REPLICATION_SLOTS
- PG_RLSPOLICIES
- PG_ROLES
- PG_RULES
- PG_SECLABELS
- PG_SESSION_WLMSTAT
- PG_SESSION_IOSTAT
- PG_SETTINGS
- PG_SHADOW
- PG_STATS
- PG_STAT_ACTIVITY
- PG_STAT_ALL_INDEXES
- PG_STAT_ALL_TABLES
- PG_STAT_BAD_BLOCK
- PG_STAT_BGWRITER
- PG_STAT_DATABASE
- PG_STAT_DATABASE_CONFLICTS
- PG_STAT_USER_FUNCTIONS
- PG_STAT_USER_INDEXES
- PG_STAT_USER_TABLES
- PG_STAT_REPLICATION
- PG_STAT_SYS_INDEXES
- PG_STAT_SYS_TABLES
- PG_STAT_XACT_ALL_TABLES
- PG_STAT_XACT_SYS_TABLES
- PG_STAT_XACT_USER_FUNCTIONS
- PG_STAT_XACT_USER_TABLES
- PG_STATIO_ALL_INDEXES
- PG_STATIO_ALL_SEQUENCES
- PG_STATIO_ALL_TABLES
- PG_STATIO_SYS_INDEXES
- PG_STATIO_SYS_SEQUENCES
- PG_STATIO_SYS_TABLES
- PG_STATIO_USER_INDEXES
- PG_STATIO_USER_SEQUENCES
- PG_STATIO_USER_TABLES
- PG_THREAD_WAIT_STATUS
- PG_TABLES
- PG_TDE_INFO
- PG_TIMEZONE_NAMES
- PG_TOTAL_USER_RESOURCE_INFO
- PG_USER
- PG_USER_MAPPINGS
- PG_VIEWS
- PG_WLM_STATISTICS
- PLAN_TABLE
- GS_FILE_STAT
- GS_OS_RUN_INFO
- GS_REDO_STAT
- GS_SESSION_MEMORY
- GS_SESSION_MEMORY_DETAIL
- GS_SESSION_STAT
- GS_SESSION_TIME
- GS_THREAD_MEMORY_DETAIL
- GS_TOTAL_MEMORY_DETAIL
- PG_TIMEZONE_ABBREVS
- PG_TOTAL_USER_RESOURCE_INFO_OID
- PG_VARIABLE_INFO
- GS_INSTANCE_TIME
- Functions and Operators
- Logical Operators
- Comparison Operators
- Character Processing Functions and Operators
- Binary String Functions and Operators
- Bit String Functions and Operators
- Mode Matching Operators
- Mathematical Functions and Operators
- Date and Time Processing Functions and Operators
- Type Conversion Functions
- Geometric Functions and Operators
- Network Address Functions and Operators
- Text Search Functions and Operators
- JSON Functions
- SEQUENCE Functions
- Array Functions and Operators
- Range Functions and Operators
- Aggregate Functions
- Window Functions
- Security Functions
- Encrypted Equality Functions
- Set Returning Functions
- Conditional Expression Functions
- System Information Functions
- System Administration Functions
- Statistics Information Functions
- Trigger Functions
- Global Temporary Table Functions
- AI Feature Functions
- Other System Functions
- Supported Data Types
- SQL Syntax
- ABORT
- ALTER DATABASE
- ALTER DATA SOURCE
- ALTER DEFAULT PRIVILEGES
- ALTER DIRECTORY
- ALTER FOREIGN TABLE
- ALTER FUNCTION
- ALTER GROUP
- ALTER INDEX
- ALTER LARGE OBJECT
- ALTER MATERIALIZED VIEW
- ALTER ROLE
- ALTER ROW LEVEL SECURITY POLICY
- ALTER RULE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER SERVER
- ALTER SESSION
- ALTER SYNONYM
- ALTER SYSTEM KILL SESSION
- ALTER SYSTEM SET
- ALTER TABLE
- ALTER TABLE PARTITION
- ALTER TABLESPACE
- ALTER TEXT SEARCH CONFIGURATION
- ALTER TEXT SEARCH DICTIONARY
- ALTER TRIGGER
- ALTER TYPE
- ALTER USER
- ALTER USER MAPPING
- ALTER VIEW
- ANALYZE | ANALYSE
- BEGIN
- CALL
- CHECKPOINT
- CLOSE
- CLUSTER
- COMMENT
- COMMIT | END
- COMMIT PREPARED
- COPY
- CREATE CLIENT MASTER KEY
- CREATE COLUMN ENCRYPTION KEY
- CREATE DATABASE
- CREATE DATA SOURCE
- CREATE DIRECTORY
- CREATE FOREIGN TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INDEX
- CREATE MATERIALIZED VIEW
- CREATE ROW LEVEL SECURITY POLICY
- CREATE PROCEDURE
- CREATE ROLE
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SERVER
- CREATE SYNONYM
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLE PARTITION
- CREATE TABLESPACE
- CREATE TEXT SEARCH CONFIGURATION
- CREATE TEXT SEARCH DICTIONARY
- CREATE TRIGGER
- CREATE TYPE
- CREATE USER
- CREATE USER MAPPING
- CREATE VIEW
- CURSOR
- DEALLOCATE
- DECLARE
- DELETE
- DO
- DROP CLIENT MASTER KEY
- DROP COLUMN ENCRYPTION KEY
- DROP DATABASE
- DROP DATA SOURCE
- DROP DIRECTORY
- DROP FOREIGN TABLE
- DROP FUNCTION
- DROP GROUP
- DROP INDEX
- DROP MATERIALIZED VIEW
- DROP OWNED
- DROP ROW LEVEL SECURITY POLICY
- DROP PROCEDURE
- DROP ROLE
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP SERVER
- DROP SYNONYM
- DROP TABLE
- DROP TABLESPACE
- DROP TEXT SEARCH CONFIGURATION
- DROP TEXT SEARCH DICTIONARY
- DROP TRIGGER
- DROP TYPE
- DROP USER
- DROP USER MAPPING
- DROP VIEW
- EXECUTE
- EXPLAIN
- EXPLAIN PLAN
- FETCH
- GRANT
- INSERT
- LOCK
- MOVE
- MERGE INTO
- PREPARE
- PREPARE TRANSACTION
- REASSIGN OWNED
- REFRESH MATERIALIZED VIEW
- REINDEX
- RELEASE SAVEPOINT
- RESET
- REVOKE
- ROLLBACK
- ROLLBACK PREPARED
- ROLLBACK TO SAVEPOINT
- SAVEPOINT
- SELECT
- SELECT INTO
- SET
- SET CONSTRAINTS
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SHOW
- SHUTDOW
- START TRANSACTION
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- GUC Parameters
- GUC Parameter Usage
- File Location
- Connection and Authentication
- Resource Consumption
- Parallel Import
- Write Ahead Log
- HA Replication
- Memory Table
- Query Planning
- Error Reporting and Logging
- Alarm Detection
- Statistics During the Database Running
- Load Management
- Automatic Vacuuming
- Default Settings of Client Connection
- Lock Management
- Version and Platform Compatibility
- Faut Tolerance
- Connection Pool Parameters
- MogDB Transaction
- Developer Options
- Auditing
- Upgrade Parameters
- Miscellaneous Parameters
- Wait Events
- Query
- System Performance Snapshot
- Equality Query in a Fully-encrypted Database
- Global Temporary Table
- Appendix
- DBE_PERF
- DBE_PERF Overview
- OS
- Instance
- Memory
- File
- Object
- STAT_USER_TABLES
- SUMMARY_STAT_USER_TABLES
- GLOBAL_STAT_USER_TABLES
- STAT_USER_INDEXES
- SUMMARY_STAT_USER_INDEXES
- GLOBAL_STAT_USER_INDEXES
- STAT_SYS_TABLES
- SUMMARY_STAT_SYS_TABLES
- GLOBAL_STAT_SYS_TABLES
- STAT_SYS_INDEXES
- SUMMARY_STAT_SYS_INDEXES
- GLOBAL_STAT_SYS_INDEXES
- STAT_ALL_TABLES
- SUMMARY_STAT_ALL_TABLES
- GLOBAL_STAT_ALL_TABLES
- STAT_ALL_INDEXES
- SUMMARY_STAT_ALL_INDEXES
- GLOBAL_STAT_ALL_INDEXES
- STAT_DATABASE
- SUMMARY_STAT_DATABASE
- GLOBAL_STAT_DATABASE
- STAT_DATABASE_CONFLICTS
- SUMMARY_STAT_DATABASE_CONFLICTS
- GLOBAL_STAT_DATABASE_CONFLICTS
- STAT_XACT_ALL_TABLES
- SUMMARY_STAT_XACT_ALL_TABLES
- GLOBAL_STAT_XACT_ALL_TABLES
- STAT_XACT_SYS_TABLES
- SUMMARY_STAT_XACT_SYS_TABLES
- GLOBAL_STAT_XACT_SYS_TABLES
- STAT_XACT_USER_TABLES
- SUMMARY_STAT_XACT_USER_TABLES
- GLOBAL_STAT_XACT_USER_TABLES
- STAT_XACT_USER_FUNCTIONS
- SUMMARY_STAT_XACT_USER_FUNCTIONS
- GLOBAL_STAT_XACT_USER_FUNCTIONS
- STAT_BAD_BLOCK
- SUMMARY_STAT_BAD_BLOCK
- GLOBAL_STAT_BAD_BLOCK
- STAT_USER_FUNCTIONS
- SUMMARY_STAT_USER_FUNCTIONS
- GLOBAL_STAT_USER_FUNCTIONS
- Workload
- Session/Thread
- SESSION_STAT
- GLOBAL_SESSION_STAT
- SESSION_TIME
- GLOBAL_SESSION_TIME
- SESSION_MEMORY
- GLOBAL_SESSION_MEMORY
- SESSION_MEMORY_DETAIL
- GLOBAL_SESSION_MEMORY_DETAIL
- SESSION_STAT_ACTIVITY
- GLOBAL_SESSION_STAT_ACTIVITY
- THREAD_WAIT_STATUS
- GLOBAL_THREAD_WAIT_STATUS
- LOCAL_THREADPOOL_STATUS
- GLOBAL_THREADPOOL_STATUS
- SESSION_CPU_RUNTIME
- SESSION_MEMORY_RUNTIME
- STATEMENT_IOSTAT_COMPLEX_RUNTIME
- Transaction
- Query
- STATEMENT
- SUMMARY_STATEMENT
- STATEMENT_COUNT
- GLOBAL_STATEMENT_COUNT
- SUMMARY_STATEMENT_COUNT
- GLOBAL_STATEMENT_COMPLEX_HISTORY
- GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
- GLOBAL_STATEMENT_COMPLEX_RUNTIME
- STATEMENT_RESPONSETIME_PERCENTILE
- STATEMENT_USER_COMPLEX_HISTORY
- STATEMENT_COMPLEX_RUNTIME
- STATEMENT_COMPLEX_HISTORY_TABLE
- STATEMENT_COMPLEX_HISTORY
- STATEMENT_WLMSTAT_COMPLEX_RUNTIME
- STATEMENT_HISTORY
- Cache/IO
- STATIO_USER_TABLES
- SUMMARY_STATIO_USER_TABLES
- GLOBAL_STATIO_USER_TABLES
- STATIO_USER_INDEXES
- SUMMARY_STATIO_USER_INDEXES
- GLOBAL_STATIO_USER_INDEXES
- STATIO_USER_SEQUENCES
- SUMMARY_STATIO_USER_SEQUENCES
- GLOBAL_STATIO_USER_SEQUENCES
- STATIO_SYS_TABLES
- SUMMARY_STATIO_SYS_TABLES
- GLOBAL_STATIO_SYS_TABLES
- STATIO_SYS_INDEXES
- SUMMARY_STATIO_SYS_INDEXES
- GLOBAL_STATIO_SYS_INDEXES
- STATIO_SYS_SEQUENCES
- SUMMARY_STATIO_SYS_SEQUENCES
- GLOBAL_STATIO_SYS_SEQUENCES
- STATIO_ALL_TABLES
- SUMMARY_STATIO_ALL_TABLES
- GLOBAL_STATIO_ALL_TABLES
- STATIO_ALL_INDEXES
- SUMMARY_STATIO_ALL_INDEXES
- GLOBAL_STATIO_ALL_INDEXES
- STATIO_ALL_SEQUENCES
- SUMMARY_STATIO_ALL_SEQUENCES
- GLOBAL_STATIO_ALL_SEQUENCES
- GLOBAL_STAT_DB_CU
- GLOBAL_STAT_SESSION_CU
- Utility
- REPLICATION_STAT
- GLOBAL_REPLICATION_STAT
- REPLICATION_SLOTS
- GLOBAL_REPLICATION_SLOTS
- BGWRITER_STAT
- GLOBAL_BGWRITER_STAT
- GLOBAL_CKPT_STATUS
- GLOBAL_DOUBLE_WRITE_STATUS
- GLOBAL_PAGEWRITER_STATUS
- GLOBAL_RECORD_RESET_TIME
- GLOBAL_REDO_STATUS
- GLOBAL_RECOVERY_STATUS
- CLASS_VITAL_INFO
- USER_LOGIN
- SUMMARY_USER_LOGIN
- GLOBAL_GET_BGWRITER_STATUS
- Lock
- Wait Events
- Configuration
- Operator
- Workload Manager
- Global Plancache
- Appendix
- Error Code Reference
- Description of SQL Error Codes
- Third-Party Library Error Codes
- GAUSS-00001 - GAUSS-00100
- GAUSS-00101 - GAUSS-00200
- GAUSS 00201 - GAUSS 00300
- GAUSS 00301 - GAUSS 00400
- GAUSS 00401 - GAUSS 00500
- GAUSS 00501 - GAUSS 00600
- GAUSS 00601 - GAUSS 00700
- GAUSS 00701 - GAUSS 00800
- GAUSS 00801 - GAUSS 00900
- GAUSS 00901 - GAUSS 01000
- GAUSS 01001 - GAUSS 01100
- GAUSS 01101 - GAUSS 01200
- GAUSS 01201 - GAUSS 01300
- GAUSS 01301 - GAUSS 01400
- GAUSS 01401 - GAUSS 01500
- GAUSS 01501 - GAUSS 01600
- GAUSS 01601 - GAUSS 01700
- GAUSS 01701 - GAUSS 01800
- GAUSS 01801 - GAUSS 01900
- GAUSS 01901 - GAUSS 02000
- GAUSS 02001 - GAUSS 02100
- GAUSS 02101 - GAUSS 02200
- GAUSS 02201 - GAUSS 02300
- GAUSS 02301 - GAUSS 02400
- GAUSS 02401 - GAUSS 02500
- GAUSS 02501 - GAUSS 02600
- GAUSS 02601 - GAUSS 02700
- GAUSS 02701 - GAUSS 02800
- GAUSS 02801 - GAUSS 02900
- GAUSS 02901 - GAUSS 03000
- GAUSS 03001 - GAUSS 03100
- GAUSS 03101 - GAUSS 03200
- GAUSS 03201 - GAUSS 03300
- GAUSS 03301 - GAUSS 03400
- GAUSS 03401 - GAUSS 03500
- GAUSS 03501 - GAUSS 03600
- GAUSS 03601 - GAUSS 03700
- GAUSS 03701 - GAUSS 03800
- GAUSS 03801 - GAUSS 03900
- GAUSS 03901 - GAUSS 04000
- GAUSS 04001 - GAUSS 04100
- GAUSS 04101 - GAUSS 04200
- GAUSS 04201 - GAUSS 04300
- GAUSS 04301 - GAUSS 04400
- GAUSS 04401 - GAUSS 04500
- GAUSS 04501 - GAUSS 04600
- GAUSS 04601 - GAUSS 04700
- GAUSS 04701 - GAUSS 04800
- GAUSS 04801 - GAUSS 04900
- GAUSS 04901 - GAUSS 05000
- GAUSS 05001 - GAUSS 05100
- GAUSS 05101 - GAUSS 05200
- GAUSS 05201 - GAUSS 05300
- GAUSS 05301 - GAUSS 05400
- GAUSS 05401 - GAUSS 05500
- GAUSS 05501 - GAUSS 05600
- GAUSS 05601 - GAUSS 05700
- GAUSS 05701 - GAUSS 05800
- GAUSS 05801 - GAUSS 05900
- GAUSS 05901 - GAUSS 06000
- GAUSS 06001 - GAUSS 06100
- GAUSS 06101 - GAUSS 06200
- GAUSS 06201 - GAUSS 06300
- GAUSS 06301 - GAUSS 06400
- GAUSS 06401 - GAUSS 06500
- GAUSS 06501 - GAUSS 06600
- GAUSS 06601 - GAUSS 06700
- GAUSS 06701 - GAUSS 06800
- GAUSS 06801 - GAUSS 06900
- GAUSS 06901 - GAUSS 07000
- GAUSS 07001 - GAUSS 07100
- GAUSS 07101 - GAUSS 07200
- GAUSS 07201 - GAUSS 07300
- GAUSS 07301 - GAUSS 07400
- GAUSS 07401 - GAUSS 07480
- GAUSS 50000 - GAUSS 50999
- GAUSS 51000 - GAUSS 51999
- GAUSS 52000 - GAUSS 52999
- GAUSS 53000 - GAUSS 53699
- System Catalogs and System Views
- Glossary
Description of SQL Error Codes
As defined by the X/Open and SQL Access Group SQL CAE specification (1992), SQLERROR returns SQLSTATE values. A SQLSTATE value is a five-character string consisting of a two-character SQL error class and a three-character subclass. Five characters containing numeric or uppercase letters indicate the code for various errors or warning conditions. The successful status is identified by 00000. SQLSTATE codes are mostly defined in the SQL standard.
MogDB also follows the SQL standard to return the SQLSTATE value of the error code, as detailed in Table 1.
**Table 1 **SQLSTATE values for MogDB error codes
SQLSTATE Value | Description |
---|---|
Class 00 - Successful completion | |
00000 | Successful completion (SUCCESSFUL_COMPLETION) |
Class 01 - Warning | |
01000 | Warning (WARNING) |
0100C | Dynamic result set returned (DYNAMIC_RESULT_SETS_RETURNED) |
01008 | Implicit zero bit padding (IMPLICIT_ZERO_BIT_PADDING) |
01003 | Null value eliminated in set function (NULL_VALUE_ELIMINATED_IN_SET_FUNCTION) |
01007 | Privilege not granted (PRIVILEGE_NOT_GRANTED) |
01006 | Privilege not revoked (PRIVILEGE_NOT_REVOKED) |
01004 | String data right truncation (STRING_DATA_RIGHT_TRUNCATION) |
01P01 | Deprecated feature (DEPRECATED_FEATURE) |
Class 02 - No data (This is a warning class according to the SQL standard.) | |
02000 | No data (NO_DATA) |
02001 | No additional dynamic result sets returned (NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED) |
Class 03 - SQL statement not completed | |
03000 | SQL statement not completed (SQL_STATEMENT_NOT_YET_COMPLETE) |
Class 08 - Connection exception | |
08000 | Connection exception (CONNECTION_EXCEPTION) |
08003 | Connection does not exist (CONNECTION_DOES_NOT_EXIST) |
08006 | Connection failure (CONNECTION_FAILURE) |
08001 | SQL connections cannot be established on the SQL client (SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION) |
08004 | SQL server rejects establishment of SQL connections (SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION) |
08007 | Unknown transaction resolution (TRANSACTION_RESOLUTION_UNKNOWN) |
08P01 | Violation of the protocol (PROTOCOL_VIOLATION) |
Class 09 - Triggering action exception | |
09000 | Triggering action exception (TRIGGERED_ACTION_EXCEPTION) |
Class 0A - Feature not supported | |
0A000 | Feature not supported (FEATURE_NOT_SUPPORTED) |
0A100 | Stream not supported (STREAM_NOT_SUPPORTED) |
Class 0B - Invalid transaction initiation | |
0B000 | Invalid transaction initiation (INVALID_TRANSACTION_INITIATION) |
Class 0F - Locator exception | |
0F000 | Locator exception (LOCATOR_EXCEPTION) |
0F001 | Invalid locator specification (INVALID_LOCATOR_SPECIFICATION) |
Class 0L - Invalid grantor | |
0L000 | Invalid grantor (INVALID_GRANTOR) |
0LP01 | Invalid grant operation (INVALID_GRANT_OPERATION) |
Class 0P - Invalid role specification | |
0P000 | Invalid role specification (INVALID_ROLE_SPECIFICATION) |
Class 0Z - Diagnostics exception | |
0Z000 | Diagnostics exception (DIAGNOSTICS_EXCEPTION) |
0Z002 | Stacked diagnostics accessed without active handler (STACKED_DIAGNOSTICS_ACCESSED_WITHOUT_ACTIVE_HANDLER) |
Class 20 - Case not found | |
20000 | Case not found (CASE_NOT_FOUND) |
Class 21 - Cardinality violation | |
21000 | Cardinality violation (CARDINALITY_VIOLATION) |
Class 22 - Data exception | |
22000 | Data exception (DATA_EXCEPTION) |
2202E | Array subscript error (ARRAY_SUBSCRIPT_ERROR) |
22021 | Character not in repertoire (CHARACTER_NOT_IN_REPERTOIRE) |
22008 | Datetime field overflow (DATETIME_FIELD_OVERFLOW) |
22012 | Division by zero (DIVISION_BY_ZERO) |
22005 | Error in assignment (ERROR_IN_ASSIGNMENT) |
2200B | Escape character conflict (ESCAPE_CHARACTER_CONFLICT) |
22022 | Indicator overflow (INDICATOR_OVERFLOW) |
22015 | Interval field overflow (INTERVAL_FIELD_OVERFLOW) |
2201E | Invalid argument for logarithm (INVALID_ARGUMENT_FOR_LOGARITHM) |
22014 | Invalid argument for NTILE function (INVALID_ARGUMENT_FOR_NTILE_FUNCTION) |
22016 | Invalid argument for N value function (INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION) |
2201F | Invalid argument for power function (INVALID_ARGUMENT_FOR_POWER_FUNCTION) |
2201G | Invalid argument for width bucket function (INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION) |
22018 | Invalid character value for CAST (INVALID_CHARACTER_VALUE_FOR_CAST) |
22007 | Invalid datetime format (INVALID_DATETIME_FORMAT) |
22019 | Invalid escape character (INVALID_ESCAPE_CHARACTER) |
2200D | Invalid escape octet (INVALID_ESCAPE_OCTET) |
22025 | Invalid escape sequence (INVALID_ESCAPE_SEQUENCE) |
22P06 | Nonstandard use of escape character (NONSTANDARD_USE_OF_ESCAPE_CHARACTER) |
22010 | Invalid indicator parameter value (INVALID_INDICATOR_PARAMETER_VALUE) |
22023 | Invalid parameter value (INVALID_PARAMETER_VALUE) |
2201B | Invalid regular expression (INVALID_REGULAR_EXPRESSION) |
2201W | Invalid row count in LIMIT clause (INVALID_ROW_COUNT_IN_LIMIT_CLAUSE) |
2201X | Invalid row count in result set clause (INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE) |
2202H | Invalid sample parameter (ERRCODE_INVALID_TABLESAMPLE_ARGUMENT) |
2202G | Invalid sample repeat (ERRCODE_INVALID_TABLESAMPLE_REPEAT) |
22009 | Invalid time zone displacement value (INVALID_TIME_ZONE_DISPLACEMENT_VALUE) |
2200C | Invalid use of escape character (INVALID_USE_OF_ESCAPE_CHARACTER) |
2200G | Most specific type mismatch (MOST_SPECIFIC_TYPE_MISMATCH) |
22004 | Null value not allowed (NULL_VALUE_NOT_ALLOWED) |
22002 | Null value cannot be used as the indicator parameter(NULL_VALUE_NO_INDICATOR_PARAMETER) |
22003 | Numeric value out of range (NUMERIC_VALUE_OUT_OF_RANGE) |
22017 | DOP value out of range (ERRCODE_DOP_VALUE_OUT_OF_RANGE) |
22026 | String data length mismatch (STRING_DATA_LENGTH_MISMATCH) |
22028 | Regular expression mismatch (ERRCODE_REGEXP_MISMATCH) |
22001 | String data right truncation (STRING_DATA_RIGHT_TRUNCATION) |
22011 | Substring error (SUBSTRING_ERROR) |
22027 | Trim error (TRIM_ERROR) |
22024 | Unterminated C string (UNTERMINATED_C_STRING) |
2200F | Zero-length character string (ZERO_LENGTH_CHARACTER_STRING) |
22P01 | Floating point exception (FLOATING_POINT_EXCEPTION) |
22P02 | Invalid text representation (INVALID_TEXT_REPRESENTATION) |
22P03 | Invalid binary representation (INVALID_BINARY_REPRESENTATION) |
22P04 | Incorrect copy file format (BAD_COPY_FILE_FORMAT) |
22P05 | Untranslatable character (UNTRANSLATABLE_CHARACTER) |
22P06 | Memory query failure (ERRCODE_CACHE_LOOKUP_FAILED) |
22P07 | Failed to read the file (ERRCODE_FILE_READ_FAILED) |
22P08 | Failed to obtain data (ERRCODE_FETCH_DATA_FAILED) |
2200L | Not XML file (NOT_AN_XML_DOCUMENT) |
2200M | Invalid XML file (INVALID_XML_DOCUMENT) |
2200N | Invalid XML content (INVALID_XML_CONTENT) |
2200O | Invalid XML error information (ERRCODE_INVALID_XML_ERROR_CONTEXT) |
2200S | Invalid XML comment (INVALID_XML_COMMENT) |
2200T | Invalid XML processing instruction (INVALID_XML_PROCESSING_INSTRUCTION) |
2200X | RELATION close error (RELATION_CLOSE_ERROR) |
Class 23 - Integrity constraint violation | |
23000 | Integrity constraint violation (INTEGRITY_CONSTRAINT_VIOLATION) |
23001 | Restrict violation (RESTRICT_VIOLATION) |
23502 | Not null violation (NOT_NULL_VIOLATION) |
23503 | Foreign key violation (FOREIGN_KEY_VIOLATION) |
23505 | Uniqueness violation (UNIQUE_VIOLATION) |
23514 | CHECK violation (CHECK_VIOLATION) |
23P01 | Exclusion violation (EXCLUSION_VIOLATION) |
Class 24 - Invalid cursor state | |
24000 | Invalid cursor state (INVALID_CURSOR_STATE) |
Class 25 - Invalid transaction state | |
25000 | Invalid transaction state (INVALID_TRANSACTION_STATE) |
25001 | Active SQL transaction (ACTIVE_SQL_TRANSACTION) |
25002 | Branch transaction already activated (BRANCH_TRANSACTION_ALREADY_ACTIVE) |
25008 | Held cursor requires the same isolation level (HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL) |
25003 | Inappropriate access mode for branch transaction (INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION) |
25004 | Inappropriate isolation level for branch transaction (INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION) |
25005 | No active SQL transaction for branch transaction (NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION) |
25006 | Read-only SQL transaction (READ_ONLY_SQL_TRANSACTION) |
25007 | Schema and data statement mixing not supported (SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED) |
25009 | Transaction cannot be started during recovery (ERRCODE_RUN_TRANSACTION_DURING_RECOVERY) |
25010 | Transaction ID does not exist (ERRCODE_GXID_DOES_NOT_EXIST) |
25P01 | No active SQL transaction (NO_ACTIVE_SQL_TRANSACTION) |
25P02 | In failed SQL transaction (IN_FAILED_SQL_TRANSACTION) |
Class 26 - Invalid SQL statement name | |
26000 | Invalid SQL statement name (INVALID_SQL_STATEMENT_NAME) |
Class 27 - Triggered data change violation | |
27000 | Triggered data change violation (TRIGGERED_DATA_CHANGE_VIOLATION) |
27001 | Invalid triggered tuple (ERRCODE_TRIGGERED_INVALID_TUPLE) |
Class 28 - Invalid authorization specification | |
28000 | Invalid authorization specification (INVALID_AUTHORIZATION_SPECIFICATION) |
28P01 | Invalid password (INVALID_PASSWORD) |
28P02 | Initial password not changed (INITIAL_PASSWORD_NOT_MODIFIED) |
Class 29 - Invalid or unexpected state | |
29P06 | Invalid cache plan (INVALID_CACHE_PLAN) |
Class 2B - The dependent privilege descriptor still exists | |
2B000 | The dependent privilege descriptor still exists (DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST) |
2BP01 | The dependent object still exists (DEPENDENT_OBJECTS_STILL_EXIST) |
Class 2D - Invalid transaction termination | |
2D000 | Invalid transaction termination (INVALID_TRANSACTION_TERMINATION) |
Class 2F - SQL process exception | |
2F000 | SQL process exception (SQL_ROUTINE_EXCEPTION) |
2F005 | No return statement during function execution (FUNCTION_EXECUTED_NO_RETURN_STATEMENT) |
2F002 | Modifying SQL data not permitted (MODIFYING_SQL_DATA_NOT_PERMITTED) |
2F003 | Prohibited SQL statement attempted (PROHIBITED_SQL_STATEMENT_ATTEMPTED) |
2F004 | Reading SQL data not permitted (READING_SQL_DATA_NOT_PERMITTED) |
Class 34 - Invalid cursor name | |
34000 | Invalid cursor name (INVALID_CURSOR_NAME) |
Class 38 - External process exception | |
38000 | External process exception (EXTERNAL_ROUTINE_EXCEPTION) |
38001 | Containing SQL not permitted (CONTAINING_SQL_NOT_PERMITTED) |
38002 | Modifying SQL data not permitted (MODIFYING_SQL_DATA_NOT_PERMITTED) |
38003 | Prohibited SQL statement attempted (PROHIBITED_SQL_STATEMENT_ATTEMPTED) |
38004 | SQL data read not permitted (READING_SQL_DATA_NOT_PERMITTED) |
Class 39 - External process invocation exception | |
39000 | External process invocation exception (EXTERNAL_ROUTINE_INVOCATION_EXCEPTION) |
39001 | Invalid SQLSTATE value returned (INVALID_SQLSTATE_RETURNED) |
39004 | Null value not allowed (NULL_VALUE_NOT_ALLOWED) |
39P01 | Trigger protocol violated (TRIGGER_PROTOCOL_VIOLATED) |
39P02 | SRF protocol violated (SRF_PROTOCOL_VIOLATED) |
Class 3B - Savepoint exception | |
3B000 | Savepoint exception (SAVEPOINT_EXCEPTION) |
3B001 | Invalid savepoint specification (INVALID_SAVEPOINT_SPECIFICATION) |
Class 3D - Invalid database name | |
3D000 | Invalid database name (INVALID_CATALOG_NAME) |
Class 3F - Invalid schema name | |
3F000 | Invalid schema name (INVALID_SCHEMA_NAME) |
Class 40 - Transaction rollback | |
40000 | Transaction rollback (TRANSACTION_ROLLBACK) |
40002 | Transaction integrity constraint violation (TRANSACTION_INTEGRITY_CONSTRAINT_VIOLATION) |
40001 | Serialization failure (SERIALIZATION_FAILURE) |
40003 | Statement completion unknown (STATEMENT_COMPLETION_UNKNOWN) |
40P01 | Deadlock detected (DEADLOCK_DETECTED) |
Class 42 - Syntax error or access rule violation | |
42000 | Syntax error or access rule violation (SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION) |
42601 | syntax error (SYNTAX_ERROR) |
42501 | Insufficient privilege (INSUFFICIENT_PRIVILEGE) |
42846 | Type conversion cannot be performed 无法进行类型转换(CANNOT_COERCE) |
42803 | Grouping error (GROUPING_ERROR) |
42P20 | Windowing error (WINDOWING_ERROR) |
42P19 | Invalid recursion (INVALID_RECURSION) |
42830 | Invalid foreign key (INVALID_FOREIGN_KEY) |
42602 | Invalid name (INVALID_NAME) |
42622 | Too long name (NAME_TOO_LONG) |
42939 | Reserved name (RESERVED_NAME) |
42804 | Data type mismatch (DATATYPE_MISMATCH) |
42P18 | Indeterminate data type (INDETERMINATE_DATATYPE) |
42P21 | Collation mismatch (COLLATION_MISMATCH) |
42P22 | Indeterminate collation (INDETERMINATE_COLLATION) |
42P23 | Partition error (ERRCODE_PARTITION_ERROR) |
42P24 | Invalid attribute value (ERRCODE_INVALID_ATTRIBUTE) |
42P25 | Invalid aggregation function (ERRCODE_INVALID_AGG) |
42P26 | Resource pool error (ERRCODE_RESOURCE_POOL_ERROR) |
42P27 | Parent plan not found (ERRCODE_PLAN_PARENT_NOT_FOUND) |
42P28 | Update conflict (ERRCODE_MODIFY_CONFLICTS) |
42P29 | Distribution error (ERRCODE_DISTRIBUTION_ERROR) |
42809 | Incorrect object type (WRONG_OBJECT_TYPE) |
42703 | Undefined column (UNDEFINED_COLUMN) |
42883 | Undefined function (UNDEFINED_FUNCTION) |
42P01 | Undefined table (UNDEFINED_TABLE) |
42P02 | Undefined parameter (UNDEFINED_PARAMETER) |
42704 | Undefined object (UNDEFINED_OBJECT) |
42701 | Duplicate column (DUPLICATE_COLUMN) |
42P03 | Duplicate cursor (DUPLICATE_CURSOR) |
42P04 | Duplicate database (DUPLICATE_DATABASE) |
42723 | Duplicate function (DUPLICATE_FUNCTION) |
42P05 | Duplicate prepared statement (DUPLICATE_PREPARED_STATEMENT) |
42P06 | Duplicate schema (DUPLICATE_SCHEMA) |
42P07 | Duplicate table (DUPLICATE_TABLE) |
42712 | Duplicate alias (DUPLICATE_ALIAS) |
42710 | Duplicate object (DUPLICATE_OBJECT) |
42702 | Ambiguous column (AMBIGUOUS_COLUMN) |
42725 | Ambiguous function (AMBIGUOUS_FUNCTION) |
42P08 | Ambiguous parameter (AMBIGUOUS_PARAMETER) |
42P09 | Ambiguous alias (AMBIGUOUS_ALIAS) |
42P10 | Invalid column reference (INVALID_COLUMN_REFERENCE) |
42611 | Invalid column definition (INVALID_COLUMN_DEFINITION) |
42P11 | Invalid cursor definition (INVALID_CURSOR_DEFINITION) |
42P12 | Invalid database definition (INVALID_DATABASE_DEFINITION) |
42P13 | Invalid function definition (INVALID_FUNCTION_DEFINITION) |
42P14 | Invalid prepared statement definition (INVALID_PREPARED_STATEMENT_DEFINITION) |
42P15 | Invalid schema definition (INVALID_SCHEMA_DEFINITION) |
42P16 | Invalid table definition (INVALID_TABLE_DEFINITION) |
42P17 | Invalid object definition (INVALID_OBJECT_DEFINITION) |
Class 44 - WITH CHECK option violation | |
44000 | WITH CHECK option violation (WITH_CHECK_OPTION_VIOLATION) |
Class 53 - Insufficient resources | |
53000 | Insufficient resources (INSUFFICIENT_RESOURCES) |
53100 | The disk space is fully occupied (DISK_FULL) |
53200 | Out of memory (OUT_OF_MEMORY) |
53300 | Too many connections (TOO_MANY_CONNECTIONS) |
53400 | Configuration limit exceeded (CONFIGURATION_LIMIT_EXCEEDED) |
Class 54 - Program limit exceeded | |
54000 | Program limit exceeded (PROGRAM_LIMIT_EXCEEDED) |
54001 | Too complex statement (STATEMENT_TOO_COMPLEX) |
54011 | Too many columns (TOO_MANY_COLUMNS) |
54023 | Too many parameters (TOO_MANY_ARGUMENTS) |
Class 55 - The object is not in the prerequisite state | |
55000 | The object is not in the prerequisite state (OBJECT_NOT_IN_PREREQUISITE_STATE) |
55006 | The object is in use (OBJECT_IN_USE) |
55P02 | Runtime parameter cannot be modified (CANT_CHANGE_RUNTIME_PARAM) |
55P03 | Lock unavailable (LOCK_NOT_AVAILABLE) |
Class 57 - Operator intervention | |
57000 | Operator intervention (OPERATOR_INTERVENTION) |
57014 | Query canceled (QUERY_CANCELED) |
57015 | Internal query canceled (QUERY_INTERNAL_CANCEL) |
57P01 | System closed by the admin (ADMIN_SHUTDOWN) |
57P02 | Crash shutdown (CRASH_SHUTDOWN) |
57P03 | Connection not allowed (CANNOT_CONNECT_NOW) |
57P04 | Dropped database (DATABASE_DROPPED) |
Class 58 - System error (MogDB internal error) | |
58000 | System error (SYSTEM_ERROR) |
58030 | IO error (IO_ERROR) |
58P01 | Undefined file (UNDEFINED_FILE) |
58P02 | Duplicate file (DUPLICATE_FILE) |
Class F0 - Configuration file error | |
F0000 | Configuration file error (CONFIG_FILE_ERROR) |
F0001 | Lock file exists (LOCK_FILE_EXISTS) |
Class HV - External data error (SQL/MED) | |
HV000 | External data error (FDW_ERROR) |
HV005 | No name found (FDW_COLUMN_NAME_NOT_FOUND) |
HV002 | Dynamic parameter value required (FDW_DYNAMIC_PARAMETER_VALUE_NEEDED) |
HV010 | Function sequence error (FDW_FUNCTION_SEQUENCE_ERROR) |
HV021 | Inconsistent description information (FDW_INCONSISTENT_DESCRIPTOR_INFORMATION) |
HV024 | Invalid attribute value (FDW_INVALID_ATTRIBUTE_VALUE) |
HV007 | Invalid column name (FDW_INVALID_COLUMN_NAME) |
HV008 | Invalid column number (FDW_INVALID_COLUMN_NUMBER) |
HV004 | Invalid data type (FDW_INVALID_DATA_TYPE) |
HV006 | Invalid data type descriptor (FDW_INVALID_DATA_TYPE_DESCRIPTORS) |
HV091 | Invalid filed identifier (FDW_INVALID_DESCRIPTOR_FIELD_IDENTIFIER) |
HV00B | Invalid handling (FDW_INVALID_HANDLE) |
HV00C | Invalid index option (FDW_INVALID_OPTION_INDEX) |
HV00D | Invalid option name (FDW_INVALID_OPTION_NAME) |
HV090 | Invalid string length or buffer length (FDW_INVALID_STRING_LENGTH_OR_BUFFER_LENGTH) |
HV00A | Invalid string format (FDW_INVALID_STRING_FORMAT) |
HV009 | Invalid use of null pointer (FDW_INVALID_USE_OF_NULL_POINTER) |
HV014 | Too many handles (FDW_TOO_MANY_HANDLES) |
HV001 | Out of memory (FDW_OUT_OF_MEMORY) |
HV00P | No schema (FDW_NO_SCHEMAS) |
HV00J | No option name found (FDW_OPTION_NAME_NOT_FOUND) |
HV00K | Reply handle (FDW_REPLY_HANDLE) |
HV00Q | No schema found (FDW_SCHEMA_NOT_FOUND) |
HV00R | No table found (FDW_TABLE_NOT_FOUND) |
HV00S | Incorrect server type (FDW_INVALID_SERVER_TYPE) |
HV00L | Unable to establish execution (FDW_UNABLE_TO_CREATE_EXECUTION) |
HV00M | Unable to create reply (FDW_UNABLE_TO_CREATE_REPLY) |
HV00N | Unable to establish connection (FDW_UNABLE_TO_ESTABLISH_CONNECTION) |
Class P0 - PL/pgSQL error | |
P0000 | PLPGSQL error (PLPGSQL_ERROR) |
P0001 | Raise exception (RAISE_EXCEPTION) |
P0002 | No data found (NO_DATA_FOUND) |
P0003 | Too many rows (TOO_MANY_ROWS) |
P0004 | FORALL requires DML operation (FORALL_NEED_DML) |
Class XX - Interval error | |
XX000 | Interval error (INTERNAL_ERROR) |
XX001 | Data corrupted (DATA_CORRUPTED) |
XX002 | Index corrupted (INDEX_CORRUPTED) |
XX003 | Remote stream socket closed (STREAM_REMOTE_CLOSE_SOCKET) |
XX004 | Unrecognized node type (ERRCODE_UNRECOGNIZED_NODE_TYPE) |
XX005 | Unexpected null value (ERRCODE_UNEXPECTED_NULL_VALUE) |
XX006 | Unexpected node state (ERRCODE_UNEXPECTED_NODE_STATE) |
XX007 | Null JUNK attribute (ERRCODE_NULL_JUNK_ATTRIBUTE) |
XX008 | Inconsistent optimizer state (ERRCODE_OPTIMIZER_INCONSISTENT_STATE) |
XX009 | Duplicate query ID (ERRCODE_STREAM_DUPLICATE_QUERY_ID) |
XX010 | Invalid buffer (INVALID_BUFFER) |
XX011 | Invalid buffer reference (INVALID_BUFFER_REFERENCE) |
XX012 | Node ID mismatch (ERRCODE_NODE_ID_MISSMATCH) |
XX013 | XID base cannot be modified (CANNOT_MODIFY_XIDBASE) |
XX014 | Unexpected TOAST table data damage (UNEXPECTED_CHUNK_VALUE) |
Class YY - SQL retry error | |
YY001 | Connection reset by peer (CONNECTION_RESET_BY_PEER) |
YY002 | Stream connection reset by peer (STREAM_CONNECTION_RESET_BY_PEER) |
YY003 | Lock wait timeout (LOCK_WAIT_TIMEOUT) |
YY004 | Connection timed out (CONNECTION_TIMED_OUT) |
YY005 | Set query error (SET_QUERY_ERROR) |
YY006 | Out of logical memory (OUT_OF_LOGICAL_MEMORY) |
YY007 | SCTP memory allocated (SCTP_MEMORY_ALLOC) |
YY008 | SCTP no data in buffer (SCTP_NO_DATA_IN_BUFFER) |
YY009 | SCTP release memory close (SCTP_RELEASE_MEMORY_CLOSE) |
YY010 | SCTP and TCP disconnected (SCTP_TCP_DISCONNECT) |
YY011 | SCTP disconnected (SCTP_DISCONNECT) |
YY012 | SCTP remote close (SCTP_REMOTE_CLOSE) |
YY013 | SCTP wait poll unknown (SCTP_WAIT_POLL_UNKNOW) |
YY014 | Invalid snapshot (SNAPSHOT_INVALID) |
YY015 | Connection receive error (ERRCODE_CONNECTION_RECEIVE_WRONG) |
Class SI - SPI interface error | |
SP000 | SPI interface error (ERRCODE_SPI_ERROR) |
SP001 | SPI connection failure (ERRCODE_SPI_CONNECTION_FAILURE) |
SP002 | SPI finish failure (ERRCODE_SPI_FINISH_FAILURE) |
SP003 | SPI preparation failure (ERRCODE_SPI_PREPARE_FAILURE) |
SP004 | SPI cursor open failure (ERRCODE_SPI_CURSOR_OPEN_FAILURE) |
SP005 | SPI execution failure (ERRCODE_SPI_EXECUTE_FAILURE) |
SP006 | Improper call of SPI (ERRORCODE_SPI_IMPROPER_CALL) |
RB class - RBTree error | |
RB001 | RBTree invalid node state (RBTREE_INVALID_NODE_STATE) |
RB002 | RBTree invalid iterator order (RBTREE_INVALID_ITERATOR_ORDER) |
Class PD - PL debug server internal error | |
D0000 | PL debug server internal error (PLDEBUGGER_INTERNAL_ERROR) |
D0001 | Duplicate breakpoint (DUPLICATE_BREAKPOINT) |
D0002 | Hash function is not initialized (FUNCTION_HASH_IS_NOT_INITIALIZED) |
D0003 | Breakpoint is not present (BREAKPOINT_IS_NOT_PRESENT) |
D0004 | Debug server already attached (DEBUG_SERVER_ALREADY_IS_ATTACHED) |
D0005 | Debug server not attached (DEBUG_SERVER_NOT_ATTACHED) |
D0006 | Debug server already in synchronization (DEBUG_SERVER_ALREADY_IN_SYNC) |
D0007 | Debug target server not in synchronization (DEBUG_TARGET_SERVERS_NOT_IN_SYNC) |
D0008 | Target server already in synchronization (TARGET_SERVER_ALREADY_IN_SYNC) |
D0009 | The variable does not exist (NON_EXISTANT_VARIABLE) |
D0010 | Invalid target session ID (INVALID_TARGET_SESSION_ID) |
D0011 | Invalid operation (INVALID_OPERATION) |
D0012 | Maximum number of debug sessions reached (MAXIMUM_NUMBER_OF_DEBUG_SESSIONS_REACHED) |
D0013 | Maximum number of breakpoints reached (MAXIMUM_NUMBER_OF_BREAKPOINTS_REACHED) |
LL - Logical decoding error | |
LL001 | Logical decoding error (LOGICAL_DECODE_ERROR) |
LL002 | Hash table query error (RELFILENODEMAP) |