Magento Forum

MySQL Lock Error when trying to update InnoDB
 
dan_w
Sr. Member
 
Total Posts:  290
Joined:  2008-01-04
 

I’ve recently run across the following error when importing using dataflow:
SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction.

I understand that probably has something to do with InnoDB record locking, but I’m just curious as to why its suddenly appearing when it didn’t before?

 
Magento Community Magento Community
Magento Community
Magento Community
 
QuadraVis
Sr. Member
 
Avatar
Total Posts:  82
Joined:  2008-05-30
D - Erbach
 

Does anyone has the same ERROR?

I got it when i create a new attribute_set. But the set is created anyway.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Build | Stores
Jr. Member
 
Avatar
Total Posts:  2
Joined:  2008-10-03
St Augustine, FL
 

Same error here with version 1.1.8. Very frustrating. Also if you are lucky enough not to get the error while working with attribute sets then the attribute set doesn’t save.

 
Magento Community Magento Community
Magento Community
Magento Community
 
anton78
Jr. Member
 
Avatar
Total Posts:  21
Joined:  2008-08-04
 

Same error. Save attribute set and server times-out. Magento ver 1.2.0.2? Any fix for this? Only happens in Firefox 3. Works Ok on IE7.

 
Magento Community Magento Community
Magento Community
Magento Community
 
KeyboardCowboy
Member
 
Total Posts:  65
Joined:  2008-07-01
Berlin, Germany
 

same problem…

today i see this error in different places in admin area.

 
Magento Community Magento Community
Magento Community
Magento Community
 
AYG Romania
Jr. Member
 
Avatar
Total Posts:  17
Joined:  2009-01-30
Conatsnta
 

Hi,
I had the same problem. The solition was to restart the mysql server. It worked for me

 
Magento Community Magento Community
Magento Community
Magento Community
 
Stephan Wienczny
Jr. Member
 
Total Posts:  19
Joined:  2008-11-04
 

This still happens for 1.4.1.1 for some database operations.

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