Database media storage tiemout error: Mage_Exception: Timeout limit for response from synchronize

[quersystem]

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

[lhsatch]

I am pretty sure that you can use set_time_limit

[amjadalihibdd9]

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!

[charleslou6881]

"Timeout errors in Magento can be tricky! I encountered a similar issue where sync processes were timing out, even with increased php.ini and MySQL timeout values. For database storage, you might want to check server load or split the sync into smaller batches to reduce strain. Adjusting execution limits, like max_execution_time or session timeouts in PHP and server settings, could also help. Though not directly related to salary tools like Kalkulimi i Pages, it's essential to manage resources effectively to avoid these timeouts on high-demand processes."