DeanWhitehouse Posted August 22, 2012 Share Posted August 22, 2012 Hello, We run a medium Amazon EC2 instance with multiple sites on and we keep experiencing the error when running WordPress. MySQL dead but subsys locked Can someone help define and the error for us and advise on fixes ? Thanks, Dean Quote Link to comment https://forums.phpfreaks.com/topic/267424-mysql-dead-but-subsys-locked-amazon-ec2/ Share on other sites More sharing options...
fenway Posted August 23, 2012 Share Posted August 23, 2012 You're paying for this service -- talk to your provider. Quote Link to comment https://forums.phpfreaks.com/topic/267424-mysql-dead-but-subsys-locked-amazon-ec2/#findComment-1371664 Share on other sites More sharing options...
DeanWhitehouse Posted September 3, 2012 Author Share Posted September 3, 2012 This is a server set up issue not an Amazon issue. We've solved the issue slightly by switching to InnoDB which only locks per row but we still experience crashes regularly. Quote Link to comment https://forums.phpfreaks.com/topic/267424-mysql-dead-but-subsys-locked-amazon-ec2/#findComment-1374836 Share on other sites More sharing options...
spec36 Posted September 12, 2012 Share Posted September 12, 2012 Hey I had this issue on my server yesterday, but it was SNMPd that showed locked up. This is what I did to resolve it. 1. cd /var/lock/subsys 2. delete snmp or mysql in your case 3. service snmpd start Looks like this happens when the current running process somehow gets corrupt and then someone tries to restart it, but the PID is already in use by the original process and that is why you get the subsys locked message. Hope this helps. Quote Link to comment https://forums.phpfreaks.com/topic/267424-mysql-dead-but-subsys-locked-amazon-ec2/#findComment-1377446 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.