Skip to main content
NetApp Knowledge Base

Active IQ Unified Manager database backup fails with MySQL 8.0.28 in Linux

Views:
400
Visibility:
Public
Votes:
0
Category:
active-iq-unified-manager
Specialty:
om
Last Updated:

Applies to

  • Active IQ Unified Manager (AIQUM) 9.7 and above
  • Red Hat Enterprise Linux (RHEL)
  • MySQL 8.0.28 and above

Issue

  • After upgrading MySQL to version 8.0.28, the Active IQ Unified Manager database backup creation is failing with the bellow error in 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.

  • This can occur also after a new install of Active IQ Unified Manager and since MySQL 8.0.28 was released; the backup will fail with the same error as seen above.

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device