Hi liikii, welcome to the openEuler Community.
I'm the Bot here serving you. You can find the instructions on how to interact with me at Here.
If you have any questions, please contact the SIG: DB, and any of the maintainers: @zhengzhenyu , @dillon_chen , @nick-slg-kylin , @XIE-JING-2022 , @xicoding


mariadb-embedded-devel包也有类似问题
[root@localhost yum.repos.d]# yum upgrade mariadb-embedded-devel
Last metadata expiration check: 0:00:16 ago on 2024年11月29日 星期五 19时30分27秒.
Dependencies resolved.
==========================================================================================================================================================================================================
Package Architecture Version Repository Size
==========================================================================================================================================================================================================
Upgrading:
mariadb-common x86_64 4:10.5.25-2.oe2403sp1 SP1OS 24 k
mariadb-devel x86_64 4:10.5.25-2.oe2403sp1 SP1OS 1.2 M
mariadb-embedded x86_64 4:10.5.25-2.oe2403sp1 SP1everything 5.2 M
mariadb-embedded-devel x86_64 4:10.5.25-2.oe2403sp1 SP1everything 4.1 k
mariadb-errmsg x86_64 4:10.5.25-2.oe2403sp1 SP1OS 228 k
Installing dependencies:
mariadb-config x86_64 4:10.5.25-2.oe2403sp1 SP1OS 4.2 k
Transaction Summary
==========================================================================================================================================================================================================
Install 1 Package
Upgrade 5 Packages
Total download size: 6.7 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): mariadb-config-10.5.25-2.oe2403sp1.x86_64.rpm 69 kB/s | 4.2 kB 00:00
(2/6): mariadb-common-10.5.25-2.oe2403sp1.x86_64.rpm 233 kB/s | 24 kB 00:00
(3/6): mariadb-errmsg-10.5.25-2.oe2403sp1.x86_64.rpm 1.2 MB/s | 228 kB 00:00
(4/6): mariadb-embedded-devel-10.5.25-2.oe2403sp1.x86_64.rpm 120 kB/s | 4.1 kB 00:00
(5/6): mariadb-devel-10.5.25-2.oe2403sp1.x86_64.rpm 1.9 MB/s | 1.2 MB 00:00
(6/6): mariadb-embedded-10.5.25-2.oe2403sp1.x86_64.rpm 3.7 MB/s | 5.2 MB 00:01
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 4.3 MB/s | 6.7 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'yum clean packages'.
Error: Transaction test error:
file /etc/my.cnf from install of mariadb-config-4:10.5.25-2.oe2403sp1.x86_64 conflicts with file from package greatsql-mysql-config-8.0.32-25.1.oe2403.x86_64


再关注下 mariadb-test为什么去安装 greatsql-test去了
yum install mariadb-test
Last metadata expiration check: 1:11:50 ago on 2024年12月03日 星期二 15时41分46秒.
Dependencies resolved.
==========================================================================================================================================================================================================
Package Architecture Version Repository Size
==========================================================================================================================================================================================================
Installing:
greatsql-test aarch64 8.0.32-26.3.oe2403sp1 everything 391 M
Installing dependencies:
greatsql-client aarch64 8.0.32-26.3.oe2403sp1 everything 18 M
greatsql-icu-data-files aarch64 8.0.32-26.3.oe2403sp1 everything 2.0 M
greatsql-server aarch64 8.0.32-26.3.oe2403sp1 everything 64 M
greatsql-shared aarch64 8.0.32-26.3.oe2403sp1 everything 1.4 M
net-tools aarch64 2.10-4.oe2403sp1 OS 197 k
perl-JSON noarch 4.10-1.oe2403sp1 OS 51 k
Transaction Summary
==========================================================================================================================================================================================================
Install 7 Packages
Total download size: 476 M


mariadb, mysql和greatsql三个软件都是mysql系列的,不能共存,只能三选一个来安装,必须在只能一个存在的情况下测试
@yejr 这位是msyql专业人士,测试发现这3个包有问题先@ 他,请教专业的
没有一起安装, 应该是因为mariadb-embedded, mariadb-embedded-devel在旧版本上依赖了greatsql的包了。 详情见截图



再关注下 mariadb-test为什么去安装 greatsql-test去了
yum install mariadb-test
Last metadata expiration check: 1:11:50 ago on 2024年12月03日 星期二 15时41分46秒.
Dependencies resolved.
==========================================================================================================================================================================================================
Package Architecture Version Repository Size
==========================================================================================================================================================================================================
Installing:
greatsql-test aarch64 8.0.32-26.3.oe2403sp1 everything 391 M
Installing dependencies:
greatsql-client aarch64 8.0.32-26.3.oe2403sp1 everything 18 M
greatsql-icu-data-files aarch64 8.0.32-26.3.oe2403sp1 everything 2.0 M
greatsql-server aarch64 8.0.32-26.3.oe2403sp1 everything 64 M
greatsql-shared aarch64 8.0.32-26.3.oe2403sp1 everything 1.4 M
net-tools aarch64 2.10-4.oe2403sp1 OS 197 k
perl-JSON noarch 4.10-1.oe2403sp1 OS 51 k
Transaction Summary
==========================================================================================================================================================================================================
Install 7 Packages
Total download size: 476 M



