Support

Akeeba Backup for Joomla!

#27873 Backup Failed on XAMPP

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 on Thursday, 06 July 2017 17:17 CDT

q12321
Run "Backup".

When in "Backing up databases" task the computer runs indefinably showing at the bottom
"Waiting for localhost...".

Last server response >180s ago
After >60s clicked "Control Panel" and got this:

"Backup Failed

The backup operation has been halted because an error was detected.
The last error message was:

<strong>AJAX Loading Error</strong><br/>HTTP Status: 0 ()<br/>Internal status: error<br/>XHR ReadyState: 4<br/>Raw server response:<br/>"

Clicked on "Analyse Log File (ALICE)" and computer is "Connecting..." indefinably showing at the bottom
"Waiting for localhost...".

Restarted computer and run the "ALICE".
Implemented recommendations and run the backup again with "Backup Failed" result.

nicholas
Akeeba Staff
Manager
This is actually an issue with PHP's thread safety on Windows. If your AMP installation is using PHP as an Apache module -like XAMPP does- you need the thread-safe (TS) version. If your AMP installation is using PHP through CGI or FastCGI then you need the non-thread-safe (NTS) version. XAMPP is indeed running PHP as an Apache module but I'm not sure that they are using the correct, thread-safe version. I had consistent crashes with it so I ultimately had to roll my own local server on Windows.

A possible workaround is to make the backup much, much slower. In the Configuration page of Akeeba Backup set:
Minimum execution time: 7 seconds
Maximum execution time: 5 seconds (yes, maximum is less than minimum)
Execution time bias: 75%

That said, this workaround will NOT work very reliably. I would recommend simply using a better local server. Something like MAMP might work better.

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!

q12321
I tried your Workaround with this same result.
I also installed MAMP and results are this same.
In both cases results ends in "Waiting for localhost...".

nicholas
Akeeba Staff
Manager
This is NOT helpful information. The backup runs by making requests to your server. While each step is running of course you will see "Waiting for localhost" since your browser is waiting for the server to finish running the step.

What else do you get? If you get an HTTP status 0 it simply means that your server closed the connection on you. Have you tried changing the maximum execution time to something really low, e.g. 5 seconds?

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!

q12321
The backup runs and in "Backing up databases" task runs indefinitely (over 180s) showing 25%.
When I click on the "Control Panel" I get message like in initial post and server freezes showing "Waiting for localhost...".
In result I can get to the ALICE only after restarting my computer.

I run the backup with the maximum execution time of 5 seconds. Result is this same.
I never got any HTTP status during any attempted backup.

nicholas
Akeeba Staff
Manager
This does mean that the web server (Apache) or the database (MySQL) service dies. I'm afraid there's not much you can do here. In the end of the day, though, it comes down to Windows and resource handlers, i.e. the low level handling of files by Windows itself. Here's the thing. This behavior is both machine-specific and not related to Akeeba Backup itself. It's not even related to Joomla!. It goes deep down into how PHP, Apache and Windows interact under the hood. This is two to four layers before our code has even the chance to load, making it impossible for us to offer any solution to what is, essentially, a server platform issue. All I can offer is some anecdotal information about your issue.

One thing I've found that helps sometimes is disabling your antivirus. This includes Windows Defender. At the very least you should add exceptions for the folders which contain your web server, your site files and MySQL (that is: the entire c:\xampp folder if you're using the default installation). The reason that helps, I suspect, is that antivirus application hook to Windows' file access events. Every time you try to access a file they try to scan it - that's what most antivirus call "realtime protection". The problem is that they end up opening too many files. Sometimes crap happens and the internal Windows file handle is not released at all or fast enough. This can cause some interesting race conditions with Apache and PHP which wait forever for the file lock to be released - something that never happens because code outside them dropped the ball.

I did have that issue when I was using Windows 7 on an AMD Phenom x3 back in 2009 with XAMPP. All I can tell you is that I no longer have that problem on either of my Windows 10 computers anymore. One is an Intel NUC with a 2013-spec i5 and 16GB RAM, the other is a 2016 Surface Book with an i7 and 16GB RAM. I am using my own AMP server, mostly with PHP 7.0. Davide, our other developer, has a rather ancient Thinkpad with Windows 10 and XAMPP which he uses without a problem. If I may offer more information, when I first bought the Surface Book I had MASSIVE issues like yours - they have been recorded as part of my Joomla! Day Austria 2016 presentation when that issue happened when I was trying to demonstrate backing up on stage... I trashed and rebuilt my AMP, killed off my antivirus (NOD32 - I realised antivirus is mostly snake oil), added folder exceptions to Windows Defender and all the issues "magically" went away. Also, everything started running so much faster.

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!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

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!