OnCommand Insight or Data WareHouse backups fail due to a lack of space
- Views:
- 476
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-insight-data-warehouse
- Specialty:
- oci
- Last Updated:
Applies to
- OnCommand Insight (OCI) 7.x
- OnCommand Insight Data Warehouse (DWH) 7.x
Issue
- Backups fail with an out of space error, check dwh.log on the DWH server or asup.log on the OCI server.
Example:
2018-06-28 07:58:10,142 ERROR [Thread-30 (ActiveMQ-client-global-threads-1665925101)] JobDispatcherBean (JobDispatcherBean.java:106) - Job{name='Backup', id=43559} failed
com.netapp.sanscreen.dwh.backup.BackupException: Failed to generate backup.
<<snipped>>
Caused by: com.onaro.sanscreen.phonehome.PhoneHomeException: Failed to run DbBackupAction
commmands:
[E:\Program Files\SANscreen/mysql/bin/mysqldump.exe, --defaults-file=E:\Program Files\SANscreen\backup\db\..\.my.dump.cnf, -uroot, --port=3306, --add-drop-table, --single-transaction, --no-autocommit, --hex-blob, --result-file=E:\Program Files\SANscreen\wildfly\standalone\deployments\download.war\dwh_7.3.1_<site_name>_all_5717805541416235955.sql, --routines, --databases, dwh_capacity_staging, dwh_inventory_staging, dwh_management, dwh_capacity_efficiency, dwh_dimensions, dwh_performance_staging, staging, dwh_performance, dwh_reports, dwh_ports, dwh_capacity, dwh_fs_util, dwh_inventory_transient, dwh_inventory, dwh_custom]
outputFile: E:\Program Files\SANscreen\wildfly\standalone\deployments\download.war\result_3691049102953749349.sql
sqlFile: E:\Program Files\SANscreen\wildfly\standalone\deployments\download.war\dwh_7.3.1_<site_name>_all_5717805541416235955.sql
stderr.output:
mysqldump: Got errno 28 on write