v4.2.1_CE_BP4
版本发布时间: 2024-03-05 16:12:04
oceanbase/oceanbase最新发布版本:v4.2.4_CE(2024-07-15 09:44:43)
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
MINorMAXfunctions. - The index status now can be determined based on the
COMMENTfield in theinformation_schema.STATISTICSview.
Product behavioral changes
- The
TENANTkeyword is changed from a required parameter to an optional one in the table-level restore statement. - The
max_syslog_file_countparameter 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 ALLoperation onTIMESTAMPdata 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.pyscript fails to execute when an upgrade is performed after theenable_rebalanceparameter 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 SETstatement 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 DATABASEstatement 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 表现不一致的问题。
1、 oceanbase-ce-4.2.1.4-104000052024022918.el7.aarch64.rpm 76.88MB
2、 oceanbase-ce-4.2.1.4-104000052024022918.el7.x86_64.rpm 94.2MB
3、 oceanbase-ce-4.2.1.4-104000052024022918.el8.aarch64.rpm 76.89MB
4、 oceanbase-ce-4.2.1.4-104000052024022918.el8.x86_64.rpm 94.25MB
5、 oceanbase-ce-libs-4.2.1.4-104000052024022918.el7.aarch64.rpm 143.93KB
6、 oceanbase-ce-libs-4.2.1.4-104000052024022918.el7.x86_64.rpm 154.63KB
7、 oceanbase-ce-libs-4.2.1.4-104000052024022918.el8.aarch64.rpm 150.77KB
8、 oceanbase-ce-libs-4.2.1.4-104000052024022918.el8.x86_64.rpm 159.36KB
9、 oceanbase-ce-sql-parser-4.2.1.4-104000052024022918.el7.aarch64.rpm 958.03KB
10、 oceanbase-ce-sql-parser-4.2.1.4-104000052024022918.el7.x86_64.rpm 991.59KB
11、 oceanbase-ce-sql-parser-4.2.1.4-104000052024022918.el8.aarch64.rpm 962.33KB
12、 oceanbase-ce-sql-parser-4.2.1.4-104000052024022918.el8.x86_64.rpm 995.91KB
13、 oceanbase-ce-table-4.2.1.4-104000052024022918.el7.aarch64.rpm 42.59MB
14、 oceanbase-ce-table-4.2.1.4-104000052024022918.el7.x86_64.rpm 41.48MB
15、 oceanbase-ce-table-4.2.1.4-104000052024022918.el8.aarch64.rpm 42.59MB
16、 oceanbase-ce-table-4.2.1.4-104000052024022918.el8.x86_64.rpm 41.49MB
17、 oceanbase-ce-utils-4.2.1.4-104000052024022918.el7.aarch64.rpm 65.51MB
18、 oceanbase-ce-utils-4.2.1.4-104000052024022918.el7.x86_64.rpm 80.82MB
19、 oceanbase-ce-utils-4.2.1.4-104000052024022918.el8.aarch64.rpm 65.55MB
20、 oceanbase-ce-utils-4.2.1.4-104000052024022918.el8.x86_64.rpm 80.77MB