Skip to main content

NetApp_Insight_2020.png 

NetApp Knowledgebase

Cannot generate database backups in ActiveIQ Unified Manager 9.7

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

Applies to

ActiveIQ Unified Manager 9.7 (all platforms)

Issue

One or more of the following actions will be observed during the database backup failure.

  • No database backups will exist when triggered from a schedule within the Management / Database Backup view.
  • Server log (ocumserver.log) will report a connection failure to MySQL while executing a flush query.
2020-03-11 09:41:40,587 ERROR [oncommand] [taskScheduler-1] [Backup|ScheduleBackup] [c.n.d.i.b.MySqlDumpBackupManager] Error occured while taking mysql dump. Error message:
2020-03-11 09:41:40,587 ERROR [oncommand] [taskScheduler-1] [Backup|ScheduleBackup] [c.n.d.i.b.MySqlDumpBackupManager] mysqldump: Couldn't execute 'FLUSH /*!40101 LOCAL */ TABLES': Lost connection to MySQL server during query (2013)
2020-03-11 09:41:40,602 INFO  [oncommand] [taskScheduler-1] [Backup|ScheduleBackup] [c.n.d.i.b.MySqlDumpBackupManager] Deleted BackupFileInfo entity in DB
2020-03-11 09:41:40,738 ERROR [oncommand] [taskScheduler-1] [Backup|ScheduleBackup] [c.n.d.impl.backup.BackupScheduleJob] Error occurred in Regular Backup Job:
com.netapp.dfm.impl.backup.BackupCreationException: Failed to create database backup using mysql utility.
      at deployment.dfm-app.war//com.netapp.dfm.impl.backup.MySqlDumpBackupManager.collectMysqlDump(MySqlDumpBackupManager.java:722)
[[TRUNCATED]]
 
  • Server log (ocumserver.log) will also report memory exhaustion with different threads around the same time as the MySQL query failure shown above.

2020-03-11 09:31:05,431 INFO [oncommand] [Thread-248] [c.n.i.s.OpmThreadPoolExecutorMonitor$ResourceMonitor] The total amount of memory used is greater than 80%
2020-03-11 09:31:05,431 INFO [oncommand] [Thread-246] [c.n.i.s.OpmThreadPoolExecutorMonitor$ResourceMonitor] The total amount of memory used is greater than 80%
2020-03-11 09:31:05,431 INFO [oncommand] [Thread-251] [c.n.i.s.OpmThreadPoolExecutorMonitor$ResourceMonitor] The total amount of memory used is greater than 80%


Note: Please refer to the below KB article to obtain location of ocumserver.log. 

Unified Manager : What are the notable log files and their respective locations ?

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support