OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Database

SQL - V4.2.2

    Download PDF

    OceanBase logo

    The Unified Distributed Database for the AI Era.

    Follow Us
    Products
    OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
    Resources
    DocsBlogLive DemosTraining & Certification
    Company
    About OceanBaseTrust CenterLegalPartnerContact Us
    Follow Us

    © OceanBase 2026. All rights reserved

    Cloud Service AgreementPrivacy PolicySecurity
    Contact Us
    Document Feedback
    1. Documentation Center
    2. OceanBase Database
    3. SQL
    4. V4.2.2
    iconOceanBase Database
    SQL - V 4.2.2
    SQL
    KV
    • V 4.4.2
    • V 4.3.5
    • V 4.3.3
    • V 4.3.1
    • V 4.3.0
    • V 4.2.5
    • V 4.2.2
    • V 4.2.1
    • V 4.2.0
    • V 4.1.0
    • V 4.0.0
    • V 3.1.4 and earlier

    Overview

    Last Updated:2026-04-15 08:27:13  Updated
    share
    What is on this page
    Limitations
    Considerations
    Upgrade procedure
    Upgrade notes
    Next steps
    References

    folded

    share

    OceanBase clusters can be upgraded by using upgrade scripts. The upgrade process is transparent to applications, so you do not need to perform any write or service suspension operations with your applications during the upgrade. OceanBase clusters are upgraded by zone. During the upgrade, the system will perform an active switchover of leader partitions among zones and route the business of the to-be-upgraded zone to other zones.

    This topic describes the upgrade limitations, considerations, and paths of OceanBase Database.

    Notice

    OceanBase Database Clusters cannot be upgraded in place from versions earlier than V4.0.0 to V4.x.

    Limitations

    There are the following limitations on OceanBase clusters during an upgrade:

    • DDL is prohibited: DDL is prohibited during some stages of the upgrade. It will be automatically enabled after the upgrade is complete.
    • major freeze is prohibited: When upgrading between some versions, major compactions are prohibited. It will be automatically enabled after the upgrade is complete.
    • Replication and load balancing are prohibited: When upgrading between some versions, replication and load balancing are prohibited.
    • Physical backup and restore are prohibited: During an upgrade, physical baseline backups (log archives are not affected) and restores are prohibited.
    • Creating tenants is prohibited.

    Notice

    If the OceanBase cluster is associated with the arbitration service, make sure to upgrade the arbitration service version first, and then upgrade the OceanBase cluster version. For more information, see Upgrade the arbitration service.
    You can query the oceanbase.DBA_OB_ARBITRATION_SERVICE system view in the sys tenant of OceanBase Database to check whether the OceanBase cluster is associated with the arbitration service.

    Considerations

    When upgrading an OceanBase cluster, note the following points:

    • Log archiving will be interrupted during an upgrade from OceanBase Database V4.0 to V4.1.

    • If the upgrade requires ADD SERVER/DELETE SERVER operations, contact the technical support team for assistance.

    • OceanBase Database of earlier versions cannot be directly upgraded. Follow the upgrade sequence in the oceanbase_upgrade_dep.yml file.

    • You must directly connect to the observer process where the Root Service is located to run the upgrade script. You cannot use OceanBase Database Proxy (ODP) to connect to the database.

    • The following parameter changes may occur during the upgrade. Back up these parameters before the upgrade:

      • server_permanent_offline_time
      • enable_rebalance
      • enable_rereplication
    • Starting from V4.2.2, OceanBase Database no longer supports the zlib_1.0 compression algorithm. The upgrade check will perform the following check before the upgrade:

    • The zlib compression algorithm is no longer supported as the value of the log_transport_compress_func parameter during an upgrade. Please use another compression algorithm instead.

    • If you find that some tables use the zlib compression algorithm during the upgrade, replace the compression algorithm with a supported one or disable compression.

    • The zlib compression algorithm is not supported for OBKV-Table connections during an upgrade. Set the kv_transport_compress_func parameter to use a different compression algorithm.

    Upgrade procedure

    The upgrade scripts in OceanBase Database V4.x rely only on the Python scripts in the target version's RPM package. Specifically, if the target version is V4.1.0 or later, only one upgrade process is available, and you need only the OceanBase RPM package of the target version. After decompressing the OceanBase RPM package, you will find the oceanbase_upgrade_dep.yml file, which records the version upgrade topology of OceanBase Database.

    For more information about the upgrade process, see Step 2: Verify the upgrade procedure in Upgrade an OceanBase cluster.

    Upgrade notes

    • OceanBase Database V4.2.1 BP2 and earlier of the V4.x series are supported to upgrade to OceanBase Database V4.2.2 online through effective upgrade paths. OceanBase Database V4.2.1 BP3 and later do not support upgrading to V4.2.2. As V4.2.1 and V4.2.x evolve in parallel, later BPs of V4.2.1 will support upgrading to later versions of V4.2.x.
    • During the upgrade, the system automatically disables major compactions and DDL operations. After the upgrade is completed, the operations resume.

    Next steps

    References

    For more information about how to upgrade an OceanBase cluster using OceanBase Cloud Platform (OCP), see Upgrade versions.

    Previous topic

    Modify cluster parameters
    Last

    Next topic

    Upgrade the arbitration service
    Next
    What is on this page
    Limitations
    Considerations
    Upgrade procedure
    Upgrade notes
    Next steps
    References