MaxDB backup failure (Error code 1450 Insufficient system resources exist to complete the requested service)
In some occasions, the MaxDB backup attempt (via Database Studio) may fail on Windows Server with the following error:
An error occurred during the backup.
-903 Host file I/O error 3,Data backup failed 136,Transfer from or to medium \\hostname\your_path\db_backup\SID failed operation : write block size : 8192 bytes length : 64 blocks offset : 4294967295 blocks position : 35184372088832 bytes Servertask Info: because Error in backup task occured Job 1 (Backup / Restore Medium Task) [executing] WaitingT107 Result=3700 Error in backup task occured, Error code 3700 “hostfile_error” 125,Write error on medium \\hostname\your_path\db_backup\SID: Error code 1450 (Insufficient system resources exist to complete the requested service. )
CAUSE:
This error results from a Windows Server OS problem that prevents the backup dump to be created.
“Windows OS error 1450”
“Error 1450 is ERROR_NO_SYSTEM_RESOURCES”
Memory resource issue at the OS.
SOLUTION:
Windows Server:
Check ‘Event Viewer’ on the server for more clues. Run “Computer Management” via compmgmt.msc command. Then go to – Computer Management – Event Viewer – Windows Logs – System.
Check ‘Event Viewer’ on the server for more clues. Run “Computer Management” via compmgmt.msc command. Then go to – Computer Management – Event Viewer – Windows Logs – System.
Windows successfully diagnosed a low virtual memory condition. The following programs consumed the most virtual memory: kernel.exe (1636) consumed 6780399616 bytes, TrustedInstaller.exe (4360) consumed 4029771776 bytes, and dbstudio.exe (5016) consumed 596738048 bytes.
- Increase virtual memory (swap) on OS level or add more RAM memory to the host. In this case, the solution was to increase the swap size (virtual memory) by 16 GB and restart the server.
- Re-execute the MaxDB backup and it now runs with success