再关注下 mariadb-test为什么去安装 greatsql-test去了
yum install mariadb-test
Last metadata expiration check: 1:11:50 ago on 2024年12月03日 星期二 15时41分46秒.
Dependencies resolved.
==========================================================================================================================================================================================================
Package Architecture Version Repository Size
==========================================================================================================================================================================================================
Installing:
greatsql-test aarch64 8.0.32-26.3.oe2403sp1 everything 391 M
Installing dependencies:
greatsql-client aarch64 8.0.32-26.3.oe2403sp1 everything 18 M
greatsql-icu-data-files aarch64 8.0.32-26.3.oe2403sp1 everything 2.0 M
greatsql-server aarch64 8.0.32-26.3.oe2403sp1 everything 64 M
greatsql-shared aarch64 8.0.32-26.3.oe2403sp1 everything 1.4 M
net-tools aarch64 2.10-4.oe2403sp1 OS 197 k
perl-JSON noarch 4.10-1.oe2403sp1 OS 51 k
Transaction Summary
==========================================================================================================================================================================================================
Install 7 Packages
Total download size: 476 M
我感觉是 greatsql 错误的obsolete了mariadb的包。


截至2025年02月17日09时还有 mariadb-embedded引用grealsql相关包的问题
GreatSQL今天刚提交了3个PR,显式声明和MySQL、Percona、MariaDB之间的冲突关系,详见
- https://gitee.com/src-openeuler/greatsql/pulls/105
- https://gitee.com/src-openeuler/greatsql/pulls/106
- https://gitee.com/src-openeuler/greatsql/pulls/107
在MySQL、MariaDB侧是否也需要显式声明这些冲突关系还请 @dillon_chen @fundawang 也帮忙确认,谢谢哈


这个issue,在这个PR里你已经帮忙修复了吧 https://gitee.com/src-openeuler/greatsql/pulls/77 @fundawang 是不是可以关了


@dillon_chen , @ZhengZhenyu , @xicoding , @wbq_sky
以下的要求不是强制性的, 未按模板评论时对issue无任何影响
issue处理注意事项:
1. 当前issue受影响的分支提交pr时, 须在pr描述中填写当前issue编号进行关联, 否则无法关闭当前issue;
2. 模板内容需要填写完整, 无论是受影响或者不受影响都需要填写完整内容,未引入的分支不需要填写, 否则无法关闭当前issue;
3. 以下为模板中需要填写完整的内容, 请复制到评论区回复, 注: 内容的标题名称(影响性分析说明, 缺陷严重等级, 受影响版本排查(受影响/不受影响), 修复是否涉及abi变化(是/否))不能省略,省略后defect-manager将无法正常解析填写内容.
评论区可能使用到的指令说明:
| 指令 | 指令说明 | 使用权限 |
|---|---|---|
| /check-issue | 触发defect-manager校验 | 不限 |
| /reason xxx | /reason +挂起或取消条件 | 不限 |
影响性分析说明:
缺陷严重等级:(Critical/High/Moderate/Low)
缺陷根因说明:
受影响版本排查(受影响/不受影响):
- openEuler-20.03-LTS-SP4:
- openEuler-22.03-LTS-SP3:
- openEuler-22.03-LTS-SP4:
- openEuler-24.03-LTS:
- openEuler-24.03-LTS-SP1:
abi变化(是/否):
- openEuler-20.03-LTS-SP4:
- openEuler-22.03-LTS-SP3:
- openEuler-22.03-LTS-SP4:
- openEuler-24.03-LTS:
- openEuler-24.03-LTS-SP1:
缺陷issue处理具体操作请参考:
https://gitee.com/Coopermassaki/cve-manager/blob/master/cve-vulner-manager/doc/md/defect-manager-manual.md
pr关联issue具体操作请参考:
https://gitee.com/help/articles/4142


再关注下 mariadb-test为什么去安装 greatsql-test去了
安装 mariadb-devel 去安装 greatsql-devel去了。







【环境信息】
软件信息:
1) OS版本及分支: openEuler release 24.03 (LTS) / openEuler-24.03-LTS-SP1-round2
2) 内核信息:
6.6.0-28.0.0.34.oe2403.x86_64
【缺陷所属软件及版本号】
mariadb-embedded-4:10.5.24-1.oe2403.x86_64
mariadb-embedded-10.5.25-2.oe2403sp1.x86_64.rpm
【操作步骤】
用2403lts repo安装旧版本
yum install mariadb-embedded
添加2403sp1 repo升级新版本
yum upgrade mariadb-embedded
【预期结果】
安装成功无报错
【实际结果】
Error: Transaction test error:
file /etc/my.cnf from install of mariadb-config-4:10.5.25-2.oe2403sp1.x86_64 conflicts with file from package greatsql-mysql-config-8.0.32-25.1.oe2403.x86_64
【附件】
openEuler-24.03-LTS.repo
openEuler-24.03-LTS-SP1-round2.repo
二、缺陷分析结构反馈
影响性分析说明:
缺陷严重等级:(Critical/High/Moderate/Low)
缺陷根因说明:
受影响版本排查(受影响/不受影响):
openEuler-20.03-LTS-SP4
openEuler-22.03-LTS-SP3
openEuler-22.03-LTS-SP4
openEuler-24.03-LTS
openEuler-24.03-LTS-SP1
修复是否涉及abi变化(是/否):
openEuler-20.03-LTS-SP4
openEuler-22.03-LTS-SP3
openEuler-22.03-LTS-SP4
openEuler-24.03-LTS
openEuler-24.03-LTS-SP1