[lxc-users] MySQL Unable to install on 14.04 Container

[Fajar A. Nugraha]

Adding the list back to cc.

On Thu, Jul 6, 2017 at 5:57 AM, Gabriel Marais <gabriel.j.marais at gmail.com>
wrote:

> Fajar,
>
> Here is an extract from my log file, /var/log/mysql/error.log
>
> 170705 22:52:42 [Warning] Using unique option prefix myisam-recover
> instead of myisam-recover-options is deprecated and will be removed in a
> future release. Please use the full name instead.
> 170705 22:52:42 [Note] Plugin 'FEDERATED' is disabled.
> 170705 22:52:42 InnoDB: The InnoDB memory heap is disabled
> 170705 22:52:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 170705 22:52:42 InnoDB: Compressed tables use zlib 1.2.8
> 170705 22:52:42 InnoDB: Using Linux native AIO
> 170705 22:52:42  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.
> 170705 22:52:45  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
>


That last line should be pretty obvious. Did you read this line? Did you do
what it says?



> 170705 22:52:45 InnoDB: Fatal error: cannot initialize AIO sub-system
> 170705 22:52:45 [ERROR] Plugin 'InnoDB' init function returned error.
> 170705 22:52:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
> failed.
> 170705 22:52:45 [ERROR] Unknown/unsupported storage engine: InnoDB
> 170705 22:52:45 [ERROR] Aborting
>
> 170705 22:52:45 [Note] /usr/sbin/mysqld: Shutdown complete
>
>
I assume you're using lxd with the default zfs storage pool?
zfs does not support native aio or directio. Newer versions of mariadb (and
probably mysql as well?) automatically detect if the underlying filesystem
is uncapable of it, and activate the necessary setting to keep it running.
You're using an old mysql version, thus the need of manual setting.

-- 
Fajar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.linuxcontainers.org/pipermail/lxc-users/attachments/20170706/c8c61fd7/attachment.html>