Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Websites lock up when editing products through the admin console
 
rickalto
Jr. Member
 
Total Posts:  1
Joined:  2012-01-12
 

The websites on our hosted server lock up any time we make an edit to a catalog item through the Magento admin console. We can update products without a problem using Magento Store Manager from MagneticOne.

In doing some troubleshooting in the Webhost Manager, I can see the trouble in the SQL processes running when we try to do an update. It appears the catalog table gets locked to start a MySQL transaction, then the remaining SQL queries are not able to execute. Meanwhile the catalog table is inaccessible for any website navigation, search, etc. The SQL queries just start stacking up waiting for the lock file to clear

The lock query times out after 15 minutes or so and things go back to normal, but the product records are never updated as requested.

Any insights on how to proceed would be greatly appreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
 
chiefair
Mentor
 
Avatar
Total Posts:  1848
Joined:  2009-06-04
 

We had these types of symptoms back when we were starting out and had been put on a shared host server with extremely marginal resources allocated to PHP and absolutely inadequate memory allocated to MySQL so it would hang upon any slightly stressful saves like category changes and heavily optioned product. It eventually lead to total erasure of all categories when MySQL collapsed under the strain.

Sounds like your system needs a bit of optimization.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top