Solved

MySQL InnoDB Error

Posted on 2014-01-21
3
780 Views
Last Modified: 2014-01-21
We have recently moved a WordPress/ecommerce website to our Cpanel hosting environment and came across a new error today (site has been on our server for 5 days)

The website goes down unexpectedly and displays this error in the browser:
Error while connecting to MySQL: Couldn't connect to localhost:3306/tcp: IO::Socket::INET: connect: Connection refused

We have tracked it down to InnoDB, but we have no idea why this is happening or how to fix it.


140121 11:25:19 InnoDB: The InnoDB memory heap is disabled
140121 11:25:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140121 11:25:19 InnoDB: Compressed tables use zlib 1.2.3
140121 11:25:19 InnoDB: Using Linux native AIO
140121 11:25:19 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140121 11:25:19 InnoDB: Completed initialization of buffer pool
140121 11:25:19 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140121 11:25:19 Plugin 'InnoDB' init function returned error.
140121 11:25:19 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140121 11:25:19 Unknown/unsupported storage engine: InnoDB
140121 11:25:19 Aborting

140121 11:25:19 [Note] /usr/sbin/mysqld: Shutdown complete

140121 11:25:19 mysqld_safe mysqld from pid file /var/lib/mysql/festaparties.topgeartechnologies.com.pid ended
140121 12:55:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140121 12:55:47 [Note] Plugin 'FEDERATED' is disabled.
140121 12:55:47 InnoDB: The InnoDB memory heap is disabled
140121 12:55:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140121 12:55:47 InnoDB: Compressed tables use zlib 1.2.3
140121 12:55:47 InnoDB: Using Linux native AIO
140121 12:55:47 InnoDB: Initializing buffer pool, size = 128.0M
140121 12:55:47 InnoDB: Completed initialization of buffer pool
140121 12:55:47 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140121 12:55:47 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
0
Comment
Question by:TopGearTech
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 500 total points
Comment Utility
Error 12 means not enough space. You're too low on memory.

128M isn't too large for a buffer pool, so check what other things might be set too large (like the query cache or something), and maybe talk with your provider about how much memory you are allocated.
0
 

Author Comment

by:TopGearTech
Comment Utility
Thanks for your reply.  I'm self-hosting, couldn't I just increase buffer pool?
0
 

Author Closing Comment

by:TopGearTech
Comment Utility
Thank You!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now