openGauss

开源数据库

openGauss社区官网

开源社区

新闻chevron-rightopenGauss 5.0.5版本正式发布！

openGauss 5.0.5版本正式发布！

openGauss2025-12-30theme

版本介绍 ​

openGauss 5.0.5 Update版本是openGauss 5.0.0 Release的第四个补丁版本。基于5.0.3补丁版本基础上，回合和修复了一些影响功能的缺陷，发布5.0.5补丁版本。

升级路径支持 ​

基础版本目标版本
3.0.5(不带CM + 带CM)5.0.5(不带CM + 带CM)
5.0.0(不带CM + 带CM)5.0.5(不带CM + 带CM)
5.0.1(不带CM + 带CM)5.0.5(不带CM + 带CM)
5.0.2(不带CM + 带CM)5.0.5(不带CM + 带CM)
5.0.3(不带CM + 带CM)5.0.5(不带CM + 带CM)
5.0.5(不带CM + 带CM)master(不带CM + 带CM)

回合需求 ​

描述PR链接
延迟备机优化需求https://gitee.com/opengauss/openGauss-server/pulls/6082
添加gs_lwlock_status视图https://gitee.com/opengauss/openGauss-server/pulls/6220
I9HZ82 备库日志回放能力增强，新增一种日志分发算法https://gitee.com/opengauss/openGauss-server/pulls/5136
enable组dispatch，从而提升并行恢复的redo效率https://gitee.com/opengauss/openGauss-server/pulls/3878
dss支持增量buildhttps://gitee.com/opengauss/DCC/pulls/24

回合缺陷 ​

统计 ​

仓库转测问题单
5.0.5B00139
5.0.5B0025
总计44

5.0.5B001转测列表 ​

