MySQL service does not start

Anish Sheela asked:

My MySQL service is not starting. I am using debian wheezy as operating system in my VPS. I use MyISAM for storing tables.

Response when starting service

root@ipxweb1:~# service mysql start
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

The following error is showing up when I used mysqld command.

root@ipxweb1:~# mysqld
120811 22:06:39 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
120811 22:06:39 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
120811 22:06:39 [Note] Plugin 'FEDERATED' is disabled.
120811 22:06:39 [Note] Server hostname (bind-address): '(null)'; port: 3306
120811 22:06:39 [Note]   - '(null)' resolves to '0.0.0.0';
120811 22:06:39 [Note]   - '(null)' resolves to '::';
120811 22:06:39 [Note] Server socket created on IP: '0.0.0.0'.
120811 22:06:40 [ERROR] Fatal error: Can't open and lock privilege tables: Got error 5 from storage engine

EDIT:

I am running a load balanced server, using glusterfs for replication. /var/lib/mysql directory is replicated across 2 servers. The MySQL starts perfectly fine on second server. It was working fine on first server. One fine morning, without my intervention, it happened.

My answer:


$ perror 5
OS error code   5:  Input/output error

Time to check your disks….

Since it’s a (most likely leased) VPS, you can’t really check the server’s disks, though. You may have to ask the hosting provider to look into it.


View the full question and answer on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.