All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Can't install MySQL Server
Okay I just got a new VPS from EDIS in Sweden, already got one there running nginx, PHP and MySQL
As soon as I rebuilt it and reset the password, updated APT repositories, etc.. I installed everything with
apt-get install nginx php5-fpm mysql-server php5-mysql
It installed everything except mysql-server-5.5 which fails with this
140506 16:39:21 InnoDB: Using Linux native AIO
140506 16:39: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.
140506 16:39: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
140506 16:39:24 InnoDB: Fatal error: cannot initialize AIO sub-system
140506 16:39:24 [ERROR] Plugin 'InnoDB' init function returned error.
140506 16:39:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140506 16:39:24 [ERROR] Unknown/unsupported storage engine: InnoDB
140506 16:39:24 [ERROR] Aborting
I tried adding innodb_use_native_aio = 0 to my.cnf but it fails when starting it. Also tried using my-small.cnf from the doc examples folder with/without innodb_use_native_aio = 0 but that fails too
There's nothing in /var/log/mysql.(err/log)
It works fine on my other VPS, but when I ran upgrade it says there's upgrades to mysql-server-5.5 so I haven't upgraded that.
Is it probable there's just something wrong with the package? Can I install an older version from APT?
Comments
Disable InnoDB and then try.
EDIT : Add skip-innodb under [mysqld] in my.cnf and then restart the MySQL server
Tried that, it still fails on startup
Perhaps something to do with, http://forum.openvz.org/index.php?t=msg&th=10181&goto=47380&#msg_47380
Yeah I found that, step 1 doesn't work
Trying #2 now
Edit: Edited the value for #2 in /etc/sysctl.conf and rebooted but it didn't work, tried modifying the file manually but it says access denied
Probably might need to ask your host to increase the value at /proc/sys/fs/aio-max-nr to something larger
Is there a my.cnf option to change the number of max instances?
I don't think so, contact the host with the link to that openvz forum post and they should be able to fix it up.
Thanks for your help. I tried the same thing on my OVH box and it installed fine, even with the same aio-max-nr
In the end I've just gone ahead and installed MariaDB instead which works fine
Problem kinda solved
Thanks again