标题issuePR
GUC参数无法使备机关闭CBM线程https://e.gitee.com/opengaussorg/dashboard?issue=I8NPJPhttps://gitee.com/opengauss/openGauss-server/pulls/4610
修复gs_xlog_keepers函数在升级前后在pg_proc显示不同的bug，第二次修改https://e.gitee.com/opengaussorg/dashboard?issue=I9P3QOhttps://gitee.com/opengauss/openGauss-server/pulls/6037
pg_terminate_active_session_socket builtini里面添加参数名称https://e.gitee.com/opengaussorg/dashboard?issue=I9P3QOhttps://gitee.com/opengauss/openGauss-server/pulls/6102
[OpenUndoFile:402]could not open undo file "undo/permanent/00004.meta.0000000": No such file or directoryhttps://e.gitee.com/opengaussorg/dashboard?issue=IAL72Xhttps://gitee.com/opengauss/openGauss-server/pulls/6188
Debug 模式下重建系统表索引，可能触发 Assert （!ReindexIsProcessingIndex）导致进程退出https://e.gitee.com/opengaussorg/dashboard?issue=I96604https://gitee.com/opengauss/openGauss-server/pulls/5071
模拟业务insert分区表同时，分区表执行vacuum full，会检测到死锁https://e.gitee.com/opengaussorg/dashboard?issue=IAAT1Lhttps://gitee.com/opengauss/openGauss-server/pulls/6200
字符集增加pg_descriptionhttps://e.gitee.com/opengaussorg/dashboard?issue=I9P3QOhttps://gitee.com/opengauss/openGauss-server/pulls/6343
表分区删除后，执行查询语句报错partition does not exist【M】https://e.gitee.com/opengaussorg/dashboard?issue=IA931Uhttps://gitee.com/opengauss/openGauss-server/pulls/6369
社区发布的包不包含 ecpg相关头文件，导致无法使用ecpg [XY]https://e.gitee.com/opengaussorg/dashboard?issue=I92YYZhttps://gitee.com/opengauss/openGauss-server/pulls/5695
当表空间设置成最大值后，并发插入数据并撑满表空间，发生corehttps://e.gitee.com/opengaussorg/dashboard?issue=IAPAW1https://gitee.com/opengauss/openGauss-server/pulls/6237
【测试类型：功能测试】【测试版本：6.0.0】使用substring函数时报错https://e.gitee.com/opengaussorg/dashboard?issue=I96BCHhttps://gitee.com/opengauss/openGauss-server/pulls/5893
hash 索引回放在 hash_xlog_split_allocate_page corehttps://e.gitee.com/opengaussorg/dashboard?issue=I96EY4https://gitee.com/opengauss/openGauss-server/pulls/5208
3.0.5升级到5.0.3，回滚后函数pg_terminate_active_session_socket丢失https://e.gitee.com/opengaussorg/dashboard?issue=IB4T4Ohttps://gitee.com/opengauss/openGauss-server/pulls/6681
【mysql兼容性】group_concat在结果字符串长度小于4时概率报错https://e.gitee.com/opengaussorg/dashboard?issue=IB5ENThttps://gitee.com/opengauss/openGauss-server/pulls/6700
支持switchover超时打印数据库内核的堆栈https://e.gitee.com/opengaussorg/dashboard?issue=I6DCAOhttps://gitee.com/opengauss/openGauss-server/pulls/6710
ThreadPoolSessControl::CheckIdleInTransactionSessionTimeout()中计数变量错误https://e.gitee.com/opengaussorg/dashboard?issue=IAPBG8https://gitee.com/opengauss/openGauss-server/pulls/6238
bin/script下的工具help命令有内存泄漏https://gitee.com/opengauss/openGauss-server/issues/IAX8GOhttps://gitee.com/opengauss/openGauss-server/pulls/6532
createuser工具在密码不合规情况下有内存泄漏https://e.gitee.com/opengaussorg/dashboard?issue=IAX8BXhttps://gitee.com/opengauss/openGauss-server/pulls/6531
由于CPU乱序可能会发生较小的xid(xid<page base_id)插入到page中的情况https://e.gitee.com/opengaussorg/dashboard?issue=I8H74Uhttps://gitee.com/opengauss/openGauss-server/pulls/6919
recovery_min_apply_delay修改后无需重启才能生效为新_x005f设置值【M】https://e.gitee.com/opengaussorg/dashboard?issue=IB4BQVhttps://gitee.com/opengauss/openGauss-server/pulls/7037
update_lockwait_timeout参数不生效https://e.gitee.com/opengaussorg/dashboard?issue=IBPBPOhttps://gitee.com/opengauss/openGauss-server/pulls/7251
并行回放场景下，分区表在开启autovacuum后，执行大量的update操作+global索引操作将导致回放性能下降【xy】https://e.gitee.com/opengaussorg/dashboard?issue=I8LMB0https://gitee.com/opengauss/openGauss-server/pulls/7195
create view 中含有connect by会报错https://e.gitee.com/opengaussorg/dashboard?issue=IBBUB6https://gitee.com/opengauss/openGauss-server/pulls/7477
修改表结构后相关的查询报错【M】https://e.gitee.com/opengaussorg/dashboard?issue=I98WM5https://gitee.com/opengauss/openGauss-server/pulls/7502
主备切换过程中主机降备时候逻辑复制相关的walsender线程没退出导致切换失败【YC】https://e.gitee.com/opengaussorg/issues/table?issue=IBY8ZRhttps://gitee.com/opengauss/openGauss-server/pulls/7513
gs_probackup工具中pgut_execute_extended函数有libpq内存泄漏https://e.gitee.com/opengaussorg/dashboard?issue=IAJ27Jhttps://gitee.com/opengauss/openGauss-server/pulls/7544
分区表 drop index concurrently 和 reindex partition 同时执行，在 debug 版本有概率触发 Asserthttps://e.gitee.com/opengaussorg/dashboard?issue=IAOKGKhttps://gitee.com/opengauss/openGauss-server/pulls/6205
Startup回放线程卡死，回放不进行https://e.gitee.com/opengaussorg/dashboard?issue=IAJAKOhttps://gitee.com/opengauss/openGauss-server/pulls/7563
debug版本修改enable_incremental_checkpoint = on -> off 产生 coredumphttps://e.gitee.com/opengaussorg/issues/table?issue=I88WBUhttps://gitee.com/opengauss/openGauss-server/pulls/7572
修复tinyint index in int array报错https://e.gitee.com/opengaussorg/dashboard?issue=IC3CCLhttps://gitee.com/opengauss/openGauss-server/pulls/7594
optimize smp quit condition, add log for tracehttps://e.gitee.com/opengaussorg/dashboard?issue=I7L7EIhttps://gitee.com/opengauss/openGauss-server/pulls/3784
支持修改计划缓存（plan cache）的结果类型https://e.gitee.com/opengaussorg/dashboard?issue=I98WM5https://gitee.com/opengauss/openGauss-server/pulls/5157
fix CVE-2025-1094https://e.gitee.com/opengaussorg/dashboard?issue=IBQHTPhttps://gitee.com/opengauss/openGauss-server/pulls/7329
resolve the issue csnlog cannot truncate when enable_ustore set offhttps://e.gitee.com/opengaussorg/dashboard?issue=IBGJVShttps://gitee.com/opengauss/openGauss-server/pulls/7095
【B库兼容】使用 create table t2 like t1 创建表，数据库coredump掉【zyzx】https://e.gitee.com/opengaussorg/dashboard?issue=IBBU7Ohttps://gitee.com/opengauss/Plugin/pulls/1932
当in条件后字符序与表字符序不符合时，执行查询数据库corehttps://e.gitee.com/opengaussorg/dashboard?issue=IBF4BEhttps://gitee.com/opengauss/openGauss-server/pulls/6961
修复编码转换时保存常量地址导致的core问题https://e.gitee.com/opengaussorg/dashboard?issue=IB8X4Ihttps://gitee.com/opengauss/openGauss-server/pulls/6809
偶现autoanalyze或autovacuum不及时导致出现慢sqlhttps://e.gitee.com/opengaussorg/dashboard?issue=I8WAC0https://gitee.com/opengauss/openGauss-server/pulls/4908
批量插入在opfusion下疑似内存泄漏[lm]https://e.gitee.com/opengaussorg/dashboard?issue=IB0QG4https://gitee.com/opengauss/openGauss-server/pulls/7365

