降级后还原 Active IQ Unified Manager 备份失败 MySQL 8.0.22 或 8.0.23

最后更新
另存为PDF

Views:: 14

Visibility:: Public

Votes:: 0

Category:: active-iq-unified-manager

Specialty:: om

Last Updated:

适用场景

Active IQ Unified Manager 9.7或更高版本
从MySQL 8.0.22或8.0.23降级到8.0.21的实例。
RedHat或CentOS安装

问题描述

Active IQ Unified Manager 数据库备份是在MySQL版本为8.0.22或8.0.23时进行的。由于 8.0.22或8.0.23中的MySQL错误、建议将MySQL版本回滚到8.0.21。
在新安装的使用MySQL 8.0.21的Unified Manager上还原Active IQ Unified Manager 数据库备份(使用8.0.22/.23创建)时、遇到以下错误。

2021-03-09-16-20-33,931 INFO [Active IQ UM] [restore] [restore.sh] Extracted database dump repository file /opt/netapp/data/ocum-backup/database-dumps-repo/ocum_mysql_full_backup_1615239602511.sql.7z successfully

2021-03-09-16-20-33,938 INFO [Active IQ UM] [restore] [restore.sh] Ordered list of Backup files: /opt/netapp/data/ocum-backup/UMrestore-03-09-2021-16-04-09/UMDatabaseDumpRepo-03-09-2021-16-04-09/ocum_mysql_full_backup_1615239602511.sql

2021-03-09-16-20-33,940 INFO [Active IQ UM] [restore] [restore.sh] Number of Backup files: 1

ERROR 3723 (HY000) at line 540: The table 'replication_asynchronous_connection_failover' may not be created in the reserved tablespace 'mysql'.

2021-03-09-16-20-36,238 ERROR [Active IQ UM] [restore] [restore.sh] Failed to restore the Database dump

2021-03-09-16-20-41,169 INFO [Active IQ UM] [restore] [restore.sh] Deleted temporary files

2021-03-09-16-20-41,171 INFO [Active IQ UM] [restore] [restore.sh] Moving to directory /var/log/ocum

2021-03-09-16-20-41,175 INFO [Active IQ UM] [restore] [restore.sh] Available log file count is 2.

2021-03-09-16-20-41,177 INFO [Active IQ UM] [restore] [restore.sh] No log files will be cleared.

在""上可能会显示类似的错误消息replication_asynchronous_connection_failover_managed