Hi everyone,
Im doing some tests in lab for a new site which would need database image storage.
I have configured the storage option in Magento admin and started the synchronization.
Everything looks fine and process starts, but few minutes later it crashes due to timeout error.
I have set this additional config in MySQL server but it still crashes:
max_allowed_packet = 128M
wait_timeout = 28800
interactive_timeout = 28800
connect_timeout = 28800
I have also a 3600 execution time in php.ini, php-fpm request_terminate_timeout in pool and nginx fastcgi_read_timeout and the same value in admin session.
Where do I set this timeout? I have made some tries and my guess is that the timeout is around 1200sec.
Mage_Exception: Timeout limit for response from synchronize process was reached. in /app/code/core/Mage/Adminhtml/controllers/System/Config/System/StorageController.php:139 Stack trace: #0 /app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_System_Config_System_StorageController->statusAction() #1 /app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('status') #2 /app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #3 /app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #4 /app/Mage.php(682): Mage_Core_Model_App->run(Array) #5 /index.php(87): Mage::run('base', 'website') #6 {main}
Magento CE 1.9.1.0
I am pretty sure that you can use set_time_limit
Timeout issues with database media storage can be quite challenging. It might be helpful to review server configurations and optimize query performance. For more detailed strategies on managing these errors, check out this resource: https://equipejk.com/. Hope it helps!