1 Topic by xSecure (edited by xSecure 2014-12-10 13:03:59)

  • Registered: 2014-12-10
  • Posts: 2

Topic: Can't start Mysql

Hello,
First off, i'm sorry for starting a new 'daemon' issues topic, but i'm struggling for days to solve this, with no success.
This started when I updated PHP to 5.6, phpMyAdmin forced me to update mysql. Since it didn't allow me to admin it. It was showing a red bar error.

I've Mysql installed using Remi.
Distro is: CentOS release 6.5 (Final).

Mysql: 

[root@insp ~]# rpm -qa | grep mysql
php-mysqlnd-5.6.3-3.el6.remi.x86_64
mysql-5.5.41-1.el6.remi.x86_64
compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-libs-5.5.41-1.el6.remi.x86_64
mysql-server-5.5.41-1.el6.remi.x86_64

Log: 


141210 07:18:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
        141210  7:18:21 [Note] Plugin 'FEDERATED' is disabled.
        141210  7:18:21 InnoDB: The InnoDB memory heap is disabled
        141210  7:18:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
        141210  7:18:21 InnoDB: Compressed tables use zlib 1.2.3
        141210  7:18:21 InnoDB: Using Linux native AIO
        141210  7:18:21  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
        InnoDB: Warning: io_setup() attempt 1 failed.
        InnoDB: Warning: io_setup() attempt 2 failed.
        InnoDB: Warning: io_setup() attempt 3 failed.
        InnoDB: Warning: io_setup() attempt 4 failed.
        InnoDB: Warning: io_setup() attempt 5 failed.
        141210  7:18:24  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
        InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
        141210  7:18:24 InnoDB: Fatal error: cannot initialize AIO sub-system
        141210  7:18:24 [ERROR] Plugin 'InnoDB' init function returned error.
        141210  7:18:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
        141210  7:18:24 [ERROR] Unknown/unsupported storage engine: InnoDB
        141210  7:18:24 [ERROR] Aborting

        141210  7:18:24 [Note] /usr/libexec/mysqld: Shutdown complete

        141210 07:18:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
        141210 07:24:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
        141210  7:24:51 [Note] Plugin 'FEDERATED' is disabled.
        141210  7:24:51 InnoDB: The InnoDB memory heap is disabled
        141210  7:24:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
        141210  7:24:51 InnoDB: Compressed tables use zlib 1.2.3
        141210  7:24:51 InnoDB: Using Linux native AIO
        141210  7:24:51  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
        InnoDB: Warning: io_setup() attempt 1 failed.
        InnoDB: Warning: io_setup() attempt 2 failed.
        InnoDB: Warning: io_setup() attempt 3 failed.
        InnoDB: Warning: io_setup() attempt 4 failed.
        InnoDB: Warning: io_setup() attempt 5 failed.
        141210  7:24:54  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
        InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
        141210  7:24:54 InnoDB: Fatal error: cannot initialize AIO sub-system
        141210  7:24:54 [ERROR] Plugin 'InnoDB' init function returned error.
        141210  7:24:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
        141210  7:24:54 [ERROR] Unknown/unsupported storage engine: InnoDB
        141210  7:24:54 [ERROR] Aborting

        141210  7:24:54 [Note] /usr/libexec/mysqld: Shutdown complete

        141210 07:24:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
        141210 07:25:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
        141210  7:25:44 [Note] Plugin 'FEDERATED' is disabled.
        141210  7:25:44 InnoDB: The InnoDB memory heap is disabled
        141210  7:25:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
        141210  7:25:44 InnoDB: Compressed tables use zlib 1.2.3
        141210  7:25:44 InnoDB: Using Linux native AIO
        141210  7:25:45  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
        InnoDB: Warning: io_setup() attempt 1 failed.
        InnoDB: Warning: io_setup() attempt 2 failed.
        InnoDB: Warning: io_setup() attempt 3 failed.
        InnoDB: Warning: io_setup() attempt 4 failed.
        InnoDB: Warning: io_setup() attempt 5 failed.
        141210  7:25:47  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
        InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
        141210  7:25:47 InnoDB: Fatal error: cannot initialize AIO sub-system
        141210  7:25:47 [ERROR] Plugin 'InnoDB' init function returned error.
        141210  7:25:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
        141210  7:25:47 [ERROR] Unknown/unsupported storage engine: InnoDB
        141210  7:25:47 [ERROR] Aborting

        141210  7:25:47 [Note] /usr/libexec/mysqld: Shutdown complete

        141210 07:25:47 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
        141210 07:32:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
        141210  7:32:49 [Note] Plugin 'FEDERATED' is disabled.
        141210  7:32:49 InnoDB: The InnoDB memory heap is disabled
        141210  7:32:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
        141210  7:32:49 InnoDB: Compressed tables use zlib 1.2.3
        141210  7:32:49 InnoDB: Using Linux native AIO
        141210  7:32:49  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
        InnoDB: Warning: io_setup() attempt 1 failed.
        InnoDB: Warning: io_setup() attempt 2 failed.
        InnoDB: Warning: io_setup() attempt 3 failed.
        InnoDB: Warning: io_setup() attempt 4 failed.
        InnoDB: Warning: io_setup() attempt 5 failed.
        141210  7:32:51  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
        InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
        141210  7:32:51 InnoDB: Fatal error: cannot initialize AIO sub-system
        141210  7:32:51 [ERROR] Plugin 'InnoDB' init function returned error.
        141210  7:32:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
        141210  7:32:51 [ERROR] Unknown/unsupported storage engine: InnoDB
        141210  7:32:51 [ERROR] Aborting

        141210  7:32:51 [Note] /usr/libexec/mysqld: Shutdown complete

        141210 07:32:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
        141210 07:33:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
        141210  7:33:08 [Note] Plugin 'FEDERATED' is disabled.
        141210  7:33:08 InnoDB: The InnoDB memory heap is disabled
        141210  7:33:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
        141210  7:33:08 InnoDB: Compressed tables use zlib 1.2.3
        141210  7:33:08 InnoDB: Using Linux native AIO
        141210  7:33:08  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
        InnoDB: Warning: io_setup() attempt 1 failed.
        InnoDB: Warning: io_setup() attempt 2 failed.
        InnoDB: Warning: io_setup() attempt 3 failed.
        InnoDB: Warning: io_setup() attempt 4 failed.
        InnoDB: Warning: io_setup() attempt 5 failed.
        141210  7:33:11  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
        InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
        141210  7:33:11 InnoDB: Fatal error: cannot initialize AIO sub-system
        141210  7:33:11 [ERROR] Plugin 'InnoDB' init function returned error.
        141210  7:33:11 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
        141210  7:33:11 [ERROR] Unknown/unsupported storage engine: InnoDB
        141210  7:33:11 [ERROR] Aborting

        141210  7:33:11 [Note] /usr/libexec/mysqld: Shutdown complete

        141210 07:33:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
        141210 07:34:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
        141210  7:34:02 [Note] Plugin 'FEDERATED' is disabled.
        141210  7:34:02 InnoDB: The InnoDB memory heap is disabled
        141210  7:34:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
        141210  7:34:02 InnoDB: Compressed tables use zlib 1.2.3
        141210  7:34:02 InnoDB: Using Linux native AIO
        141210  7:34:02  InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
        InnoDB: Warning: io_setup() attempt 1 failed.
        InnoDB: Warning: io_setup() attempt 2 failed.
        InnoDB: Warning: io_setup() attempt 3 failed.
        InnoDB: Warning: io_setup() attempt 4 failed.
        InnoDB: Warning: io_setup() attempt 5 failed.
        141210  7:34:05  InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
        InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
        141210  7:34:05 InnoDB: Fatal error: cannot initialize AIO sub-system
        141210  7:34:05 [ERROR] Plugin 'InnoDB' init function returned error.
        141210  7:34:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
        141210  7:34:05 [ERROR] Unknown/unsupported storage engine: InnoDB
        141210  7:34:05 [ERROR] Aborting

        141210  7:34:05 [Note] /usr/libexec/mysqld: Shutdown complete

        141210 07:34:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Please help me, it's driving me crazy.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,834

