By DigitalFish
Hi there,
The problem I have that my database stops frequently.
MySQL error log says:
InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files.
Droplet details:
- Ubuntu 14.04
- Apache
- Was builded from a snapshot
- Using WordPress
Any idea how to fix it?
Thanks
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
This question was answered by @gndo:
@DigitalFish - OK. Hopefully when you shutdown the droplet to make the snapshot, the mysql daemon cleaned up properly. So, the immediate problem is to determine if there is a secondary method that is starting the mysql daemon, or if it is just trying to restart prior to shutting down properly. Try the following
service mysql stop # look at the log files to make sure it did stop or was already stopped # confirm it is stopped service mysql status # restart it service mysql start # look at the log files to see if the same error appears # confirm that is has started service mysql status
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.