Support

Akeeba Backup for Joomla!

#31268 running out of resources restoring backup

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by nicholas on Tuesday, 23 April 2019 08:10 CDT

josflachs
I can't restore my backup anymore, I'm running out of resources. That's what the help desk told me. The backup is pretty big: 1,2 Gb. How can I restore my backup?

nicholas
Akeeba Staff
Manager
I will make a guess that your server is running CloudLinux. Due to a bug in CloudLinux the filesystem cache (which is shared with the total memory available to your account) is not cleared fast enough. As a result, any operation involving a large number of files – such as backing up or restoring a site – ends up eating up all your available memory.

There are two workarounds.

The first workaround is slowing down the extraction process. If you are doing a restoration from inside Akeeba Backup this does not apply to you. It only applies when using Kickstart. When you run Kickstart set the Minimum Execution Time to 5 and the Maximum Execution Time to 1 (yes, max is less than min, this is not a typo!). This makes the extraction 80% slower which gives enough time to CloudLinux to clear the filesystem cache, freeing up memory (resources).

Note: We have plans to add these advanced settings to the integrated restoration as well in the next version of Akeeba Backup. When we do, the workaround above will also apply to restoring backup archives from inside Akeeba Backup itself.

The second workaround is a bit more "brutal". You need to extract the backup archive on your computer using Kickstart, using a local server such as XAMPP, MAMP or WampServer. When the extraction is complete do not click on "Run the restoration script". Instead, upload all of the extracted files (except kickstart.php and the backup archive itself) to your server. Moreover, delete the .htaccess file from your site's web root. Then access the /installation/index.php URL on your live site to complete the restoration. This works because the bulk of file operations is done by FTP which does not trigger CloudLinux' filesystem cache handling bug.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

josflachs
Thanks, that helps. Now we have problems the other way around, creating a backup. We have made a backup without images and want to restore that on localhost. Now we got an error the sql query row is too large.

How do I solve that problem?

nicholas
Akeeba Staff
Manager
The screenshot is super low resolution and I can't read the text. But I know what the message reads since I was the one who wrote it ;) Please read it carefully. It is not an error message. It tells you what to do if you get an error message. So, your answer is on your screen.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!