Linux で Active IQ Unified Manager データベースのバックアップが MySQL 8.0.28 で失敗します
環境
- Active IQ Unified Manager ( AIQUM ) 9.7 以降
- Red Hat Enterprise Linux(RHEL)
- MySQL 8.0.28 以降
問題
- MySQL をバージョン 8.0.28 にアップグレードすると、 Active IQ Unified Manager データベースのバックアップの作成が失敗し、で bellow エラーが発生します
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.
- これは、 Active IQ Unified Manager の新規インストール後、および MySQL 8.0.28 がリリースされたあとにも発生します。バックアップは失敗し、上記と同じエラーが表示されます。