Active IQ Unified Manager 数据库备份失败、并显示MySQL 8.0.28
适用场景
- Active IQ Unified Manager ( AIQUM ) 9.7 及更高版本
- MySQL 8.0.28 及更高版本
问题描述
- 将MySQL升级到8.0.28或更高版本后、Active IQ Unified Manager 数据库备份创建失败、并显示以下错误
ocumserver.log:
2022-01-27 12:15:10,003 ERROR [umadmin] [job-319] [Create backup|BACKUP_CREATE] [c.n.d.i.backup.MysqlDumpOperation] Error occured while taking mysql dump. Error message:
2022-01-27 12:15:10,003 ERROR [umadmin] [job-319] [Create backup|BACKUP_CREATE] [c.n.d.i.backup.MysqlDumpOperation] WARNING: --delete-master-logs is deprecated and will be removed in a future version. Use --delete-source-logs instead.
mysqldump: Couldn't execute 'PURGE BINARY LOGS TO 'unified-manager.000010'': Could not purge binary logs since another session is executing LOCK INSTANCE FOR BACKUP. Wait for that session to release the lock. (4085)
...
2022-01-27 12:15:10,076 ERROR [umadmin] [job-319] [Create backup|BACKUP_CREATE] [com.netapp.dfm.job.JobEngine] Error executing job e5526ca867282c16:-79d2a3bd:17e9b3efe26:-7ffe task e5526ca867282c16:-79d2a3bd:17e9b3efe26:-7ffd: Error occurred in Regular Backup Job:com.netapp.dfm.impl.backup.BackupCreationException: MySQL database dump dump file was not created.
java.lang.RuntimeException: Error occurred in Regular Backup Job:com.netapp.dfm.impl.backup.BackupCreationException: MySQL database dump dump file was not created.
28586: 2023-07-13 19:29:29,164 ERROR [umadmin] [job-399] [Create backup|BACKUP_CREATE] [c.n.o.r.c.s.tasks.CreateBackupTask] Regular Backup Job didn't complete successfully due to an internal error
- 此UI可能会显示此错误
Backup Could not be taken
- 在新安装 Active IQ Unified Manager 之后以及自发布 MySQL 8.0.28 以来,也可能发生这种情况;备份将失败,并显示上述相同错误。