Re: Can't start Mysql

You can try, as proposed, innodb_use_native_aio = 0

I don't think php 5.6 or phpMyAdmin requires MySQL 5.5 (especially as php-mysqlnd don't use libmysqlclient)

Probably simpler to revert to working version.

yum --disablerepo=remi* shell
> remove compat-mysql51
> downgrade mysql-libs mysql mysql-server
> run

Else you probably need to create a new empty database and restore a logical dump.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

3 Reply by xSecure (edited by xSecure 2014-12-10 16:57:18)

  • Registered: 2014-12-10
  • Posts: 2

Re: Can't start Mysql

Remi wrote:

You can try, as proposed, innodb_use_native_aio = 0

I don't think php 5.6 or phpMyAdmin requires MySQL 5.5 (especially as php-mysqlnd don't use libmysqlclient)

Probably simpler to revert to working version.

yum --disablerepo=remi* shell
> remove compat-mysql51
> downgrade mysql-libs mysql mysql-server
> run

Else you probably need to create a new empty database and restore a logical dump.

Thanks for the super-fast resp!!
I'll try and tell later.

UPDATE:

Those commands you showed me, didn't work... It was showing alot of errors.

I had to erase mysql and do a fresh install using BASE repo.
Here are the steps. 

First: "yum erase compat-mysql* mysql*"
By default, it was installing the mysql server using Remi repo, therefor, i wanted to install it using BASE Repo.

Second: "yum --disablerepo=remi install mysql-server" << This will install mysql, not the latest version tho.

Third: "service mysqld start" << Now working with no problems!

Optional!!

4th: "mysql_secure_installation" << Use this to configure Your Mysql. (Root Password, allow connection from outside...)

Now it works, still didn't test phpMyAdmin.
UPDATE: The error remains, i read that previous version of PMA won't requiere me to apdate MYsql.(Version: 4.2.2). So i'll just reinstall PMA. Thank god this is new installation with no databases.
Cheers.