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 がリリースされたあとにも発生します。バックアップは失敗し、上記と同じエラーが表示されます。