UNiTE, Remote CLI, eXtract Wizard

Friday, 20 May 2011 07:36 CDT

user37365

Mandatory information about my setup:

Have I searched the forum before posting? Yes
Have I read the Troubleshooting Wizard before posting? yes
Have I read the documentation before posting? yes
Joomla! version: (unknown)
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you)
Akeeba eXtract Wizard / Remote Control / SiteDiff version: (unknown)

Hi again.

I am trying to carry out a backup through the Akeeba Remote Control and i keep on getting a Remote API call error. The site is hosted on the same server with other websites of us and those have no issues.

I attached the log file.

Many thanks,
Antonis

Friday, 20 May 2011 10:45 CDT

nicholas

Your database server got overloaded while performing the backup and it crashed the page load in Joomla!. Unfortunately, there is no way to work around that issue other than moving your site to a more performant host :(

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!

Friday, 20 May 2011 11:41 CDT

user37365

Hi Nicholas. Thats a bit strange as the website is on a dedicated Linux server.

BR,
Antonis

Friday, 20 May 2011 11:43 CDT

nicholas

In that case you should be able to increase the MySQL idle connection limit to 30 seconds, restart mysqld and that should solve the issue ;) Note that the default is usually 3-5 seconds which is fine for simple page loads but just doesn't work when you have a lengthy process, like a backup step.

In retrospect, if that's not possible, you can set Akeeba Backup's minimum execution time to 0 seconds, maximum execution time to 3 seconds and bias to 50%, but that will make your backup really dead slow and might not always allow you to perform a backup.

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!

Friday, 20 May 2011 12:30 CDT

user37365

Thanks Nichola. Im checking for the first option.

"In retrospect, if that's not possible, you can set Akeeba Backup's minimum execution time to 0 seconds, maximum execution time to 3 seconds and bias to 50%, but that will make your backup really dead slow and might not always allow you to perform a backup".

How can i do the above?

Friday, 20 May 2011 12:54 CDT

nicholas

Go to Components, Akeeba Backup. Click on Configuration. Scroll all the way down. Set:
- Minimum execution time: 0 seconds
- Maximum execution time: 3 seconds
- Bias: 50 %
Save the configuration and retry backing up.

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!

Friday, 20 May 2011 13:00 CDT

user37365

Unfortunately doesn't work...same error

Friday, 20 May 2011 16:39 CDT

nicholas

I think you'll have to bite the bullet and perform the MySQL configuration change after all :(

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!

Saturday, 21 May 2011 03:24 CDT

user37365

well something interesting happened. i changed the .htaccess file with the one of admin tools and one of the site worked.the other one still not. any ideas why this helped?

Saturday, 21 May 2011 10:46 CDT

nicholas

Well, yes, I have an idea - but it's a long shot! It is possible that your old .htaccess intercepted the calls to Akeeba Backup's remote API URL in a way that it corrupted the request and threw Akeeba Backup into a very long loop, causing the MySQL connection to time-out. Admin Tools' .htaccess is, of course, designed to work with Akeeba Backup (actually, it's designed to be compatible with anything that is coded as any proper Joomla! component should be coded).

Regarding the other site which still doesn't work, have you tried doing the same trick?

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