Following upgrade to NVBU 9.1, NetVault Database backups that have the "Compact database tables after backup" option will fail.
NetVault logs show:
---
Job Message 2013/05/24 07:31:55 141 Schedule EU9095 Scheduler database successfully compacted
Error 2013/05/24 07:31:55 141 Data Plugin EU9095 Failed to compact the Media Manager database
Error 2013/05/24 07:31:55 141 Data Plugin EU9095 Failed during main database backup phase
Error 2013/05/24 07:31:55 141 Jobs EU9095 Fatal error: Backup failed
---
The compaction of the ScheduleDatabase is successful, however the issue is during the MediaDatabase compaction phase.
The same problem applies when running the MediaDatabase compaction via CLI:
The 'nvmeddbcheck compact' (and/or force) will fail after the check with the following message:
---
Failed to compact database
---
Bug 22636 has been raised for this issue and a fix will be provided.
In the meantime:
- Edit the NVDB backup job
- Deselect the "Compact database tables after backup" option under the 'Backup Options' tab
- Save the job
This will allow for the NVDB backups to complete successfully and be available to restore.
While the compaction option is available, but also advisable on large MediaDatabases, this feature is optional.
The "Check database tables before backup" option is the most important. It is performed before the compact, therefore failure to compact the MediaDatabase
should not have any impact on the NVDB integrity and NVBU opeartions, as long as no errors are returned during the integrity check phase.
