MySQL won't start after power reset

cassa

Hola,

I'm having problems with a MySQL server. After a power reset (node problems), my MySQL server won't start anymore.

The /var/log/mysql* logs are empty.

Anyone knows how to fix this?

ATHK

OS?

bf1

First you should tell us how you are trying to start it. Try to start it without using the init script: mysqld_safe & and see what you get.

Sady

Which OS ?

What are you getting on this :

service mysql start or service mysqld start

cassa

I'm running Debian x86_x64

# mysqld_safe &
[1] 11054
141220 11:04:02 mysqld_safe Logging to syslog.
141220 11:04:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141220 11:04:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

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

deadbeef

Check the mysql.log or mysql dir on /var/log, it should have details on what failed.

bf1

mysqld_safe --log-error=/tmp/mysql.log

cassa

@bf1 said:
mysqld_safe --log-error=/tmp/mysql.log

Thanks!

I got this:

141220 11:19:10  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.

Fixed by placing the following in the /etc/mysql/my.cnf in [mysqld]

innodb_use_native_aio = 0