5.0.5B002 转测列表 ​

标题PRissue
【升级】5.0.5以下多个版本带cm指定节点升级至5.0.5带cm失败https://gitcode.com/opengauss/openGauss-OM/pull/1095https://gitcode.com/opengauss/openGauss-server/issues/7007
【升级】3.0.5/3.0.6/5.0.0/5.0.1/5.0.2/5.0.3不带cm指定节点升级至5.0.5带cm失败https://gitcode.com/opengauss/openGauss-OM/pull/1094https://gitcode.com/opengauss/openGauss-server/issues/7006
gs_probackup执行备份时发生core dumphttps://gitcode.com/opengauss/openGauss-server/pull/7756https://gitcode.com/opengauss/openGauss-server/issues/7004
5.0.1/5.0.2/5.0.3升级至5.0.5对比直装5.0.5元数据不一致问题（gs_xlog_keepers）https://gitcode.com/opengauss/openGauss-server/pull/7804https://gitcode.com/opengauss/openGauss-server/issues/7012
修复upsert在冲突场景下逻辑解码的问题https://gitcode.com/opengauss/openGauss-server/pull/7792https://gitcode.com/opengauss/openGauss-server/issues/7065

安全漏洞 ​

CVE漏洞修复PR
CVE-2025-1094https://gitee.com/opengauss/openGauss-server/pulls/7329

附录 ​

5.0.5版本测试报告： https://gitcode.com/opengauss/QA/tree/master/Test_Result/openGauss_5.0.5