Oceanbase-py

2.[Bug]: Unit testing make fail [1273](https://github.com/oceanbase/oceanbase/issues/1273)
3.[fix last_active_time reset bug when change user](https://github.com/oceanbase/oceanbase/commit/05bbad0279302d7274e1b5ab79323a2c915c1981)
4.[fix physical restore report -4018 issue](https://github.com/oceanbase/oceanbase/commit/18239ac5ac6d6f792a5b5eae24a625720032a1d9)
5.[[CP] [CP] fix connect by memory leak](https://github.com/oceanbase/oceanbase/commit/4ee2a7c01273926462bad240c834c0247d5bd6fa)
6.[fix size overflow when reconstruct sql](https://github.com/oceanbase/oceanbase/commit/1c33b444b427890d84cb1d67e62f9817e37985ea)
7.[Fix 4.0.0 allocator deconstruction core bug](https://github.com/oceanbase/oceanbase/commit/ee12d0a117593bd5f695438066a7a25c42a401ec)
8.[Fix migration reuse local major makes checksum error](https://github.com/oceanbase/oceanbase/commit/ef64034bb6debd672bb0ebfa86f00f0a707dec2d)
9.[fix insert oom caused by wrap allocator's interface empty](https://github.com/oceanbase/oceanbase/commit/2f25509e6040626ac74b03b57e32f120fd7be484)
10.[Fix full outer join with for update causing core](https://github.com/oceanbase/oceanbase/commit/fe7b61a9073b429d7df7c62f60061033725fcea9)
11.[Fix observer core at create tablet for migration](https://github.com/oceanbase/oceanbase/commit/28d044b0bbfa015ee75dab7d570c734d51fa1fde)
12.[fix null complex argument core](https://github.com/oceanbase/oceanbase/commit/9989eaade13e399b4af76861e35c833e926c38b0)
13.[Fix deadlock when auto increment service alloc handle](https://github.com/oceanbase/oceanbase/commit/c1960bf668c793650cf18f3a33fe4cd0f5a73ab5)
14.[fix ret= -4016 when switch leader](https://github.com/oceanbase/oceanbase/commit/e2e7605a36dc6027523323b1b194658bac6320a9)
15.[fix merge into result error when hitting plan cache](https://github.com/oceanbase/oceanbase/commit/e5470f1b5d7795ebfff3b2b86e77638645579036)
注意事项

1. obdv1.6.2开始支持4.0 observer版本间的升级；
2. ocp4.0-ce-bp1版本开始支持observer版本间升级；


v4.0.0_CE_BP2

| **配置项** | **用途及不兼容点说明** | **状态变化** |
|---------|----------|----------|
|minor_warm_up_duration_time | 数据预热相关| 废弃|
|minor_deferred_gc_time |转储完成延迟回收 SSTable 的时间 |废弃|
|_minor_deferred_gc_level| 转储完成延迟回收 SSTable 的级别 |废弃|
|max_kept_major_version_number |最多保存 major 版本数量| 废弃|
|_enable_sparse_row | 是否开启稀疏行| 废弃|
|minor_freeze_times |两次 major 之间的 minor 次数 |废弃|
|clog_usage_limit_size| 日志盘使用总空间，改由租户 unit config 设置 |废弃|
|enable_separate_sys_clog| 系统表、用户表日志流分离存储| 废弃|
|clog_max_unconfirmed_log_count| 滑动窗口长度| 废弃|
|_ob_clog_disk_buffer_cnt |batch buffer 的数目 |废弃|
|clog_cache_priority |clog cache 优先级 |废弃|
|index_clog_cache_priority| ilog cache 优先级 |废弃|
|_clog_aggregation_buffer_amount| 聚合提交所使用的 buffer 数目| 废弃|
|_flush_clog_aggregation_buffer_timeout| 聚合提交 freeze 间隔| 废弃|
|_enable_clog_rpc_aggregation| 是否对所有日志 RPC 开启聚合| 废弃|
|system_cpu_quota| 500 租户 CPU 规格| 废弃|
|flush_log_at_trx_commit| 对标 MySQL 同名配置项| 废弃|
|election_cpu_quota| election 租户 CPU 规格 |废弃|
|enable_election_group| 是否开启选举虚拟组 |废弃|
|enable_log_archive| 是否开启日志归档| 废弃|
|clog_disk_usage_limit_percentage| 日志盘使用空间占总磁盘空间的上限|废弃|
|clog_disk_utilization_threshold |日志盘正常运行期间使用空间占总磁盘空间的百分比 | 废弃|
|minor_compact_trigger | 储触分层转储的阈值 |语义变化，集群级配置项变更为租户级配置项|
|major_compact_trigger |冻结后触发版本合并的阈值 |语义变化，集群级配置项变更为租户级配置项|
|freeze_trigger_percentage |转储或合并转储触发阈值 |默认值由 70% 调整为 20%|
|writing_throttling_trigger_percentage |memtable 写入限流触发阈值 |默认值由 100% 调整为 60%|
|writing_throttling_maximum_duration |memtable 写入限流时长 | 默认值由 1h 调整为 2h|
|ob_trx_timeout | 事务超时时长 |默认值 100s 调整为 1d|
|ob_trx_idle_timeout | 空闲事务超时时长| 默认值由 120s 调整为 1d|

升级说明

* 不支持从 V3.x 版本在线升级到 V4.0 版本。

* 支持通过 OMS 将 V3.x 版本数据使用逻辑迁移升级到 V4.0 版本。

周边配套

| OceanBase Proxy（OBProxy） | V4.0.0 |

| commit号 | 58fdb0ef1a9b589ef05e56c1ede65e951986d996 |
| OBServer RPM 版本号 | oceanbase-ce-4.0.0.0-102000032022120718 |

发版目的
本次发版主要是BUG修复。
BUG 修复

1. [Bug]: ERROR [CLOG] handle_submit_task_ 导致合并hang住 [1229](https://github.com/oceanbase/oceanbase/issues/1229)
2. observer core at oceanbase::sql::def_relational_eval_func[ 1131](https://github.com/oceanbase/oceanbase/issues/1131)
3. observer core at oceanbase::sql::int_int [1124](https://github.com/oceanbase/oceanbase/issues/1124)
4. observer core at oceanbase::common::ObDatum::get_int [1123](https://github.com/oceanbase/oceanbase/issues/1123)
5. hosts在pl 中被误判为关键字 [1230](https://github.com/oceanbase/oceanbase/issues/1230)

注意事项

1. obdv1.6.2开始支持4.0 observer版本间的升级；
2. ocp4.0暂不支持4.0 observer版本间升级；

Version information
| **Information** | **Description** |
| --- | --- |
| Release date | 2022-12-09 |
| Release number | V4.0.0.0 BP2 |
| Commit number |58fdb0ef1a9b589ef05e56c1ede65e951986d996 |

About this version
To provide better services to community users, OceanBase Community Edition V4.0.0.0BP2 optimizes the database to make it more stable based on the feedback on applications of the community project.
Fixed issues

1. [Bug]: ERROR [CLOG] handle_submit_task_ cause major freeze hang [1229](https://github.com/oceanbase/oceanbase/issues/1229)
2. observer core at oceanbase::sql::def_relational_eval_func[ 1131](https://github.com/oceanbase/oceanbase/issues/1131)
3. observer core at oceanbase::sql::int_int [1124](https://github.com/oceanbase/oceanbase/issues/1124)
4. observer core at oceanbase::common::ObDatum::get_int [1123](https://github.com/oceanbase/oceanbase/issues/1123)
5. [Bug]: Hosts is misidentified as a keyword in pl [1230](https://github.com/oceanbase/oceanbase/issues/1230)

Notes