cancel
Showing results for 
Search instead for 
Did you mean: 

Magento media and system backups fail

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Magento media and system backups fail

It takes exactly 15 minutes and then nothing happens. From the log I see a lot:

 

2015-04-27T11:09:06+00:00 ERR (3): exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Statement/Pdo.php:228Stack trace:#0 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)#1 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)#2 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)#3 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)#4 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `lo...', Array)

.....

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `lo...', Array)
#4 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `lo...', Array)
#5 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `lo...', Array)
#6

...


Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction' in /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `lo...', Array)
#4 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `lo...', Array)
#5 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `lo...', Array)
#6 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Log/Model/Resource/Visitor.php(78): Zend_Db_Adapter_Abstract->insert('log_url_info', Array)
#7 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Log/Model/Resource/Visitor.php(94): Mage_Log_Model_Resource_Visitor->_saveUrlInfo(Object(Mage_Log_Model_Visitor))
#8 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(423): Mage_Log_Model_Resource_Visitor->_beforeSave(Object(Mage_Log_Model_Visitor))
#9 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor))
#10 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Log/Model/Visitor.php(189): Mage_Core_Model_Abstract->save()
#11 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Model/App.php(1338): Mage_Log_Model_Visitor->saveByRequest(Object(Varien_Event_Observer))
#12 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), 'saveByRequest', Object(Varien_Event_Observer))
#13 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)
#14 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(552): Mage::dispatchEvent('controller_acti...', Array)
#15 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Controller/Front/Action.php(75): Mage_Core_Controller_Varien_Action->postDispatch()
#16 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(423): Mage_Core_Controller_Front_Action->postDispatch()
#17 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('noCookies')
#18 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#19 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#20 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#21 /data09/vurtual33998/domeenid/www.mysitewebaddress.com/htdocs/index.php(116): Mage::run('', 'store')
#22 {main} 

Server admins said that they won't increase any execution time (php/mysql)

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Magento media and system backups fail

If you changed the "max_execution_time" in the .htaccess file and it is still not reflected, maybe there are some other configurations which are causing the timeout. 

 

Anyway I suggest that you consider using an alternative backup solution instead as Magento's built-in backup is not that good anyway due to a few reasons:-

 

1. It always reset file permissions wrongly to insecure permissions like 666 and 777 after a backup. 

 

2. It doesn't backup everything.

 

3. While backing up, it takes up resources of your account if you are in shared hosting which can put a strain on your website. 

View solution in original post

3 REPLIES 3

Re: Magento media and system backups fail

@rabakana

 

Increase your magento excecution time using .htaccess and then try again.

Was my answer helpful? You can accept it as a solution.
200+ Premium Magento 2 Extensions Need help? Hire Magento Developer

Re: Magento media and system backups fail

Thanks for you answer. I changed magento root folder .htaccess from

php_value max_execution_time 36000

to

php_value max_execution_time 360000

 

logged to backend, tried database and media backup no change - still it calculates 15 minutes and then nothing happens.

Re: Magento media and system backups fail

If you changed the "max_execution_time" in the .htaccess file and it is still not reflected, maybe there are some other configurations which are causing the timeout. 

 

Anyway I suggest that you consider using an alternative backup solution instead as Magento's built-in backup is not that good anyway due to a few reasons:-

 

1. It always reset file permissions wrongly to insecure permissions like 666 and 777 after a backup. 

 

2. It doesn't backup everything.

 

3. While backing up, it takes up resources of your account if you are in shared hosting which can put a strain on your website.