v4.2.1_CE_BP4

Version information

Information	Description
Release date	March 5, 2024
Version	V4.2.1_CE_BP4
Commit number	3246b00
OBServer RPM version	oceanbase-ce-4.2.1.4-104000052024022918

Enhanced features

• The overwrite feature is now supported for OBKV Batch Put. To use this feature, you must first upgrade your client to the latest version.
• The manual partition transfer now can be cancelled.
• The query performance is now improved for query statements that contain multiple MIN or MAX functions.
• The index status now can be determined based on the COMMENT field in the information_schema.STATISTICS view.

Product behavioral changes

• The TENANT keyword is changed from a required parameter to an optional one in the table-level restore statement.
• The max_syslog_file_count parameter is changed to control the total number of log files of all types.

Bug fixes

• Fixed the issue where the return result for a UNION ALL operation on TIMESTAMP data may be inaccurate.
• Fixed the issue where Error 4016 is returned for a rewrite failure that occurs due to a parsing error when SELECT and JOIN statements are both used in PS mode.
• Fixed the issue where the performance of the HBase PUT operation of OBKV is affected by the system variable binlog_row_image.
• Fixed the issue where the upgrade_post.py script fails to execute when an upgrade is performed after the enable_rebalance parameter is manually disabled.
• Fixed the issue where memory leaks may occur in the SeArray module when an SQL statement accesses multiple sequences.
• Fixed the issue where SQL execution is stuck due to a deadlock caused by insufficient RPC threads when multiple SQL statements are executed in distributed mode and resource isolation is enabled.
• Fixed the issue where some parameters may fail to be synchronized an ALTER SYSTEM SET statement is used to modify multiple parameters.
• Fixed the issue where a cluster with a large number of tablets becomes unavailable when it is restarted. This is because all tablets in virtual tables are scanned during the restart, which occupies threads and leads to accumulation in the queue.
• Fixed the issue where CPU utilization remains high in a no-load scenario due to conflicts between automatic cleanup tasks when there exists a very large amount of historical statistics. Such conflicts occur when tasks on the previous day are not completed within 24 hours but new tasks are triggered on the current day.
• Fixed the issue where Error 4013 may be returned due to insufficient memory of the sys tenant when the DROP DATABASE statement is executed in a cluster with small specifications.
• Fixed the issue where the import task times out and cannot normally exit due to incorrect stop judgment logic when a large amount of data is imported in bypass mode.
• Fixed the issue where a major compaction cannot be started due to frequent transfer retries during RootService scheduling.
• Fixed the issue where TPS jitter occurs during unit migration and replication in weak-consistency read scenarios.
• Fixed the issue where the query result is inconsistent with that in MySQL when a query statement contains a field whose name starts with a digit.

版本信息

项目	描述
发布日期	2024-03-05
版本号	V4.2.1_CE_BP4
Commit 号	3246b00
OBServer RPM 版本号	oceanbase-ce-4.2.1.4-104000052024022918

特性增强

• OBKV Batch Put 现支持覆盖写功能，使用该功能前需要升级到最新版本的客户端。
• 手动迁移分区功能支持 Cancel。
• 优化查询语句中包含多个 MIN 或 MAX 函数时的查询性能。
• 支持通过 information_schema.STATISTICS 的 COMMENT 字段来判断索引状态。

产品行为变更

• 表级恢复命令调整 TENANT 关键字为可选。
• max_syslog_file_count 调整为控制所有类型的 Log 总量。

缺陷修复

• 修复对 TIMESTAMP 类型的数据进行 Union All 操作时，返回结果可能不正确的问题。
• 修复 PS 模式下包含 Select 和 Join 语句时，可能存在解析问题导致改写无法正确处理报错 4016 的问题。
• 修复 OBKV HBase Put 接口性能问题，修复后性能不受 binlog_row_image 系统变量的影响。
• 修复用户手动关闭 enable_rebalance 参数后升级，执行 upgrade_post.py 脚本失败的问题。
• 修复 SQL 访问多个 Sequence 场景下，可能存在的 SeArray 模块内存泄漏的问题。
• 修复使用资源隔离的场景下，当存在多条 SQL 有分布式执行场景下，可能存在 RPC 线程不足引发死锁，导致 SQL 执行卡住的问题。
• 修复通过一条 ALTER SYSTEM SET 语句修改多个配置项时，可能出现部分配置项同步失败的问题。
• 修复 Tablet 数量过多场景下，重启集群时虚表扫描所有 Tablet 占住线程引发队列积压，导致集群不可用的问题。
• 修复当历史统计信息数据量非常大的情况下，当天的清理任务 24 小时没有执行完，第二天又发起了新的自动清理任务，出现并发冲突，导致空载场景下，CPU 利用率一直很高的问题。
• 修复小规格场景下，执行 DROP DATABASE 可能由于 sys 租户内存过小报错 4013 的问题。
• 修复旁路导入大量数据时，可能由于 Stop 判断逻辑问题导致超时无法正常退出的问题。
• 修复因 RS 调度中 Transfer 重试过于频繁，导致无法启动合并操作的问题。
• 修复弱读业务场景下，Unit 迁移复制过程中 TPS 抖动的问题。
• 修复查询中包含数字开头的字段名时，与 MySQL 表现不一致的问题。