cancel
Showing results for 
Search instead for 
Did you mean: 

Magento media and system backups fail

SOLVED

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.
175+ Professional Extensions for M1 & M2
Need a developer?Just visit Contact Us Now

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.