mysql - Magento 1.8 & Amazon RDS Lock wait timeouts -


firstly isn't duplicate of this question because i'm not behind load balancer @ moment. randomly restarting instance isn't satisfactory solution either.

i moved our store using local mysql db on ec2 rds , we're getting errors on backend when they're moving categories around / adding products. sqlstate[hy000]: general error: 1205 lock wait timeout exceeded; try restarting transaction i've seen other variations of pdo errors.

how 1 go eliminating these issues?

i've read suggestions 'keep retrying' seems stupid.

i've tried tinkering innodb_lock_wait_timeout , others doesn't seem resolve it.

i have disabled magento logging db - see if helps going forward. unfortunately have wait while let staff tinker on backend , see if fix has effect.

thanks

update

now seeing bunch of these

user error: ddl statements not allowed in transactions 


Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -