RHEL7环境下升级MariaDB 10.3至10.9.2因缺失pv包受阻

在RHEL7主机上从MariaDB 10.3跨大版本升级到10.9时，执行安装命令时报错，核心问题是MariaDB-server-10.9.2-1.el7.centos.x86_64依赖的pv包无法找到。完整报错日志如下：

[root@hostname lib]# yum install MariaDB-server MariaDB-client MariaDB-backup MariaDB-shared
Loaded plugins: product-id, search-disabled-repos, subscription-manager
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-backup.x86_64 0:10.9.2-1.el7.centos will be installed
--> Processing Dependency: libpmem.so.1(LIBPMEM_1.0)(64bit) for package: MariaDB-backup-10.9.2-1.el7.centos.x86_64
--> Processing Dependency: MariaDB-common for package: MariaDB-backup-10.9.2-1.el7.centos.x86_64
--> Processing Dependency: libpmem.so.1()(64bit) for package: MariaDB-backup-10.9.2-1.el7.centos.x86_64
--> Processing Dependency: libpcre2-8.so.0()(64bit) for package: MariaDB-backup-10.9.2-1.el7.centos.x86_64
---> Package MariaDB-client.x86_64 0:10.9.2-1.el7.centos will be installed
---> Package MariaDB-server.x86_64 0:10.9.2-1.el7.centos will be installed
--> Processing Dependency: galera-4 for package: MariaDB-server-10.9.2-1.el7.centos.x86_64
--> Processing Dependency: pv for package: MariaDB-server-10.9.2-1.el7.centos.x86_64
---> Package MariaDB-shared.x86_64 0:10.9.2-1.el7.centos will be installed
--> Running transaction check
---> Package MariaDB-common.x86_64 0:10.9.2-1.el7.centos will be installed
--> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.9.2-1.el7.centos.x86_64
---> Package MariaDB-server.x86_64 0:10.9.2-1.el7.centos will be installed
--> Processing Dependency: pv for package: MariaDB-server-10.9.2-1.el7.centos.x86_64
---> Package galera-4.x86_64 0:26.4.12-1.el7.centos will be installed
--> Processing Dependency: socat for package: galera-4-26.4.12-1.el7.centos.x86_64
---> Package libpmem.x86_64 0:1.5.1-2.1.el7 will be installed
---> Package pcre2.x86_64 0:10.23-2.el7 will be installed
--> Running transaction check
---> Package MariaDB-compat.x86_64 0:10.9.2-1.el7.centos will be installed
---> Package MariaDB-server.x86_64 0:10.9.2-1.el7.centos will be installed
--> Processing Dependency: pv for package: MariaDB-server-10.9.2-1.el7.centos.x86_64
---> Package socat.x86_64 0:1.7.3.2-2.el7 will be installed
--> Finished Dependency Resolution
Error: Package: MariaDB-server-10.9.2-1.el7.centos.x86_64 (mariadb)
           Requires: pv
**********************************************************************
yum can be configured to try to resolve such errors by temporarily enabling
disabled repos and searching for missing dependencies.
To enable this functionality please set 'notify_only=0' in /etc/yum/pluginconf.d/search-disabled-repos.conf
**********************************************************************

Error: Package: MariaDB-server-10.9.2-1.el7.centos.x86_64 (mariadb)
           Requires: pv
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@hostname lib]#

解决步骤 #

• 安装缺失的pv包：RHEL7默认Base仓库没有这个包，需要先启用EPEL仓库
  1. 安装EPEL仓库：

     yum install epel-release
     

  2. 安装pv包：

     yum install pv
     

• 重新执行MariaDB安装命令：

  yum install MariaDB-server MariaDB-client MariaDB-backup MariaDB-shared
  

升级额外注意事项 #

• 升级前必须备份所有数据库数据，比如用mysqldump做全量备份，避免数据丢失
• 新版本安装完成后，启动服务前要执行mysql_upgrade命令，升级系统表结构
• 确保旧版本MariaDB服务已经停止，防止端口冲突或数据损坏

内容的提问来源于stack exchange，提问作者James