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 '';
120811 22:06:39 [Note]   - '(null)' resolves to '::';
120811 22:06:39 [Note] Server socket created on IP: ''.
120811 22:06:40 [ERROR] Fatal error: Can't open and lock privilege tables: Got error 5 from storage engine


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.

  • post your complete my.cnf configuration here – Farhan Aug 11 '12 at 18:37
  • 1
    Check the permissions of the files in /var/lib/mysql. Is everything owned by the mysql user? – Zoredache Aug 11 '12 at 18:43
  • Yes. Everything is owned by mysql user – Anish Sheela Aug 11 '12 at 18:53
$ 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.

  • Let me ask my VPS provider for that. But, how can I confirm that the problem is with disk itself? – Anish Sheela Aug 11 '12 at 18:58
  • 1
    Please provide the output of dmesg. I'd check glusterfs before contacting the vps provider. – user130370 Aug 11 '12 at 19:17
  • dmesg Does not show any output. May be if it is on a VPS? – Anish Sheela Aug 11 '12 at 19:23
  • I checked with the provider. They are saying no corruption occurred. – Anish Sheela Aug 12 '12 at 17:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.